Why Shopify Product CSV Imports Fail
Shopify's bulk import is strict and the error messages are vague. "1 product failed to import" — but which one, and why? The most common causes are: handle formatting (must be lowercase, hyphens only), price fields containing currency symbols ($29.99 instead of 29.99), HTML in Body field containing script tags, and image URLs that don't start with https://.
What This Tool Fixes Automatically
Handle: Converts "My Cool Product" to "my-cool-product". Removes special characters. Strips leading/trailing hyphens.
Prices: Strips $, £, €, ¥, commas. Converts "$1,299.99" to "1299.99". Flags non-numeric price values.
Body HTML: Removes <script> tags, <iframe> embeds, and inline onclick handlers that Shopify rejects for security reasons.
Published field: Normalizes "TRUE", "yes", "1", "active" to Shopify's expected "true" or "false".
Image Src: Validates that image URLs start with http:// or https://. Flags relative paths that Shopify cannot access.
Tags: Trims leading/trailing spaces, removes duplicate entries.
Why Not Use the Shopify App Store?
Most CSV validation apps in the Shopify App Store require you to connect your store (giving them API access) and often charge a monthly fee. This tool requires no Shopify connection, no login, and processes your file entirely in your browser — your product data never leaves your machine.
Frequently Asked Questions
What does "handle is invalid" mean in Shopify?
Shopify handles must be lowercase, contain only letters, numbers, and hyphens, and must be unique. Common causes: uppercase letters, spaces, special characters like apostrophes or underscores. Example: "Men's Shoes" must become "mens-shoes".
Why is my price column failing Shopify import?
Shopify expects the Variant Price column to contain a plain decimal number with no currency symbol, comma, or space. "$29.99" fails — "29.99" works. This tool strips currency symbols automatically.
Can I use this without connecting my Shopify store?
Yes. This is a standalone browser tool. You download your CSV from Shopify Admin (Products → Export), fix it here, then re-import it. No store connection or API access needed.
Does it handle multi-variant products?
Yes. Shopify uses multiple CSV rows per product for variants. The tool processes each row independently, so handle normalization and price cleaning apply to all variant rows.