Hi @Ecomhacker ,
The JSON format for the richtext metafields is a pain, it’s not documented anywhere, even just the JSON schema isn’t available. I think part of the problem is that HTML is far more flexible than the richtext format so there’s no defined way to handle cases where you have HTML that wouldn’t be valid in the rich text format.
If you need to import the data from HTML you could try one of two things:
- There are a few scripts floating on the internet that try to do this conversion from HTML → JSON. You could use those to reformat the data in your spreadsheet and then update the metafields that way
- Use our Ablestar Bulk Product Editor app to update the data, either by copying the HTML into the app or by using a spreadsheet
Here’s a 2-minute video showing how you can bulk edit the rich text metafield, either through the app or with a spreadsheet:
As I mentioned above, the conversion from HTML → JSON involves a bit of guesswork but we’ve been refining it over the last few years and should be able to handle most use-cases. If you do run into an issue you can always undo the changes in the app with a click and reach out and we’ll take a look.
Best,
Daniel