Shopify CSV guides

Confirm source columns, review every simple product and omitted field, then check your draft CSV with Validator.

Check products, explicit variants and basic prices in the legacy 50-column Wix CSV.

Check a native women’s T-shirt workbook and download a complete findings report.

Find supported structural and data issues before an import. Use the Validator for CSV or XLSX.

Preview one base-price adjustment and generate a reviewed CSV copy. Beta: up to 100 products.

Compare an original and edited file under your planned overwrite choice. Up to 100 products per file is free.

Compare a target-store export with the CSV you plan to import. Both files stay in this browser tab.

Preview simple products or opt into explicitly defined variations, review omitted fields, then generate Shopify drafts.

Check products, explicit variants and basic prices in the legacy 50-column Wix CSV.

Choose a supported product type, review the fields that will be left out, and check Shopify drafts locally before a small test import.

US official workflow: category templates, SKU rows and failed-product recovery. Catalog Precheck does not check TikTok files.

Start from a fresh export of the destination store, then map your source data to those exact columns before importing.

Use these ten error groups to locate file, template, product, variant, image, category, and custom-field risks before a test import.

Keep each Variant row with its Product parent, use consistent option names, and make each option combination unique.

Keep identifiers as text and compare the original export with your intended CSV before importing.

Use a recent export, choose the output columns, preview a percentage or fixed-amount adjustment and review the CSV before a small test import.

Check that your product CSV is UTF-8, then inspect missing or stray straight quotes near the reported line. Do not import the file until its structure is valid.

Check the first CSV row for the exact product column names your import needs. A missing Title header is a common cause, but required columns depend on whether you create products, update them, or add variants.

Look for two variant rows with the same Option1–3 value combination under one product handle. Do not change every repeated handle: variants of one product normally share it.

If Shopify reports a missing price, inspect the exact product or variant row before editing. An empty Price is not always rejected: the current format guide describes a zero-price default.

Inspect the Inventory quantity cell on the reported row for text or spreadsheet errors. First confirm whether you need the product CSV or a separate inventory CSV.

Check the URL on the reported row. Shopify must retrieve the image from its own servers; a URL that opens in your logged-in browser can still fail during import.

The message “Validation failed: The variant 'Default Title' already exists” can point to default-variant or option data conflicts. Review the whole product group and existing store variants before changing options.