For an instructional video of how to create Master Products via spreadsheet, please click here.

For instructions on how to export existing product info, see this article.

Master SKU

You can build your product catalog in Extensiv Order Manager using the Import Products spreadsheet to import all your product information and create the Extensiv Order Manager MASTER SKU.

Here are some helpful tips to help you fill in the Import Products spreadsheet. Please take your time to review and plan how you will build your Product catalog because once products are created in Extensiv Order Manager they cannot be deleted, they can only be edited or deactivated.

Building Core Products and Variations using the Import Product Spreadsheet:

1. Download the “Import Products” spreadsheet from the dropdown Import/Export button in the Products Module.
    

1. Click on the “Core Products” sheet in the Excel spreadsheet to create single products
   
2. In this template, these are the only 4 required fields, everything else is optional:
   • Column A: Master SKU - is your unique SKU in Extensiv Order Manager and it is tied to everything. If you have multiple listings for the same product only make one “Master SKU" for this product and you can connect multiple listings via the listing SKU spreadsheet.
     NOTE: The same Master SKU cannot be used twice, every Master SKU must be unique
   • Column C: Name - the name of the product.
   • Column H: Brand - the brand the product is associated with.
   • Column U: Active - is this an active product? Please fill out with either a TRUE or FALSE (False will deactivate the product)
     NOTE: If you plan on building out parent-child relationships (Variations) TWO MORE fields are REQUIRED. Variations are comprised of one parent SKU with multiple child SKUs.
   • Column B: Virtual SKU – this is your parent SKU. So if your master SKUs are “Red-Shirt”, “Green-Shirt”, “Blue-Shirt” in column A, then the virtual SKU (parent SKU) for all 3 rows can be “Shirts” so you can encompass them under one parent.
     PLEASE NOTE: YOUR VIRTUAL SKUS AND MASTER SKUS CANNOT BE THE SAME
   • Column E: The attributes – these are the specific characteristic that make it a variation (i.e color, size, etc.) You can choose to call the attribute groups whatever you’d like and in the { } you will indicate the specific options you would like to see available for this attribute group. Example – Color {Azure Blue}

Build Product bundles/kits:

1. Using the “Import Products” spreadsheet, select the second sheet “Bundles & Kits”.
   
2. The required fields for creating Bundles or Kits are:
   • Column A: Master SKU, the unique SKU in Extensiv Order Manager. If you have multiple listings for the same product only make one master SKU for this product and the listings will be connected via the listing SKU spreadsheet
     NOTE: You cannot use the same master SKU twice, each Master SKU must be unique.
   • Column B: Name - the name of the product.
   • Column D: Bundled Item Master SKU & Quantity - what SKU(s) from the core product sheet make up the bundle/kit and how many of each. Please follow format: SKU-123 {10}
   • Column G: Brand - the brand the product is associated with.
   • Column T: Active - is this an active product? Please fill out with either TRUE or FALSE.

Listing SKU

Listing SKUs are the SKUs used to connect the products to the various sales channels you sell them on. In Extensiv Order Manager you must connect your Listing SKUs to the Master SKU. There is no limit to how many Listing SKUs you can attach to the Master SKU. The Master SKU and the Listing SKU can be the same. The Listing SKU for different Sales Channels can also be the same if needed.

Download the “Listing SKU” spreadsheet from the dropdown Import/Export button in the Products Module. You will need to fill out and upload a separate spreadsheet for each Sales Channel.

All fields are required EXCEPT Column E.

• Column A: Master SKU - the unique Master SKU in Extensiv Order Manager.
• Column B: Listing SKU - what the SKU is listed as on the sales channel (i.e. Amazon Seller SKU, eBay- Custom Label).
• Column C: Push Inventory to Channel? - if you want Extensiv Order Manager to send inventory updates to the sales channel.
  NOTE: If the product is an Amazon FBA SKU you will need to set this to FALSE at all times as Amazon controls all FBA inventory.
