Help with csv uploads

[cruzing]

I have spend several hours trying to make a csv file that is acceptable for upload.No matter what I do, I just can't get my head to understand what it should look like.I have attached 1 row of a 2000 line supplier csv file,can someone make it into the correct format,so that I can have a good ref point.

I am at my wits end.I'm using notepad++.

 

Category,Sub-Category 1,Sub-Category 2,Brand,Product Code,Date Updated,Status,Qty on Hand,Product Name,Selling Unit,Cost to Etailers,MSRP,MAP,Etail margin,Short Description,Product Features,Ingredients,Color,Scent,UPC Code,Individual Product Dimensions (inches),Length (inches),Width (inches),Height (inches),Image,Product Weight (LBS),Country of Origin,

 

Household and Kitchen,"Reusable Bags, Totes & Accessories",Shopping bag,3B Bags,3BB-PRODUCEP2,1/21/2012,Available,45,"Produce Bag, Reusable, 3 bags per Pack. This multi-pack contains 2 packs.",Multi-Pack,7.72,14.50,13.98,87.82%," Throw away your worries and bring an end to plastic bag waste with 3B Reusable produce bags! Sustainable and functional, 3B eco bags simplify and improve produce transport from the market to your kitchen. Developed by three women familiar with the grocery store experience, 3B bags was born to be practical while helping to cut down on unnecessary plastic bag waste. Durable, breathable, machine washable and quick drying, these produce bags have it all. ",Machine washable<li> Sustainable and eco friendly alternative to plastic bags <li> Breathable yet durable fine nylon mesh construction (22lb. load capability) <li> Convenient drawstring closure <li> Virtually weightless and transparent for grocery store ease ,"Fine nylon mesh, Dependable drawstring ",White Mesh,,899133002124,8 x 3.5 x 1,8,3.5,1,http://www.honestgreen.com/images/catalog/3bb-produce-a.jpg,0.1,China,

 

Sorry I was not allowed an upload of csv/excel file

Thank You

[superprg]

Remove the comma after end of each line

 

New file should be

 

Category,Sub-Category 1,Sub-Category 2,Brand,Product Code,Date Updated,Status,Qty on Hand,Product Name,Selling Unit,Cost to Etailers,MSRP,MAP,Etail margin,Short Description,Product Features,Ingredients,Color,Scent,UPC Code,Individual Product Dimensions (inches),Length (inches),Width (inches),Height (inches),Image,Product Weight (LBS),Country of Origin

 

Household and Kitchen,"Reusable Bags, Totes & Accessories",Shopping bag,3B Bags,3BB-PRODUCEP2,1/21/2012,Available,45,"Produce Bag, Reusable, 3 bags per Pack. This multi-pack contains 2 packs.",Multi-Pack,7.72,14.50,13.98,87.82%," Throw away your worries and bring an end to plastic bag waste with 3B Reusable produce bags! Sustainable and functional, 3B eco bags simplify and improve produce transport from the market to your kitchen. Developed by three women familiar with the grocery store experience, 3B bags was born to be practical while helping to cut down on unnecessary plastic bag waste. Durable, breathable, machine washable and quick drying, these produce bags have it all. ",Machine washable<li> Sustainable and eco friendly alternative to plastic bags <li> Breathable yet durable fine nylon mesh construction (22lb. load capability) <li> Convenient drawstring closure <li> Virtually weightless and transparent for grocery store ease ,"Fine nylon mesh, Dependable drawstring ",White Mesh,,899133002124,8 x 3.5 x 1,8,3.5,1,http://www.honestgreen.com/images/catalog/3bb-produce-a.jpg,0.1,China

[cruzing]

Thank You NVEDIA,for such a quick reply.You wouldn't believe how many diif combinations I tried.Have a great day.

[superprg]

No problems!

[Xavier du Tertre]

Nvedia,

 

As you should have understood by now, PrestaShop is an open-source software. Its success lies mainly in the community's implication to publicly solve installation/configuration problems or bugs.

 

You obviously didn't read the forum rules. Please do urgently (here). If you want to participate to PrestaShop's success (and thus to your own business'), you will have to stop asking members to "ping" you and start helping them right here.

 

Cheers.