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.  The Master SKU will be the unique identifier of the product in Skubana.

Here are some helpful tips to assist you in completing 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 (or download the "products" spreadsheet found in your Kick Off email)
  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 product identifier in Skubana and it is tied to everything (sales data, purchase orders, analytics, etc.). 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 ADDITIONAL fields are REQUIRED. Variations are comprised of one parent SKU with multiple child SKUs. Variations are solely used for organizational and product catalog grouping purposes and have no other functionality in Skubana.

  • 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 & 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 spreadsheetNOTE: 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

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.
Did this answer your question?