Why Shopify CSV prices import as 0
Your import "succeeded," but every product came in with a price of 0.00
(or blank). The cause is almost always how the Variant Price column is
formatted. Shopify silently discards a price it can't read as a plain number, so the import
doesn't error — it just zeroes the price.
What Shopify expects
Variant Price must be a plain number like 1299.00
or 19.99. No currency symbol, no thousands separators, no spaces, no text.
The common culprits
- Currency symbols:
$1,299.00or£19.99. The$/£/€makes the value non-numeric. - Thousands separators:
1,299.00— the comma breaks it (and in a CSV a stray comma can even shift your columns). - Locale decimal commas: European spreadsheets export
19,99instead of19.99. Shopify wants a dot decimal. - Hidden spaces or text: a trailing space or a stray
USD.
How to fix it
- Format the
Variant Pricecolumn as a plain number (not currency) in your spreadsheet, then re-export as CSV. - Remove currency symbols and thousands separators; use a dot for the decimal.
- Re-import. Existing products with wrong prices can be corrected by re-importing with the fixed prices.
Catch every bad price before you import: the free
Shopify CSV Validator flags each
Variant Price Shopify would reject, with the row number — in your browser, no
upload.
Related: common Shopify CSV import errors.