Price field cleanup
Shopify CSV Price Format Fixer
Find Shopify CSV price format issues before import, including currency symbols, comma decimals, blank variant prices, and non-numeric cells.
Local browser scanSafe fixes onlyShopify-focused checks
Browser-side scan
Drop a Shopify product CSV
No CSV selected
No CSV selectedUpload a Shopify product CSV to start the browser-side scan.
Private by default. Your catalog data stays in this browser session. The export applies only safe deterministic fixes and leaves manual-review items in the findings list.
Price cells often change when a CSV is edited in spreadsheets with different locales. This route applies only unambiguous price cleanup and keeps comma-decimal decisions visible for review.
Import blockers
Common causes this scan checks
- Prices include currency symbols such as $, EUR, USD, or shop-specific labels.
- Spreadsheet locale converted decimal dots into commas.
- Variant Price cells are blank on rows that need a purchasable variant.
- Sale prices were pasted into the wrong Shopify CSV column.
Workflow
How to use the cleaned CSV
- Scan Variant Price and Price columns for non-numeric values.
- Apply safe currency-symbol and thousands-separator cleanup when the decimal format is clear.
- Manually review comma decimals because they may represent either decimal or thousands separators.
- Validate variant rows again after price cleanup.
Auto-fix policy
What the export can safely change
- Removes currency symbols from unambiguous price cells.
- Removes thousands separators from clear decimal prices.
- Trims price cell whitespace before export.
- Flags ambiguous comma decimals instead of guessing the merchant's price.
FAQ
Shopify CSV questions
Can Shopify CSV prices include currency symbols?
Use numeric values for import. Currency symbols are safe to remove only when the remaining price is unambiguous.
Will the tool convert comma decimal prices?
It flags comma decimals for manual review because commas can mean different things in different spreadsheet locales.
Why do variant prices matter?
Blank or malformed variant price cells can prevent purchasable variants from importing as intended.