import-export variation product issue

Hello @oraura1!

Please consider following Grigorij’s suggestion from this thread which solved a similar issue. ?? https://www.ads-software.com/support/topic/imported-woocommerce-variation-are-not-showing-up/

If that doesn’t work then please share the CSV file with us so we can investigate further. You can use an online file share like Google Drive, DropBox, etc for sharing the file.

Cheers!

https://docs.google.com/spreadsheets/d/1TZTvBsLVSmJY5r8ISmE7AVsYqWteL-9LriwTc-AewLo/edit?usp=sharing

Here is the file,
the issue starts with the export that does not include the variation sizes and the import which not ticking the field ‘Used for variations’ of the attribute(when ticked and than imported it creates the variations but without the sizes, just “all colors”, “all sizes”).

Hello,

You can create manually a variable product in your site’s wp-admin, then export it (so that you’ll get a CSV file properly) then you can use a copy of that file, edit it, and add the new products and variations you want to import, finally perform the import.

To learn more please check:
— https://docs.woocommerce.com/document/product-csv-importer-exporter/
— https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

Let us know how it goes.

Hi,
Thanks for the quick replay.
The product I am importing from the old site are already with variations.
https://ibb.co/svjDRST <- picture of the definitions

Hi @oraura1

I understand from your comments that the products you are importing from the old site are already with variations, but the exported file does not include the variation sizes and that is where the problem starts.

If the exported data is not proper then it is bound to create problems during the import, so the CSV needs to be corrected first.

In order to make sure you are using the correct format for the CSV, we recommend that you follow these steps:

1. Import the CSV with just one product.
2. Set that product up properly, manually.
3. Once the product is set up perfectly, export it as CSV.
4. Make copies of the exported data and replace the values with data of other products, and import back into your store. That way you’ll have a CSV with the correct formatting.

From the file you shared it seems there are not many products to be imported, so I hope it won’t be a huge task. Let us know how it goes.

I sent a sample of few products, the site have more than 2,000 products in it.
I cannot do it manually.
Even if I do it manually, the ‘Used for variations’ is not marked after the import so the variation data is not shown in the product.

Here is a test with one product 50 variations.
https://docs.google.com/spreadsheets/d/1lticVJHUMagWtiDh93VE666gJAOyMtN4OcEPZruSQek/edit?usp=sharing

exported this specific product, here are pictures of its values:

old site attributes https://ibb.co/711zVWS
old site variations https://ibb.co/LtPZ6yj
old site front end https://ibb.co/pK83xmQ

new site attributes https://ibb.co/6vctzK7
new site variations: https://ibb.co/tz6jC24
new site front end https://ibb.co/zxHc30H

Hello,

Here is a test with one product 50 variations.
https://docs.google.com/spreadsheets/d/1lticVJHUMagWtiDh93VE666gJAOyMtN4OcEPZruSQek/edit?usp=sharing

Thank you for your reply. Would you mind temporarily changing your site language to English, exporting products to CSV and sharing the file again?

Also, it looks like those screenshots didn’t come through. Can you please re-share them?

Link to file in English:
https://docs.google.com/spreadsheets/d/1DMhRudv2HPliYlssjjL9veDTYKKxcrkR_cUzbVZBRgc/edit?usp=sharing
Link to screenshots:
https://postimg.cc/gallery/Qc6cPPp

Hi @oraura1
Thank you for posting the CSV file and the screenshots.

Could you try the solution described in the link below?
https://github.com/woocommerce/woocommerce/issues/19645#issuecomment-704863112

Let us know how it goes.

YESSS!! this is it.
I have replaced all attributes names to latin symbols and it solve the problem.
Not the best solution because now I need to change it, import the products and than go on each attribute and replace back to non latin symbols(is there an easier way?).

Another issue I have noticed is when exporting, the attributes variations are changed to
gibberish. for example:
???? Print
turns to:
%d7%9b%d7%97%d7%95%d7%9c-print

Hello,

I have replaced all attributes names to latin symbols and it solve the problem.

Glad to hear you figured this out.

Regarding the attribute variations there is a custom code on this GitHub page that might help you out.

I hope this points you in the right direction.

• This reply was modified 2 years, 6 months ago by Igor H.

Hi,
Where do I put this code? function.php ?
and do I need to put it in 2 of the sites?

Hello,

Where do I put this code? function.php ?

You can use a plugin like Code Snippets to easily inject code.

and do I need to put it in 2 of the sites?

I would say on the new one, but not sure about that. Please note that the code presented there is from a regular WooCommerce user, not from the WooCommerce developers. So we can’t guarantee it will work for you.

If the issue persists, can you confirm if you’re editing the CSV before importing?

If you’re editing, make sure you avoid Microsoft Excel due to formatting and character encoding issues. You can find the alternatives we recommend here: https://woocommerce.com/document/product-csv-importer-exporter/#what-csv-editors-do-you-recommend

thanks for the replay.
The issue starts at the export(I am using google sheets to edit the file).
When exporting the products the variations on the CSV file are already gibberish before importing.
here is the old site color variations:
https://postimg.cc/87yhvJZY
you can see in this file:
https://docs.google.com/spreadsheets/d/1DMhRudv2HPliYlssjjL9veDTYKKxcrkR_cUzbVZBRgc/edit?usp=sharing
that the variations name changed to gibberish.