Hi,
- Create an .xlsx file with prices with "," (comma) decimal separator.
- Try to import products, selecting "," as decimal separator in the import manager
- Prices will be imported without decimals, for example 20,22€ will become 2022€
It works fine with .csv, this only happens with excel files.
New
1 vote
Vote
Reply
14 Answers
May 05, 2016
Alex Pryshlivskiyagentwrote
It seems you've changed a regional setting on your PC.
What format do you have ? see screenshot
I have not changed anything at all. My configuration is exactly like your screenshot.
Have you tried to reproduce?
May 06, 2016
Alex Pryshlivskiyagentwrote
Some time we have some issues with regional settings for this operation.
For confirmation - please send my your CSV file.
From one customer we've found another format of cell.
So our QA dep. will have a look at your file.
May 06, 2016
Yosh Mwrote
CSV works fine, the problem is only with .XLS(X) files
May 06, 2016
Alex Pryshlivskiyagentwrote
oops... misprint... could you provide Excel file ?
May 10, 2016
Yosh Mwrote
Attached is the file with which I experienced this issue.
We've tested your file. There is no result.
Could you share you PC and demonstrate issue via TeamViewer ? We are ready right now :-) so we are waiting for you. please reach me via online chat - https://www.prestashopmanager.com/
May 11, 2016
Yosh Mwrote
I cannot today - probably on friday. I need to create copy of database first or a new PS installation to not test on current one.
May 11, 2016
Alex Pryshlivskiyagentwrote
ok, deal! please reach me via support chat on Friday - from 11 GMT+2 to 16 GMT+2
Thanks for your time! :-)
May 17, 2016
Alex Pryshlivskiyagentwrote
Good morning, Yosh!
According to your request.
Could you share your PC today? is it ok for you?
May 18, 2016
Yosh Mwrote
hi.. sorry this slipped my memory... I am really busy lately, I will make a screencast when I get some time and post it here.
May 18, 2016
Alex Pryshlivskiyagentwrote
Thanks, please send screenshot and\or video url to my work email.
Thanks for you time, Yosh!