Problem with Multiple value separator when importing csv file with products

[mtblanche]

Hi

 

I want to upload multiple categories or pictures at once using the csv file. 

 

This is an example:

 

I want the product to be associated with 2 categories hence: ;iPods,Laptops;

 

This is the complete line form the CSV file entry, but it doesn't want to work.

 

DOESNT WORK - Multiple value separator

 

7;1;Shure SE210 Sound-Isolating Earphones for iPod and iPhone;iPods,Laptops;125;2;80;1;;;41426;43465;RP-demo_7;RF-demo_7;Shure Online Store;Shure;1234567890123;;0;0.1;0.1;0.1;0.040793;15;1;;;;;<p>New design.</p>;<p>New design.</p>;Headphones;Meta title-ShureEarphones;Meta keywords-ShureEarphones;Meta description-ShureEarphones;Shure-SE210-Sound-Isolating-Earphones-for-iPod-and-iPhone;In Stock;Current supply. Ordering availlable;1;;2013-03-01;1;;0;;0;new;0;0;0;0;0;

 

WORKS (single entry)

 

7;1;Shure SE210 Sound-Isolating Earphones for iPod and iPhone;iPods;125;2;80;1;;;41426;43465;RP-demo_7;RF-demo_7;Shure Online Store;Shure;1234567890123;;0;0.1;0.1;0.1;0.040793;15;1;;;;;<p>New design.</p>;<p>New design.</p>;Headphones;Meta title-ShureEarphones;Meta keywords-ShureEarphones;Meta description-ShureEarphones;Shure-SE210-Sound-Isolating-Earphones-for-iPod-and-iPhone;In Stock;Current supply. Ordering availlable;1;;2013-03-01;1;;0;;0;new;0;0;0;0;0;

 

Any ideas why?

 

 

Prestashop version: 1.5.6.2

Edited March 14, 2014 by mtblanche (see edit history)

[TreeTheme Dev]

Try maybe with  ;"iPods,Laptops";

[mtblanche]

It didn't work. Thank you though.

[mtblanche]

Is this a bug in prestashop? I have done the upload exactly according to the manual and tried many modifications, but it is not working

[kolani]

anyone figured/resolved this issue above... i'm facing the same thing with Multiple value separator causing problem rather than fixing it!

[kolani]

ok, i found a workaround.... just use ^ instead of comma ',' as a field separator in your csv. and then configure your back office import Multiple value separator character to be ^ and remove all other commas in your csv... it should work and it correctly mapped the products to the multiple categories, etc.

 

regards