"My prices are wrong or missing after import" — price formatting

What you'll see

Some products land with no price at all — Shopify shows "Validation failed: Price can't be blank" for those rows, or occasionally worse, an incorrect price that's off by orders of magnitude, like $1,999 where you meant $19.99.

Price has to be a plain number — the symbol matters

Shopify's Variant Price and Variant Compare At Price columns expect a decimal number and nothing else: 19.99, not $19.99. If a dollar sign gets typed straight into the cell — common when someone builds a price list by hand rather than exporting it — the cell holds text, not a number, and that breaks the import for that row rather than Shopify politely stripping the symbol for you.

Locale settings quietly change what a number means

The less obvious version of this problem is regional number formatting. Many locales (much of Europe, for instance) use a comma as the decimal separator and a period for thousands — so a cell showing what looks like "19,99" is actually the number nineteen-point-ninety-nine to that locale, but if your spreadsheet or CSV export doesn't consistently apply that convention when it writes the file, the value can be read on the Shopify side as nineteen thousand ninety-nine, or rejected outright if the comma collides with the CSV's own field separator.

How to check and fix it

Reformat the Price and Compare At Price columns as plain numbers with a period decimal, remove any typed currency symbols, and confirm your spreadsheet application's regional settings match the format Shopify expects before exporting. Check a handful of prices against what you intended after upload, not just that a number is present.