Import Shopify Products with Multiple Variants using a CSV file

In this technical guide, we will lead you through the process of importing Shopify products with multiple variants using the StoreRobo Import Export Suite.

You can download a sample CSV file from the link given below. This will serve as a blueprint for structuring your own CSV file. The provided sample file includes a product example with variations. Since your import will likely have many more products, remember to remove the sample product and its variations before using the file for your import.

>> Download sample CSV

Setting up the import of a CSV file is a crucial step in importing various data types. If the columns are improperly named or if there is missing critical data, there’s a high chance that your import process may fail. To ensure success, you can refer to the provided demo CSV file as a guide for preparing your own CSV file.

1. Structuring the CSV: Refer to the demo CSV as you structure your file. Ensure all columns are correctly named, and no critical data is missing to avoid import failures.
2. Inserting Variant Data: Each variant’s data should be input in separate rows. It’s important to note that Shopify considers all products as variants, regardless of whether they have any. Therefore, when adding product variants, the first row will be interpreted as the initial variant.
3. When making a CSV file to import new products, you only need to have the Title column. However, if you’re adding different variants of a product, you’ll also need to include the Handle column.

>> Available data types

4. In the next row, set the Handle column the same as the first variant (All variants will have the same product handle).
5. Skip the Title, Body (HTML), Vendor, Product Category, Type, Tags columns.
6. For each variant, fill out necessary details like Variant inventory, Variant grams, variant SKU, Variant SRC, etc. Leave blank any columns that are identical across all variants; the data from the first variant will be applied automatically.

>> Know more about variant-related columns

7. Follow the steps 4 to 6 for all variations of the products.

In the CSV file, you’ll find columns such as Option 1 name, Option 1 value, option 2 name, Option 2 value, and so forth. These columns play a crucial role in precisely outlining the distinctions between various product variations.

• Option 1 Name – This serves as the title for each variation category. For instance: Title, Color, Size, and others.
• Option 1 Value – This field represents the specific value corresponding to the name. If “color” is selected as the name, you can assign values such as red, blue, green, and more.

Ensure that each row includes only one name or value, and proceed to define the next variation in subsequent rows. Also, there is no need to repeat the Option Name for every variant.

If you are utilizing identical data types across all variations, there is no necessity to populate the same data for each row. You can simply input the data for the first variant and it will be automatically applied to all other variants.

For instance, if you are using a single image for all variants, only specify the SRC attribute for the first variation and leave subsequent columns empty.

Once the CSV file is ready as indicated, you can proceed with the standard product import steps to efficiently import the data into your WooCommerce Store.

1. Install StoreRobo Import Export Suite.
2. Under the import section, select the import file.
3. Select the data type as products and click on Proceed.
4. Select an import template, set up filters, and select the import options.
5. Finally, click on Import to begin the import process.

>> Know more on product import in Shopify