Adding html to the product description column of the import.csv

Site URL: https://plane-wrasse-xbem.squarespace.com/

Hi, I have recently set up a 7.1 site and want to import my products. I have about 1300 to do. I have downloaded the import.csv and have created a test product that I can import correctly. 

However, I am trying to understand the html that is added to the product details so I can replicate and add it in bulk to my product description column rather than having to go and add it all after and I cannot find anything in the help guides as to why it does it this way. Or a guide to how to do it any other way? 

Has anyone done this?

So far:

My initial productdescription in csv was "This is a beautiful colour denim with a white freckle effect."  Screenshot 1

First export of the product got me exactly the same text. So I then edited the product description on the web page  to Screenshot 2

The export then gave me

<p class="">This is a beautiful colour denim with a white freckle effect.</p><p class="">Great for dungarees, tunics and pinafores.</p><p class=""></p>

I appreciate it no longer uses BR so starting a new  <p class=""> seems to give the extra line

It gives me a straightforward look on the page

I can add  < p class="" style="white-space: pre-wrap;"></p> gives me a space before text etc

Has anyone done any manipulation of the csv file in this way? Any hints or tips or lists out there for what works and what doesn't?

N

Nikki

12 minutes ago, NikkiM said:

I am trying to understand the html that is added to the product details so I can replicate and add it in bulk to my product description column rather than having to go and add it all after and I cannot find anything in the help guides as to why it does it this way. Or a guide to how to do it any other way? 

Hi Nikki

The Product Description is a rich text field so it uses standard HTML to format the text, including paragraphs, titles, bulleted lists, numbered lists and so on. If you aren't familiar with HTML you may want to take a look at w3schools before editing this field.

If you are looking for some examples of how to format the HTML in this field, a good way to do this is to manually add some products to your store, with examples of the different descriptions that you may want to provide (such as washing instructions and fabric composition) and then export these products to a CSV. You can then review the HTML that was added and use it as a template for your imports.

I hope this helps, but if I haven't answered your question, please post back.

1 hour ago, paul2009 said:

Hi Nikki

The Product Description is a rich text field so it uses standard HTML to format the text, including paragraphs, titles, bulleted lists, numbered lists and so on. If you aren't familiar with HTML you may want to take a look at w3schools before editing this field.

If you are looking for some examples of how to format the HTML in this field, a good way to do this is to manually add some products to your store, with examples of the different descriptions that you may want to provide (such as washing instructions and fabric composition) and then export these products to a CSV. You can then review the HTML that was added and use it as a template for your imports.

I hope this helps, but if I haven't answered your question, please post back.

Thanks Paul, I suppose I was hoping for some examples of what is allowed and what is not allowed within the import.csv without having trying to try every permutation.

So <P> works

style=white-space: pre-wrap;  works

But there's a hell of a lot of permutations!! 

Even a list of exclusions would help?

Thanks for getting back to me though

N