Shopify boolean & price cleaner
Paste a column — get Shopify-ready TRUE/FALSE values or clean numeric prices.
Converts Yes/No, 1/0, true/false → Shopify's TRUE/FALSE. Runs entirely in your browser.
Why Shopify rejects these values
Two of the most common Shopify import failures are boolean and price formatting. Shopify needs booleans as TRUE/FALSE in uppercase — not Yes/No or 1/0 — and prices as plain numbers like 19.99 with no currency symbols, no thousands separators, and a dot decimal.
Paste a single column, pick the mode, and copy the cleaned result back into your sheet. For a whole file at once, use the full fixer.
Frequently asked questions
What boolean format does Shopify require?
Shopify expects TRUE or FALSE (uppercase) for columns like Published, Variant Requires Shipping, Variant Taxable, and Gift Card. Values like Yes/No, 1/0, or lowercase true/false get rejected or treated as unpublished.
How should prices be formatted?
Variant Price must be a plain number like 19.99 — no currency symbols ($, €, £), no thousands separators, and a dot as the decimal. This tool also converts European comma decimals (15,00 → 15.00).
Does this upload my data?
No. All cleaning happens in your browser. Nothing is sent to a server or stored.
Clean the whole file at once
EcomCSVFix fixes booleans, prices, headers, handles, and encoding in a single pass.
Fix my CSV for free →