Shopify CSV price format error
Shopify's Variant Price column expects a plain decimal number — no currency symbol, no thousands separator, no text. A value like "$24.00" or "24,00 EUR" isn't a formatting nicety Shopify will tolerate; it's not a number as far as the importer is concerned, so the row is rejected rather than imported at the wrong price.
Example
Rejected: $1,299.00
Fixed: 1299.00
How to fix it
- Strip currency symbols and thousands separators from the whole column.
- Standardize on a single decimal point, not a comma, regardless of what locale the source file used.
- Watch for a mixed column — supplier exports that merge feeds from multiple regions often have both "1.234,56" and "1,234.56" in the same file.
Upload your file to Supplier Data Ops to catch this and every other row-level error automatically before you import.