Hello @Dangren ,
Are your prices using a comma as the decimal separator? For example: 9,95 EUR
I think Shopify needs the decimal separator to be a period instead. So replacing 9,95 with 9.95 should fix the problem.
Best,
Daniel
Topic summary
Issue: Importing a Shopify product CSV via Excel (Data → From Text/CSV) caused prices to be multiplied by 100 because Excel “ate” the comma used as a decimal separator.
Guidance: Shopify expects a period as the decimal separator (e.g., 9.95 EUR), not a comma. Using periods in the CSV should prevent the 100× price inflation.
Clarification: Even with rounded prices (no decimals), Excel’s parsing still led to misinterpretation when importing the CSV.
Actions: The helper requested a sample of the CSV for review. The poster shared attachments/screenshots showing Excel import settings.
Resolution: The poster changed an Excel import option (as shown in the screenshot), after which prices imported correctly. No Shopify-side setting was required.
Status: Resolved. Key takeaway—ensure the CSV uses periods for decimals or adjust Excel’s import settings so commas aren’t misinterpreted. Images were used to illustrate the Excel setting change.