The formats that become 0.00
These price cell formats are the usual culprits:
Common Scenarios:
- Currency symbols: $19.99, €12.50, £9.99 in the price column.
- Thousand separators: 1,299 instead of 1299.
- Suffixes or spaces: '19.99 USD' or '19.99 ' with a trailing space.
- Locale formatting from European exports: 1.234,56 instead of 1234.56.
Catch zero-price rows before they go live
ShopTools' validator flags price cells that contain symbols, separators or spaces, and normalizes them to plain numbers Shopify accepts.
Features:
- Price format check: Flags cells with symbols, separators or spaces
- Auto-normalize: Strips currency and converts locale formats
- Zero-price warning: Flags rows that would import as 0.00
Clean the price column
- Strip currency symbols and suffixes from every price cell.
- Remove thousand separators (commas).
- Convert European decimal commas to dots and remove the thousand dots.
- Trim trailing spaces and re-validate before importing.
Before and after
- Before: $19.99 -> imports as 0.00 After: 19.99 -> imports correctly
- Before: 1,299 -> imports as 0.00 After: 1299 -> imports correctly
- Before: 1.234,56 (European format) -> imports as 0.00 After: 1234.56 -> imports correctly
Who hits zero prices
- Stores importing supplier CSVs: Supplier files often carry currency symbols
- European merchants: Locale decimal formats break the importer
Frequently Asked Questions (FAQ)
- Why does my price import as 0.00?
- Shopify reads prices as plain numbers. Currency symbols, thousand separators or spaces in the cell make it read zero.
- Can I use $19.99 in the price column?
- No - strip the symbol. Shopify's importer expects plain numbers like 19.99.
- What about European format 1.234,56?
- Convert it to 1234.56 - dot as decimal, no thousand separator.
- How does ShopTools help?
- It flags every price cell that would import as zero and normalizes the format automatically.