I cant use the CSV file to Import products

[ibrahimkoky]

hello

I downloaded the CSV file and tried understand the fields but it I couldn't.

I w.atched this v.i.d.e.o about uploading the CSV  file http://www.youtube.com/watch?v=1Yk5pa1i_aM

but the CSV file in the v.i.d.e.o is completely different from the one I downloaded from my back office.

 

 

 

[Bill Dalton]

Have you seen this,

http://doc.prestashop.com/display/PS14/Exploring+PrestaShop's+Tools

 

I think you will love it.

[planewrench]

Prestashop exported .csv files use a semicolon to separate fields (delimiter), Excel opens .csv files with the default Windows list separator of a comma. You can change the default  Windows list separator by going into the Control Panel, then into Region and Language, on the Formats tab, select Additional Settings, then on the numbers tab you can change the default List Separator from a comma to a semicolon, then hit apply. Now when you open a .csv file with Excel, the fields will be in their  prospective columns as the video shows.  

Another way is to use Open Office Calc to work with .csv files, as you can define the delimiter as a semicolon prior to opening each file. And another way, this link explains how to define the delimiter when using a .csv in Excel on a file by file basis, just check semicolon instead of comma as they show for the delimiter.

http://superuser.com/questions/407082/easiest-way-to-open-csv-with-commas-in-excel

Edited December 9, 2013 by planewrench (see edit history)

[ibrahimkoky]

planewrench

worked perfect, thanks alot

[ibrahimkoky]

Bill Dalton

Thank you

[ibndawood]

Hi Ibrahim,

 

This is another Ibrahim here. Yes, as planewrench explained its about identifying the field separators and row separator. Once you identify them you should be able to import them easily. Also once you import, you will be able to map the fields in the CSV to the existing fields in the database. 

 

Thanks,

Ibrahim