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 correct 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 (i.e., Product name: Pink Bottle and Variant name: Pink Bottle 1, Pink Bottle 2 and so forth)
- Variants of a product must be listed together
- Product and Variant names must not be identical*
If the product has single or no variants, you can have identical names.
If the product has multiple variations, you cannot have identical names.
Once your file is ready, head back to QuickBooks Commerce 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.