Import Shopify Products with Multiple Variants using a CSV file

In this technical guide, we will show you how to import 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.

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 critical data is missing, your import process may fail. To ensure success, refer to the demo CSV file provided 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, the first row will be interpreted as the initial variant when adding product variants.
3. You only need the Title column when making a CSV file to import new products. However, if adding different product variants, you must include the Handle column.
4. In the next row, set the Handle column to 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 the necessary details, such as variant inventory, variant grams, variant SKU, variant SRC, etc. Leave blank any identical columns across all variants; the data from the first variant will be applied automatically.

To learn more about variant-related columns, refer to the article Shopify Products – Available Columns For Export And Import.

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.

For detailed steps on importing products to your Shopify store, refer to the article, Import / Export Shopify Products with StoreRobo.