Fix Shopify “Price Can’t Be Blank” CSV Error

A sellable product variant needs a valid price value. The error can come from an empty price cell, a shifted row caused by broken CSV quoting, or a column mapping that placed the price somewhere else.

Quick answer

Find the affected variant row and enter a numeric monetary value in the Price or legacy Variant Price column used by your file. Use a value such as 19.99 without a dollar sign or other currency symbol. Then confirm that the row is still aligned with the correct headers.

What Shopify expects

The product or variant price should contain only the monetary value, such as 9.99. Currency symbols and explanatory text do not belong in the field.

Fix it step by step

1. Identify the affected variant row

Use the line number from Shopify when available. Remember that line numbers usually count the header row as line 1.

2. Enter a numeric value

Use a plain number such as 0.00, 19, or 19.99. Remove currency symbols, thousands separators, and words such as “USD.”

3. Check for shifted columns

If the price appears present but Shopify still calls it blank, the real problem may be an unmatched quote or comma earlier in the row. Open the CSV in a text editor or validate its structure before changing more cells.

4. Confirm the correct header

Shopify's product CSV naming has evolved. Use the current export or template as the source of truth, and avoid manually combining unrelated legacy and current headers.

5. Review compare-at price separately

Compare-at price is optional and represents the original price for a markdown. Do not move it into the main price field accidentally, and make sure any value also uses a plain numeric format.

6. Validate a copy

VariantSafe flags blank or malformed price values and can safely remove common currency formatting without guessing what an absent business price should be.

Common hidden causes

A formula returned an empty string rather than a number.
A regional spreadsheet format exported commas as decimal separators.
A currency symbol or text was included in the cell.
An illegal quote shifted the apparent price into another column.
A supplier file was mapped to the wrong Shopify header.

Check the repaired CSV before importing

VariantSafe reads the file locally in your browser and reports exact rows, columns, and safe automatic fixes.

Open the free CSV validator

How to fix “Validation failed: price can’t be blank”