Product CSV Importer not working when the CSV file contains Chinese characters

Hello suitlm

Thank you for contacting Woo support.

I understand that you are facing an issue with the import process after you translate the attributes into the Chinese language.

To find out what is wrong with the import process, I recommend you try the inverse of this process.
First, you create a product with these Chinese attributes in the WP admin dashboard.
Then you export the product into a CSV file.

Once you have the file exported, compare it with the CSV file that you are trying to import.
This comparison will highlight any issues with the CSV format and the Chinese characters.

Let me know about your findings. 🙂

Best regards.

Thread Starter


Hi Zubair,

Thank you for your suggestion. I just tried it and found that it was still an encoding problem. I need to change the encoding of the CSV file to UTF-8 BOM so that it can be correctly recognized.

Best regards.

  • This reply was modified 1 minute ago by suitlm.


This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer