Home › Errors

Invalid price value

Fix PRICE_INVALID / PRICE_MISSING errors caused by currency symbols, thousands separators or the wrong decimal separator.

Symptom

Validation reports that a price “contains a currency symbol”, “contains ',' but the decimal separator is set to '.'” or “has more than 2 decimal places”.

Example that fails

parent_id,title,sku,size,price
D1,Ambiguous Price,D1-S,S,"1,234.00"

Fixed example

parent_id,title,sku,size,price
D1,Clear Price,D1-S,S,1234.00

Explanation

Every variant row needs a price that is a plain number ≥ 0 with at most two decimals. You choose the decimal separator (point or comma) in the mapping step; a value that contains the other separator is reported instead of guessed, because “1,234” could be one-thousand-two-hundred-thirty-four or one-point-two-three-four. Currency symbols, spaces and thousands separators are never stripped automatically. A zero price is allowed only after you confirm it, and a compare-at price must be greater than the price.

Working fixture: fixture-d-blocking.csv

parent_id,title,sku,size,price,vendor
D1,Ambiguous Price,D1-S,S,"1,234.00",Acme
D2,Dup Combo,D2-S,S,10.00,Acme
D2,,D2-S2,S,10.00,Acme
D3,Formula,=SUM(A1),M,5.00,Acme
,No Parent,D4-S,S,5.00,Acme
D5,Conflict Title,D5-S,S,5.00,Acme
D5,Conflict Title Other,D5-M,M,5.00,Acme
D6,Vendor Conflict,D6-S,S,5.00,Acme
D6,Vendor Conflict,D6-M,M,5.00,Other Vendor
D7,Too Many Variants,D7-0,0,1.00,Acme
D7,Too Many Variants,D7-1,1,1.00,Acme
D7,Too Many Variants,D7-2,2,1.00,Acme
D7,Too Many Variants,D7-3,3,1.00,Acme
D7,Too Many Variants,D7-4,4,1.00,Acme
D7,Too Many Variants,D7-5,5,1.00,Acme
D7,Too Many Variants,D7-6,6,1.00,Acme
D7,Too Many Variants,D7-7,7,1.00,Acme
D7,Too Many Variants,D7-8,8,1.00,Acme
D7,Too Many Variants,D7-9,9,1.00,Acme
D7,Too Many Variants,D7-10,10,1.00,Acme
D7,Too Many Variants,D7-11,11,1.00,Acme
D7,Too Many Variants,D7-12,12,1.00,Acme
D7,Too Many Variants,D7-13,13,1.00,Acme
D7,Too Many Variants,D7-14,14,1.00,Acme
D7,Too Many Variants,D7-15,15,1.00,Acme
D7,Too Many Variants,D7-16,16,1.00,Acme
D7,Too Many Variants,D7-17,17,1.00,Acme
D7,Too Many Variants,D7-18,18,1.00,Acme
D7,Too Many Variants,D7-19,19,1.00,Acme
D7,Too Many Variants,D7-20,20,1.00,Acme
D7,Too Many Variants,D7-21,21,1.00,Acme
D7,Too Many Variants,D7-22,22,1.00,Acme
D7,Too Many Variants,D7-23,23,1.00,Acme
D7,Too Many Variants,D7-24,24,1.00,Acme
D7,Too Many Variants,D7-25,25,1.00,Acme
D7,Too Many Variants,D7-26,26,1.00,Acme
D7,Too Many Variants,D7-27,27,1.00,Acme
D7,Too Many Variants,D7-28,28,1.00,Acme
D7,Too Many Variants,D7-29,29,1.00,Acme
D7,Too Many Variants,D7-30,30,1.00,Acme
D7,Too Many Variants,D7-31,31,1.00,Acme
D7,Too Many Variants,D7-32,32,1.00,Acme
D7,Too Many Variants,D7-33,33,1.00,Acme
D7,Too Many Variants,D7-34,34,1.00,Acme
D7,Too Many Variants,D7-35,35,1.00,Acme
D7,Too Many Variants,D7-36,36,1.00,Acme
D7,Too Many Variants,D7-37,37,1.00,Acme
D7,Too Many Variants,D7-38,38,1.00,Acme
D7,Too Many Variants,D7-39,39,1.00,Acme
D7,Too Many Variants,D7-40,40,1.00,Acme
D7,Too Many Variants,D7-41,41,1.00,Acme
D7,Too Many Variants,D7-42,42,1.00,Acme
D7,Too Many Variants,D7-43,43,1.00,Acme
D7,Too Many Variants,D7-44,44,1.00,Acme
D7,Too Many Variants,D7-45,45,1.00,Acme
D7,Too Many Variants,D7-46,46,1.00,Acme
D7,Too Many Variants,D7-47,47,1.00,Acme
D7,Too Many Variants,D7-48,48,1.00,Acme
D7,Too Many Variants,D7-49,49,1.00,Acme
D7,Too Many Variants,D7-50,50,1.00,Acme
D7,Too Many Variants,D7-51,51,1.00,Acme
D7,Too Many Variants,D7-52,52,1.00,Acme
D7,Too Many Variants,D7-53,53,1.00,Acme
D7,Too Many Variants,D7-54,54,1.00,Acme
D7,Too Many Variants,D7-55,55,1.00,Acme
D7,Too Many Variants,D7-56,56,1.00,Acme
D7,Too Many Variants,D7-57,57,1.00,Acme
D7,Too Many Variants,D7-58,58,1.00,Acme
D7,Too Many Variants,D7-59,59,1.00,Acme
D7,Too Many Variants,D7-60,60,1.00,Acme
D7,Too Many Variants,D7-61,61,1.00,Acme
D7,Too Many Variants,D7-62,62,1.00,Acme
D7,Too Many Variants,D7-63,63,1.00,Acme
D7,Too Many Variants,D7-64,64,1.00,Acme
D7,Too Many Variants,D7-65,65,1.00,Acme
D7,Too Many Variants,D7-66,66,1.00,Acme
D7,Too Many Variants,D7-67,67,1.00,Acme
D7,Too Many Variants,D7-68,68,1.00,Acme
D7,Too Many Variants,D7-69,69,1.00,Acme
D7,Too Many Variants,D7-70,70,1.00,Acme
D7,Too Many Variants,D7-71,71,1.00,Acme
D7,Too Many Variants,D7-72,72,1.00,Acme
D7,Too Many Variants,D7-73,73,1.00,Acme
D7,Too Many Variants,D7-74,74,1.00,Acme
D7,Too Many Variants,D7-75,75,1.00,Acme
D7,Too Many Variants,D7-76,76,1.00,Acme
D7,Too Many Variants,D7-77,77,1.00,Acme
D7,Too Many Variants,D7-78,78,1.00,Acme
D7,Too Many Variants,D7-79,79,1.00,Acme
D7,Too Many Variants,D7-80,80,1.00,Acme
D7,Too Many Variants,D7-81,81,1.00,Acme
D7,Too Many Variants,D7-82,82,1.00,Acme
D7,Too Many Variants,D7-83,83,1.00,Acme
D7,Too Many Variants,D7-84,84,1.00,Acme
D7,Too Many Variants,D7-85,85,1.00,Acme
D7,Too Many Variants,D7-86,86,1.00,Acme
D7,Too Many Variants,D7-87,87,1.00,Acme
D7,Too Many Variants,D7-88,88,1.00,Acme
D7,Too Many Variants,D7-89,89,1.00,Acme
D7,Too Many Variants,D7-90,90,1.00,Acme
D7,Too Many Variants,D7-91,91,
…

Limitations

Prices are not converted between currencies. Negative prices are rejected.

Rule: PRICE_INVALID / PRICE_MISSING / ZERO_PRICE / COMPARE_AT_NOT_GREATER · Shopify reference: https://help.shopify.com/en/manual/products/import-export/using-csv · checked 2026-09-08.

Check my CSV free