Escape characters in product description

  • Posts: 70
  • Thank you received: 3
4 years 8 months ago #309966

I've got an issue with escape characters on imported data.

This is resolved when the item gets saved by Hikashop - the product description text is correct.

Problem is I have several thousand to deal with.

How do I do this? A screen capture of the products table is below - one of those items has already been manually saved.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 81508
  • Thank you received: 13064
  • MODERATOR
4 years 8 months ago #309980

Hi,

You need to have HTML in your description in the CSV file, not HTML entities.
So you'll have to use the HTMLDecode function ( seotoolsforexcel.com/htmldecode/ ) of your Excel to convert the values of the product_description column. That way, it will import the HTML properly.

The following user(s) said Thank You: virusys

Please Log in or Create an account to join the conversation.

  • Posts: 70
  • Thank you received: 3
4 years 8 months ago #310018

Great - thank you. That put me on the right path. I don't have that function in LibreOffice Calc but I was able to fix the issue with a "search and replace" on the encoded characters.

Have a great evening!

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum