May 04, 2016
Yosh M wrote
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.
- 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 Pryshlivskiy
agent
wrote
It seems you've changed a regional setting on your PC.
What format do you have ? see screenshot
What format do you have ? see screenshot
May 06, 2016
Yosh M
wrote
I have not changed anything at all. My configuration is exactly like your screenshot.
Have you tried to reproduce?
Have you tried to reproduce?
May 06, 2016
Alex Pryshlivskiy
agent
wrote
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.
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 M
wrote
CSV works fine, the problem is only with .XLS(X) files
May 06, 2016
Alex Pryshlivskiy
agent
wrote
oops... misprint... could you provide Excel file ?
May 10, 2016
Yosh M
wrote
Attached is the file with which I experienced this issue.
May 11, 2016
Alex Pryshlivskiy
agent
wrote
Thanks!
We'll test it.
We'll test it.
May 11, 2016
Alex Pryshlivskiy
agent
wrote
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/
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 M
wrote
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 Pryshlivskiy
agent
wrote
ok, deal! please reach me via support chat on Friday - from 11 GMT+2 to 16 GMT+2
Thanks for your time! :-)
Thanks for your time! :-)
May 17, 2016
Alex Pryshlivskiy
agent
wrote
Good morning, Yosh!
According to your request.
Could you share your PC today? is it ok for you?
According to your request.
Could you share your PC today? is it ok for you?
May 18, 2016
Yosh M
wrote
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 Pryshlivskiy
agent
wrote
Thanks, please send screenshot and\or video url to my work email.
Thanks for you time, Yosh!
Thanks for you time, Yosh!
May 18, 2016
Alex Pryshlivskiy
agent
wrote
I've sent email to you.