Problem importing file…csv woocomerce

Hello,

If you are using the built-in product importer, please make sure to use the right format: https://docs.woocommerce.com/document/product-csv-importer-exporter/

If you have existing products that are working properly, the easiest way is export them into CSV, replace the values, and import the file.

The easiest way to get the correct field format for the CSV is to create a product with colours and sizes then export it – you will see how to set up the file correctly.

I created some products in colors, I exported and then imported them. The colors and products do not appear

Can you show us the CSV file?
Did you use the same ID on the new products to import them?

Yes, I will share with you the file that was imported and exported, and the colors did not appear

??????,?????,"??? ?????? (SKU)",?????,"?? ?????","?? ?? ??????","??????? ????? ?? ????????","??? ????",?????,"????? ??? ??? ???????","????? ????? ??? ???????","???? ???????","??? ???????",??????,???????,"?????? ???? ???????","??????? ??????? ???????","???? ???? ?????","????? (kg)","????? (cm)","????? (cm)","???????? (cm)","?????? ???????? ????????","?????? ????? ??????","??? ???????","????? ?????????",?????????,??????,"??? ?????",?????,"???? ???????","???? ??? ?????? ???????",????,"?????? ???????","?????? ???? ???","?????? ???????","???? ?????","?? ????",??????,"??? ????? 1","????/??? ????? 1","??? ????? 1","??? ?????? 1","??? ????? 2","????/??? ????? 2","??? ????? 2","??? ?????? 2"
38,variable,,"???? ????",1,0,visible,"???? ????","???? ????",,,taxable,,1,,,0,0,,,,,1,,,,"????? ??????",,,"https://www.nadorchop.com/wp-content/uploads/2021/07/tr-3490or-men-s-technical-t-shirt-full-comS.jpg, https://www.nadorchop.com/wp-content/uploads/2021/07/tr-3490or-men-s-technical-t-shirt-full-comfort.jpg, https://www.nadorchop.com/wp-content/uploads/2021/07/tr-3490or-men-s-technical-t-shirt-full-comfort-dqz.jpg, https://www.nadorchop.com/wp-content/uploads/2021/07/tr-3490or-men-s-technical-t-shirt-full-comfort-tohty.jpg, https://www.nadorchop.com/wp-content/uploads/2021/07/tr-3490or-men-s-technical-t-shirt-full-comS.jpg",,,,,,,,,0,???????,"????, ????, ????, ????",1,1,????????,"L, M, S",1,1
44,variation,,"???? ???? - ????, l",1,0,visible,,,,,taxable,parent,1,,,0,0,,,,,0,,10,15,,,,https://www.nadorchop.com/wp-content/uploads/2021/07/tr-3490or-men-s-technical-t-shirt-full-comS.jpg,,,id:38,,,,,,1,pa_???????,%d8%a7%d8%a8%d9%8a%d8%b6,,1,pa_????????,l,,1
45,variation,,"???? ???? - ????, m",1,0,visible,,,,,taxable,parent,1,,,0,0,,,,,0,,10,15,,,,https://www.nadorchop.com/wp-content/uploads/2021/07/tr-3490or-men-s-technical-t-shirt-full-comS.jpg,,,id:38,,,,,,2,pa_???????,%d8%a7%d8%a8%d9%8a%d8%b6,,1,pa_????????,m,,1
46,variation,,"???? ???? - ????, s",1,0,visible,,,,,taxable,parent,1,,,0,0,,,,,0,,12,20,,,,https://www.nadorchop.com/wp-content/uploads/2021/07/tr-3490or-men-s-technical-t-shirt-full-comS.jpg,,,id:38,,,,,,3,pa_???????,%d8%a7%d8%a8%d9%8a%d8%b6,,1,pa_????????,s,,1
47,variation,,"???? ???? - ????, l",1,0,visible,,,,,taxable,parent,1,,,0,0,,,,,0,,9,15,,,,https://www.nadorchop.com/wp-content/uploads/2021/07/tr-3490or-men-s-technical-t-shirt-full-comfort.jpg,,,id:38,,,,,,4,pa_???????,%d8%a7%d8%b2%d8%b1%d9%82,,1,pa_????????,l,,1
48,variation,,"???? ???? - ????, m",1,0,visible,,,,,taxable,parent,1,,,0,0,,,,,0,,10,15,,,,https://www.nadorchop.com/wp-content/uploads/2021/07/tr-3490or-men-s-technical-t-shirt-full-comfort.jpg,,,id:38,,,,,,5,pa_???????,%d8%a7%d8%b2%d8%b1%d9%82,,1,pa_????????,m,,1

• This reply was modified 3 years, 7 months ago by Yui.
• This reply was modified 3 years, 7 months ago by Yui. Reason: formatting

Can you send me a file that works in colors and sizes so I can fill it out and use it?

• This reply was modified 3 years, 7 months ago by sadweb.

In column AO you have:

????, ????, ????, ????
%d8%a7%d8%a8%d9%8a%d8%b6
%d8%a7%d8%a8%d9%8a%d8%b6
%d8%a7%d8%a8%d9%8a%d8%b6
%d8%a7%d8%b2%d8%b1%d9%82
%d8%a7%d8%b2%d8%b1%d9%82

I used Google translate to see that the first line is White, blue, black, yellow – but I don’t know what the other lines are supposed to be but they should be the colour of that variation.

Sorry, this is the file

https://docs.google.com/spreadsheets/d/1iMwaivR7N5Rf_Y7FHFcnKqislqzW4Kkg-Iium22VNZY/edit#gid=1720646628

It imports ok for me! Try removing the ID column.

Are you getting an error message?

Do you already have products with those SKUs – including in the trash? If they’re in trash then deleted from there too.

Hi @sadweb ??

I uploaded the .csv file, and it works great for me as well.

Please do follow @seank123 recommendations and let us know how it goes!

As a side note, please bear in mind that Color and Sizes are attributes, and they will be displayed on your variable products.

Cheers ??

Hi @sadweb

We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem! If you have further questions, please feel free to open a new topic.