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
- Keep only digits and one dot: 19.90, not 19,90 or $19.90.
- Remove thousands separators: 1299.00, not 1 299,00 or 1,299.00.
- Check ambiguous values by hand: "1,250" can mean 1250 or 1.25 — only you know the real price (here it was 12.50).
- 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.