importing excel data .. several fields into product description

[davidfarndon]

Hmm ..

I have been presented with an excel spreadsheet where 11 columns are, in effect, bullet points for each product. (some products don't use all 11)

can anyone point me in the direction of how I bring the data in these columns into the product description as bullet points?

The spreadsheet also has various colours (it's furniture) on products which are shown in the spreadsheet as separate products .. I am assuming there is no way I can make these generate variations of one product using drop downs etc.,

too big an ask for importing?

[rookers]

Hi
In Excel you can "glue" the columns together, along with a bit of HTML, to give you a single cell for each row to import.

So, here is an example
if you have Feature 1 in column A, and feature 2 in column B and feature 3 in column C, you would put your joined up answer in column D like this:

="!!<<ul><li>"&A2&"</li><li>"&B2&"</li><li>"&C2&"</li></ul>>!!"

So what this does is create a string that starts off with the sellerdecjk HTML tag, which is !!<
then it starts an unordered List <ul>
then each of your data cells goes in between the <li> and </li>
etc and ends up closing the list and closing use of HTML </li></ul> >!!

So you would drag that formula down to the bottom, and so it column D you would have the single cell to import into sellerdeck. Once imported you would have a bullet point list in your product description.

Hope that helps.

[Andy@codepath]

Hi David. If you have difficulty doing this via the standard import, give me a call. We could get this done for you fairly easily.