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.

Improve this question
2
  • I have same issue let me know if you got solution. Commented Sep 13, 2016 at 9:46
  • You can use the link I provided in my answer. Commented Sep 13, 2016 at 16:31

3 Answers 3

Reset to default
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

Improve this answer
3
  • 2
    The collation of the table should allow UTF-8, though. Perhaps the encoding of the source document is screwed up? Commented Sep 13, 2016 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 Commented Sep 14, 2016 at 7:29
  • After adding ™ for TM, in mini-cart still it shows string ™ instead. Can you help me what I am missing here? Commented May 18, 2018 at 6:25
1

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.

Improve this answer
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.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.