You can create variations of your products through Skubana's Products module using any of two ways:

  1. Importing your current products through a Microsoft Excel template (making edits, if necessary, before the actual file upload to Skubana). To download the file, click here.
  2. Entering your product variations one by one.

To Create Product Variations by Batch

If you choose to create your variations using a Microsoft Excel worksheet, complete the following steps:

  1. On the toolbar, click Products.
  2. On the Products page, click Import/Export, then Import Products.

3. On the Product Import window, click the download link for our Product Import Excel Template and save the file to your computer.

4. Open the template using Microsoft Excel or any equivalent spreadsheet software, then click the file's Core Products tab.
5. Enter the required information for the Products Import sheet, e.g. the Master SKU, virtual SKU, name, and brand.

Whatever the first line reads in you Excel worksheet, Skubana will give every succeeding line for that variation the same information and attribute.

Below is an example of how your spreadsheet should look like when you are finished.

Note that each Master SKU is a different product and the Virtual SKUs are all the same product.

IMPORTANT! You should give each variation its own unique Master SKU. For each variation of a product, you can have the same Virtual SKU for each line.

6. Once you're done entering your products into the Excel template, go back to the Product Import window that you opened in Step 3, then click Select to look for the file on your computer.
7. Click Continue to start uploading the file to Skubana.
8. Once uploading is completed, Skubana will generate a summary report on your uploaded products.

NOTE: To make it easier for you to complete the Excel template, you may want to download a filled-up sample here.

To Manually Create Product Variations

To create your product variations one by one through the Products module, follow the steps below:

  1. On the toolbar, click Products.
  2. On the Products page, click New Product.

3. On the New Product page, click Product Variations.
4. On the New Virtual Product page, enter at least the product's brand, name, and virtual SKU.

Once you've entered all the required information, click Continue.

5. Select the attribute group you want to work with from the list, then start creating your product variations by entering their details, dimensions and attributes.

6. Click Save. 

Repeat Steps 3-6 until you have completed creating all your product variations.

NOTE: If you have not yet created an attribute group, click the Add (+) icon on the right to add new attribute groups, or categories, for your product variations.

Did this answer your question?