Create New Products Using Woo Commerce CSV Importer

Hello Morris,

All the products on your CSV are saved as variations, but there is not variable (or the parent) product under which you can access them. Here’s an example CSV that has both variations and parent variable products: https://github.com/woocommerce/woocommerce/blob/master/sample-data/sample_products.csv

Link to image: https://d.pr/i/AUCNcU

From example CSV file:

Link to image: https://d.pr/i/rkWENp

Alternatively, you can create a new variable product on your store, add some example variations and then use the built-in exporter to see all the fields involved, and the values that go into their respective fields.

Hi
Thanks for the information, I managed to get one product to work that had 1 SKU number for 3 products in a pack that will be sold separately.

If I have four items relating to the same product but it has sizes & colour as variants, and they have all got their own SKU’s.

ie. 156000 (Size 1, Tan), 156010 (Size 1, Black), 156100 (Size 2, Tan) & 156110 (Size 2, Black)

How can I set this up in a spreadsheet so that I can use a variable with variants? I have a number of simlar products and I need to keep the SKUs.

Cheers

Morris

Hi there!

How can I set this up in a spreadsheet so that I can use a variable with variants? I have a number of simlar products and I need to keep the SKUs.

The sample CSV I shared has examples of variations with colors and sizes.

If that doesn’t help your find the exact values that you need, the easiest way forward would be to create one test variable product, export it, and then cross-check the values in the CSV so that you can create a larger pool of products in the CSV by following the example in the test product that you originally exported.