Prestashop exported products and excel

[Miguel86]

Hi:
The CSV exported by prestashop has 2 columns of price, base price and final price (with VAT)

 

The problem is that in  the CSV looks like this the end of the line:

First field base price, second final price, quantity, state

 

"5.371901";"6.5";"0";"1";

 

It's nice to have all this information the problem is that when i open it with excel this .CSV the price are completely broken due the usage of dots and commas for miles and decimals.

 

Is possible to change somewhere the prestashop configuration so this does not happend? because on the front end the price is displayed with commas not with dots (decimal part).

 

I hope i explained my problem fine.

 

Thanks in advance.

[musicmaster]

The problem you are facing is probably something different: Prestashop does not use Excel's default field separator - that is the comma - but the semicolon instead. And Excel often does not provide the option to use a different separator.

 

You can get around this problem by using Open Office Calc. You can also rename the .csv file into a .txt file and import it as such into Excel. That will force Excel to ask you always for the separator.