The Friction of Out-of-Range Values and Invalid Data Types in Catalog Feeds
E-commerce spreadsheets are prone to formatting errors, such as prices written as '$19.99' instead of '19.99', inventory marked as 'out' instead of a numeric value, or status fields written as 'yes' instead of 'true'. Shopify's database will reject these incompatible values, stopping your store updates.
Common Scenarios:
- Prices containing currency symbols ($, €, ¥) causing Shopify to fail during inventory updates.
- Incorrect boolean strings like 'yes/no' instead of the required 'true/false' for tax and shipping flags.
- Variant weights written as text strings with units (e.g., '500g') instead of clean numbers (e.g., '0.5').
High-Speed Value Normalization & Multi-Type Data Sanitization
Our tool runs a high-speed data sanitization pass on your CSV. It automatically strips currency symbols, normalizes boolean values to lowercase, and converts textual weights into compliant decimals, generating a perfect import file.
Features:
- Smart Numeric Sanitizer: Extracts raw numbers from price and weight columns, removing currency symbols and text units automatically.
- Strict Boolean Conversion: Converts 'yes', 'no', 'Y', or 'N' inputs into compliant 'true' or 'false' values instantly.
- Browser-Level Data Protection: Operates 100% locally in your browser memory to keep your business data private and secure.