Import CSV with variations

You need to make sure that your variations are piped in your mapping on your CSV file.

So for instance you had a tee shirt as the one product in the attribute:Color column you would pipe the different variables. blue | red | black

That should do the trick.

Can you check my file here so you can tell me what’s wrong :

https://www.sharecsv.com/s/bb95585402f4a884d4f9b44f7aec3d7e/cagoulemilitairehandlenewsku.csv

Thank you !

Option1 is the attribute “color”
Option1 Value is the actual color variation

WC won’t know what OPT1 is. You need to use WC’s headings accordingly. Map it this way.

Correct WC Template

You’ll see further over to the right how variations are piped under the attribute:Color column.

I have uploaded the following CSV for 1 product but it still does not add the product as a variable product but still as a simple product…

https://www.sharecsv.com/s/0f7f681161d323a45f107896dab79d6b/newcolorforum.csv

Any idea why ?

• This reply was modified 5 years, 10 months ago by etienneflorent.

As I understood from your CSV files, all the colors have to be inserted in the same cell, am I right?

First question. You didn’t add tax:product_type heading to the map and tell it that it is a variant so by default it’s going to simply make it a simple product.

Second questions, yes this is called a ‘|’ pipe so you would go red | blue | green and so forth.

ah ok, I thought that this was not obligatory as my store does not require taxes…

LOL no problem. Don’t fret. It doesn’t stand for TAX. It stands for TAXONOMY which is the classification of a CATEGORY

Ok, so I have added tax:product_type

but now after uploading the product it says that the product is out of stock.

Also, the different color variations are not automatically added (it only says that it’s a variable product).

https://www.sharecsv.com/s/47593b683d2fec92483b9a6a102ce6fc/danamecsv.csv

I would like to have WC import each color attribute + image related to each color variation as well without having to do it manually if that’s possible.

Thanks a lot for your great help so far

• This reply was modified 5 years, 10 months ago by etienneflorent.

You have to stop deleting the mapping fields. Just leave the ones that are not relevant empty. Stop deleting them. To add stock for each variable is going to be even more complicated.

However, in order to show inventory you first have to enable manage_stock and say Yes. As for “in stock” you have to leave the Stock_Status in and write “instock” without the quotes.

To address each variable’s quantity will involve a bit of complexity to the stock

You may want to look at using this
https://docs.woocommerce.com/document/product-csv-importer-exporter/

No, I don’t really want to show my inventory.

So I tried to do like you said but now I realized that for each color variation, there is a specific image.

But as you said before for each variation, we need to put them in the same cell (so in the first row)…

So that’s not going to work if I want to import 1 image per color variation…

Any idea how to do that?

Ok, I managed to import using Wp-All Import. Thanks !