Import from Mijoshop HTML characters

  • Posts: 53
  • Thank you received: 1
  • Hikashop Essential
1 week 5 days ago #314598

Hello I have one problem with imported products and categories from Mijoshop
After import, all product and category descriptions have displayed HTML character in fronted, like, <p>, <span ... , stile ...
Is there any way to remove in bulk all those characters from products and category descriptions? Maybe some SQL command to execute to remove them? Maybe some other solution?
Thank you

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

  • Posts: 67916
  • Thank you received: 10111
  • MODERATOR
1 week 5 days ago #314609

Hi,

You would need to do that via your PHPMyAdmin with a function you would first have to add:
stackoverflow.com/questions/3678980/is-t...decode-html-entities
Then you could just run a MySQL query with that function.
For example:

UPDATE #__hikashop_product SET product_description = HTML_UnEncode(product_description);
where #__ is to be replaced by the prefix of your tables.

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

Time to create page: 0.052 seconds
Powered by Kunena Forum