Master SKU

You can build your product catalog in Skubana using the Import Product spreadsheet to import all your product information and create the Skubana MASTER SKU.  

Here are some helpful tips to help you fill in the Import Product spreadsheet.  Please take your time to review and plan how you will build your Product catalog because once products are created in Skubana they cannot be deleted, only 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.
  2. Click on the “Core Products” sheet in the Excel spreadsheet to create single products
  3. In this template, these are the only 4 required fields, everything else is optional:
  • Column A: Master SKU - is your unique SKU in Skubana and it is tied to everything. If you have multiple listings for the same product only make one a “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 Skubana. 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

NOTE: We recommend having a maximum of 4000 products per spreadsheet for maximum efficiency. 

Listing SKU

Listing SKUs are the SKUs used to connect the products to the various sales channels you sell them on. In Skubana 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 Product 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 Skubana
  • 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 Skubana 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

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 Skubana 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 Skubana 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 Skubana 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 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.

Importing Through Spreadsheets

Navigate Products > Import/Export > Import Products.

On this page, download the template. Use this template to create and upload a bulk update file to which you can add products and attributes that are being updated or created. Download the excel file by clicking on it, locate it in your computer’s downloads folder, and open the document.

You will have the option to create a core product / bundles & kits or variations through the spreadsheet. Just remember to be very careful and look at which sheet you are creating each within.

A core product and variation must be created within the core products sheet while the bundles & kits must be created in the bundles & kit spreadsheet.

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 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 Skubana. Upload your saved document via the Select button. Choose whether you would like to update products already synced with Skubana. Press continue and wait for the upload to complete. When the file is finished uploading, Skubana will generate a short report summarizing your uploaded products.

Did this answer your question?