Privacy Policy
Read the privacy policy of ShopTools. Learn how we ensure 100% data security by processing all Shopify CSV validation and editing locally in your browser.
Home Tools Guide About Us Privacy Catch Shopify CSV errors before Shopify does One rule for every Shopify variant price, no spreadsheet formulas A Shopify SKU should read like BRD-WOOLCOAT-BLK-M, not 101203 Amazon exports use ASINs; Shopify imports use handles. Mapping one to the other. A broken Shopify product image quietly drops out of Google Images Shopify said no. Here's the exact reason, and the fix. 19.99 and 20.00 are one cent apart - Shopify shoppers read them very differently A good Shopify SKU names brand, product and variant at a glance The flat file structure that fails most Amazon-to-Shopify migrations Four Shopify CSV fields decide whether your product photos reach Google Images Etsy listings export cleanly. Shopify wants them in a different shape. WooCommerce splits products and variations. Shopify expects them on one row. BigCommerce exports variants already. You only need to rename columns. Magento exports lowercase headers. Shopify wants Title case. AliExpress data works for listing. It does not work for Shopify out of the box. Shopify blocks duplicate SKUs. Here is why that protects your store. Your CSV is probably fine. Your encoding is the problem. Shopify says a variant option is missing. It is usually one empty cell. Products imported, images blank - that is almost always a URL problem. Variant rows are just product rows that repeat the same Handle. Shopify rejected the file without telling you why. Here is how to find out. Updating 500 prices one by one is the slow way. The CSV way takes minutes. Adding 40 size variants by hand takes an hour. A CSV does it in one import. A SKU like BRD-WOOLCOAT-BLK-M is readable. A SKU like 101203 is a mystery. Google Shopping did not reject your product. It rejected your image. A clearance sale is a pricing problem you solve once, then apply to every row. Excel is the fastest way to break a Shopify CSV - unless you follow three rules. One stray comma moves every price and SKU one column to the right. Your image imported - or so you thought. Shopify silently skipped it. The inventory column in your product CSV is ignored by multi-location stores. A perfectly valid-looking CSV can delete every variant on a product. Your price column looks fine in Excel. Shopify reads it as 0.00. Do you need Matrixify, or will a clean Shopify CSV do the same job? A spreadsheet formula typo can reprice your whole catalog. There is a safer way. Upload, fail, fix, repeat. That is the native Shopify CSV workflow. Start every Shopify import with the right header row. See exactly how Shopify variant rows should look before you build your own file. Add size or color variants to existing Shopify products in one CSV import. Update hundreds of Shopify prices in minutes with a CSV bulk edit. Import products to Shopify with a CSV file - no app, no subscription. Validator Price Editor SKU Generator Format Converter Image Auditor