Importing previously exported product data has incorrect price (100 times more)

[leo_vermeulen]

When I export the products in my shop and then try to re-import them, without changing anything, I notice that the price is suddenly 100x the previous price, in other words, Euros and cents turn into Euros. E.g. €16,99 turns into €1699,00

Has anybody else experienced this and found the reason behind this?

Thanks, Leo

[Small_Task_Help]

Hi,

This happens because of how the numbers are saved or written down in the file when you export and then import it back

You can try the following solution

1. Check file format
2. Review file content before importing
3. Import setting as well

[aBox_Agency]

Hello There,

Please use €16.99

I think Shopify counts (.) not (,).

Please check once and revert.

Thank you

[leo_vermeulen]

Thanks for the suggestion, but the field in the csv file has neither , or . as a delimiter. Rather, it has e.g. 1699 to indicate 16 euros and 99 cents, so I don't think this can be the problem

Leo

[leo_vermeulen · Accepted solution]

I figured out what was wrong. My PC was set up with a region of UK (I live in the UK and I want my PC's language to be English), but with regional settings for the Netherlands (my webshop operates in the Netherlands). This set the currency delimiter to a comma. The csv file uses a period as the delimiter creating an inconsistency which led to the currency separator to be removed entirely when viewing it in Excel, explaining why 16.99 turned into 1699. I updated all settings to be consistent with UK regional settings and now I can see that the separator is no longer removed. The import now works correctly.

Leo