• Column D: Active - is this an active listing? Please fill out with either a TRUE or FALSE.
• Column E: Fulfillment Latency Days - this number represents the number of days it takes for you to fulfill the order to the customer. The data in this column will only be digested by Amazon and Walmart.

Vendor SKU

Vendor Product Import
First download the “Vendor Product” spreadsheet from the dropdown Import/Export button in the Products Module.

Extensiv Order Manager gives you an option between uploading an individual file for each vendor, or by importing one global file that contains vendor products for any/all vendors at once that will require you to specify which vendor a vendor product is for.

The window that pops up will allow you to download the required Excel template to import the Vendors. Click the link to Download the Excel Template.

Import By Vendor

Global Vendor Import

ALL FIELDS ARE REQUIRED TO BE FILLED OUT EXCEPT COLUMN H & K - YOUR FILE WILL ERROR IF THERE ARE BLANKS. YOU CANNOT DELETE COLUMNS OR ADD COLUMNS, DO NOT CHANGE THE INTEGRITY OF THE FILE

• Column A: Vendor Name - You must select which vendor you are adding this cost for.
• Column B: Master SKU - The Master SKU in Extensiv Order Manager you are adding a cost for.
• Column C: Vendor SKU - This is the SKU your vendor recognizes the product as. It is the SKU included in the Purchase Orders Extensiv Order Manager creates when Auto PO Generations is turned on.

Vendor SKUs must be different for each product if they come from the same vendor - if the vendor SKU is the same but purchased from different vendors then you can add it multiple times for each vendor

• Column D: Active - Set this to “TRUE” if you want Extensiv Order Manager to calculate purchase orders for this product, “False” if you do not want to.
• Column E: Minimum Order Qty - the minimum amount you must order from the vendor. the value must be greater than or equal to 1- cannot be 0.
• Column F: Lead Time - this is the time it takes for the product to get from the vendor to you. This is in calendar days, the value must greater than or equal to 1.
• Column G: Pricing Tiers - Please be very clear with the format. You can leave it as one group of parentheses if you are doing one large pricing tier. EXAMPLE: (1-10000|5.00) The price goes after the |
  If you do not have pricing tiers you can select an arbitrary number that you rarely order the quantity for to serve as the max. For example: 1-10000 (this is defining the first 10,000 orders are the same cost per unit, 10,000 is serving as the max). You can make the number as high as you want so you do not have a cap. If you do have pricing tiers then you can just enter them in this format: (1-100|12.00)(101-200|10.00)
  NOTE: Pricing tiers must start at 1.
• Column H: Units of Measure - This is an optional field, you can leave it blank. If you choose to use it you can just write the name of the measure and how many units go into it. The quantity of units goes into the { }.
• Column I: Is Default - this applies if you are ordering the Master SKU from multiple vendors, you will mark TRUE for the vendor you want to serve as the default when ordering the product. You can leave them all as FALSE if you do not want to specify a default vendor or TRUE if it is just for one.
• Column J: Auto-P.O. Rounding - It is REQUIRED that you choose from one of the three statements below:
  
• Column K: Packaging - This is an optional field. This field is for vendors that need special instructions about packaging this product.

Variation Tips & Tricks

• The difference in this spreadsheet between a core and a variation is that the variation requires a virtual SKU and an attribute group {attribute}.
• For a variation, when the import catches a virtual SKU, it will list the first item with the virtual SKU in the spreadsheet and share that product details (everything but the attribute group {attribute} and master SKU) with the other products containing the same virtual SKU.

Bundles & Kit Tips & Tricks

• You cannot create nested bundles, meaning a bundle/kit of a bundle/kit.
• After entering your product information into the excel template, save the document and return to Extensiv Order Manager. Upload your saved document via the Select button. Choose whether you would like to update products already synced with Extensiv Order Manager. Press continue and wait for the upload to complete. When the file is finished uploading, Extensiv Order Manager will generate a short report summarizing your uploaded products.