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

Shopify Discussion

Topic summary

Issue: Re-importing a product CSV made prices 100x higher (e.g., 16.99 became 1699.00).

Initial suggestions:

  • Verify file format and import settings.
  • Ensure decimal separator uses a dot (.) rather than a comma (,).

Clarification: The exported price appeared without a decimal when viewed (e.g., 1699). This pointed to a formatting/locale interpretation issue rather than Shopify changing values.

Root cause: PC regional settings mismatch. The system language/region was UK, but regional settings were Netherlands (comma as decimal separator). The CSV used a period for decimals. When opened in Excel, the decimal separator was dropped due to the locale conflict, effectively converting 16.99 to 1699.

Resolution: Align OS/Excel regional settings consistently (set to UK in this case). With consistent settings, the decimal separator remained intact and the import preserved correct prices.

Outcome/Status: Resolved. No changes needed in Shopify; ensure locale/decimal settings match the CSV’s decimal format before viewing/importing.

Summarized with AI on December 24. AI used: gpt-5.
1

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

2

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
3

Hello There,

Please use €16.99

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

Please check once and revert.

Thank you

4

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

5

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