Adapted from: https://docs.woocommerce.com/document/product-csv-import-suite-importing-product-variations/
Importing Product Variations
It is possible to import variations to your products using the Product CSV Import Suite. To do this you will need to create a CSV with your variations.
Variations are children of variable products. In order to import variations you must first import the parent products.
If you haven’t added these fields to your original CSV, you can input them now and merge your CSV with items already imported.
Create your CSV using the sample – we have created a sample for you to use. Then add the columns required for Variations as shown here. You can find a complete list of variations columns in the column reference document.
If you are planning to import product images for your variations, be sure to read this FAQ.
To map your variations to a product, you must include the ID in the post_parent column or the SKU in the parent_sku, of the parent product. This will tell the importer which product your item is a variation of.
Usually, the minimum columns you’ll need for your variations CSV will be the following:
- parent_sku or post_parent to map to a parent variable product
- sku for the variation
- regular_price / sale_price for the variation
- Columns to map each variation to an attribute of the parent product
Variations are mapped to certain attributes via a meta column prefixed with attribute_.
If, for example, the parent product had a ‘size’ attribute (which was global and found in Products > Attributes) you would use meta:attribute_pa_size as the column name.
For global attributes, the value would be the ‘slug‘ of the attribute. For example, a term called ‘Extra Large’ would likely be ‘extra-large’ in slug form. Use this value.
If the variation is mapped to ‘any’ attribute term, leave the value blank.
If the parent product had a ‘Color’ attribute (which was local and can be found in the product in Product > Product Data > Attributes) you would use
meta:attribute_Color as the column name (note the caps and that we are not using pa_ in the column name).
For local attributes, the value would be the regular value of the attribute. For example, a term called ‘Light Blue’’ would be written exactly like ‘Light Blue’ in the CSV.
Navigate to WooCommerce > CSV Import Suite and click Import Variations.
Choose your file and click Upload file and import.
Check the fields to make sure that all of the columns are mapping to the correct fields in WordPress.
Click Submit. Your product variations should now be imported and ready to go.