7

I have products where it is important to have symbols like ™ and ®, as these are necessary to be with product name. When I tried to import such products, it says "General system exception happened" on "Check Data".

After removing same symbols, file is being validated successfully.

I am using Magento 2.1.0.

  • I have same issue let me know if you got solution. – Jalpesh Patel Sep 13 '16 at 9:46
  • You can use the link I provided in my answer. – Khoa TruongDinh Sep 13 '16 at 16:31
13

Pretty sure it's caused by the fact that those characters are not supported when copied/pasted like this.

I reckon you should use their HTML equivalent instead:

  • ™ : ™
  • ® : ®

The W3C provides a nice character entity reference if you need to find out more characters: https://dev.w3.org/html5/html-author/charref

  • 2
    The collation of the table should allow UTF-8, though. Perhaps the encoding of the source document is screwed up? – philwinkle Sep 13 '16 at 16:00
  • @philwinkle it really depends on what you copy/paste. I faced the issue a few times specially copying stuff from MS Word. Always found it safer to go the HTML code way – Raphael at Digital Pianism Sep 14 '16 at 7:29
  • After adding ™ for TM, in mini-cart still it shows string ™ instead. Can you help me what I am missing here? – DEEP JOSHI May 18 '18 at 6:25
0

For these special characters, we need to encode to its HTML. There is a sites - HTML Entities Encoder / Decoder can help us to encode and decode a piece of text to its HTML equivalent. We also make a reference here.

0

Using HTML encoded characters as suggested by previous answers works for fields that allow HTML and are always used in HTML context.

This is true for product descriptions and other WYSIWYG fields, but not for product names. In invoice PDFs for example you will see the plain text ™ instead of the trade symbol if the name was imported with ™.

Instead, make sure that your input file is correctly encoded in UTF-8. Any decent text editor (such as notepad++) can detect and convert character encoding. Make sure to use UTF-8 without BOM.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.