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