Learn more about what Variants are before reading this article which only explains the structure for importing products that have multiple variants.
Set up your spreadsheet to list products with multiple variants
To ensure that you don’t run into any errors during the variants import process, we’ll walk you through the steps to undertake in understanding and preparing the right format for your CSV or excel sheet upload.
Make sure your CSV data is formatted correctly and it can be mapped to the right field type.
You can download a template here so that you can simply copy/paste your data into it. Click on Build product sheet > Download Product Sheet.
Adapt your product list to the template
Alternatively, you can modify your existing excel/CSV file to match the requirements of the recommended template above.
Column headers and entries must match the standard formatting in the template file.
Here are two examples displaying the ideal structures:
EXAMPLE 1: A fancy shirt in 3 sizes and a fancy hat in 2 sizes
EXAMPLE 2: A fancy shirt in 3 sizes and 2 colors
Guidelines to follow when creating your own spreadsheet
- Each variant is a new row in the excel sheet and has ‘option labels’ and ‘option values’
- Variants of a product have the same product name against them
- Variants of a product must be listed together
- Product and Variant names should not be identical
Once your file is ready, head back to TradeGecko and go to Inventory > → Products and ‘Import New Products’.
You’ll be notified once the process is completed. 😎
Now that you’re ready, read how to import your products in bulk.