Instant stock status export to CSV decimal points problem

[mihaiww]

Hi

I use Presta 1.6.1.4

I want to export Instant stock status after price.

On presta form the price look ok like :

31,11  but when i export in csv it looks like

31.110.000

 

Please give me a solution because i don't think it is from my regional settings.

Many thanks.

[shokinro]

are you using  Microsoft Excel to open the output CSV file? it might be related to your Excel settings of CSV format, such as separator and currency format.

 

you may try to open it in a normal text editor to see if the output is correct or not.

[mihaiww]

Hi and thanks for your answer.

Fogot to tell this , in notepad or other text editor it look ok 31.110000 but it is exported not like it is on web form with comma , it is exported with dot for decimals and excel it is confuse.

Any ideea how can i change export csv decimal delimiter?

Many thanks again.

[shokinro]

I think the data itself is correct with dot as decimal point. 

if you want to make changes, you may need look at processExport() in following file

 

/classes/controller/AdminController.php