ShopifyGuide

Fix Shopify CSV prices with commas or currency symbols

Shopify reads Variant Price, Variant Compare At Price and Cost per item as plain numbers with a dot as the decimal separator. Spreadsheets set to a European locale write "19,90", supplier exports add "$" or "€", and big prices get a thousands separator. Shopify then refuses the row or imports the wrong price.

Why it happens

  • Excel or LibreOffice in a French, German or Spanish locale saves decimals with a comma.
  • Supplier and marketplace exports keep the currency symbol ("$12.50", "25.00 EUR").
  • Thousands separators ("1 299,00", "1,299.00") are not allowed in the price columns.

Broken example

Handle,Title,Option1 Name,Option1 Value,Variant SKU,Variant Price,Variant Compare At Price
classic-tee,Classic Tee,Size,S,TEE-S,"19,90",€25.00
classic-tee,,,M,TEE-M,$19.90,
oak-table,Oak Table,Title,Default Title,TAB-1,"1 299,00",
cafe-mug,Cafe Mug,Title,Default Title,MUG-1,"1,250",

Corrected file

Handle,Title,Option1 Name,Option1 Value,Variant SKU,Variant Price,Variant Compare At Price
classic-tee,Classic Tee,Size,S,TEE-S,19.90,25.00
classic-tee,,,M,TEE-M,19.90,
oak-table,Oak Table,Title,Default Title,TAB-1,1299.00,
cafe-mug,Cafe Mug,Title,Default Title,MUG-1,12.50,

Check your own file in seconds

The fixer converts every unambiguous price in one click ("19,90" → 19.90, "€25.00" → 25.00, "1 299,00" → 1299.00) and marks values like "1,250" for manual review instead of guessing.

How to fix it

  1. Keep only digits and one dot: 19.90, not 19,90 or $19.90.
  2. Remove thousands separators: 1299.00, not 1 299,00 or 1,299.00.
  3. Check ambiguous values by hand: "1,250" can mean 1250 or 1.25 — only you know the real price (here it was 12.50).
  4. Leave Compare At Price empty when there is no sale price; do not write 0.

Shopify documents the expected format in its common product import issues page. Checking is free and your file never leaves your browser; applying fixes and downloading the corrected file take CSV Viewer Pro or a one-time 2,99€ 24-hour pass.

Other Shopify CSV problems