Hi all,

I apologize if this is not the correct category for this topic.

A team member of mine is trying to do a mass import of products via CSV onto the site. Everything flows correctly, but the long Product Description does not keep the line breaks and spaces from the CSV. It ends up bundled completely together into a single paragraph instead of separated into different lines like it was previously in the CSV.

Is it the nature of the CSV file that wipes out this text format? Please let me know if any more info is needed.

Thanks,
Mike

Hi, it really depends on your data, and where (what kind of document) you are copying from.
For a line break to show on your website, it would need to have the required html <br> and I suspect your data doesn't have that.

Perhaps there is a way to fix this in bulk, before uploading, but without knowing much about your data, it's hard to say.

Thanks,
David

From what it sounds like, the way to fix it in bulk would be to just modify the CSV file we import into the site. The "Long Product Description" is a column in the file we import with a header called "pLongDescription". There is a description for each row/product on this sheet.



Would the solution be to add in the HTML <br> tags at the end of each desired sentence in the Long Description of the CSV file and then reimport?

I hope this provided more context.

Thanks,
Mike

Hi, yes, you could manually insert those br tags where you need them, but where are you getting the data from?
Perhaps it could be provided in html, or if it's "rich text", like a word document for example, there are tools to convert that to html
https://wordtohtml.net/convert/rtf-to-html for example.

I was more interested in the origin of your info, rather than the process you are using to upload it.

Thanks,
David