The following article is based on the
According to Ronak, you can solve the aforementioned error by removing the same symbols. The file is validated successfully, but our goal is to import products with ™ and ®.
To achieve this goal,
To find out more characters, follow
At the same time, Khoa TruongDinh proposes using
Also, note that this approach may lead to some problems. According to Fabian Schmengler,
using HTML encoded characters as suggested above works for fields that allow HTML: product descriptions and other WYSIWYG fields. Unfortunately, the aforementioned approach won’t help you with product names. Indeed, you will see the plain text “™” instead of the trade symbol In invoice PDFs if the name is imported with “™”.
To solve the problem, Fabian proposes encoding the input file in UTF-8. Use a text editor like Notepad++ to detect and convert character encoding. Note that it is necessary to use UTF-8 without BOM.
To make the import process even better, we recommend you to use the Improved Import & Export Magento 2 extension. You will still need to encode your input files, but the speed of the import will be dramatically increased. Besides, you can create schedules to run product import automatically according to the plan. For further information about the plugin, follow the link below:
We hope the article was useful. For other Magento 2 tips, check our Cookbook.