Before you import a product CSV: seven checks that matter.
Updating hundreds of products with a spreadsheet can save time, but an import can also overwrite product data and change variant identities. Use this checklist before importing new products or selecting Overwrite products with matching handles. Updated October 14, 2026.
Start with a local preflight. Our free tool scans your CSV in your browser for selected structural, field and variant issues. No store connection or file upload required.
Open the free Shopify CSV checker →1. Export a backup you can restore from
In Shopify Admin, open Products and export the relevant products. Save the original CSV separately before editing. Shopify cautions that CSV imports cannot be canceled once started and that there is no CSV import history you can roll back through.
2. Confirm whether this is a new-product import or an update
For new product imports, Title is the baseline required field; when adding variants, URL handle is also required. For updates, Shopify requires URL handle and Title. Older exports can use legacy header names, so check the current field reference before renaming columns.
3. Protect variant option columns
When updating variant-related data such as SKU or weight, preserve matching option fields, including Option1 name and Option1 value. Omitting dependent option fields can remove variant structure. Changing option values can generate new variant IDs and break integrations that reference the old IDs.
4. Treat blank columns differently from missing columns
With overwrite enabled, a blank cell in an included non-required column can clear an existing value. Omitting that non-required column usually leaves the existing value unchanged. Compare your update file with the original export before importing.
5. Keep product rows, variants and image links together
Don't independently sort image rows or variant rows away from their product handles. Shopify warns that sorting exports in spreadsheet software can disconnect images from products. Check image URLs and product handles together; a CSV syntax check cannot confirm that external image URLs actually work.
6. Use UTF-8 and the right CSV type
Shopify product CSV and inventory CSV are separate formats. Save as UTF-8 with comma-separated fields. If you manage quantities by location, use the inventory workflow instead of assuming product CSV updates handle every inventory case.
7. Test one product, then compare the results
Run a local preflight, import a small subset or a single product first, and verify title, options, SKU, variant count, images and inventory. For a larger migration, test in a development store where practical before changing live products.
Common questions
Does the free checker guarantee Shopify will accept my CSV?
No. It performs selected local checks, not a complete Shopify import simulation. It cannot compare against your live store, confirm remote images, or guarantee the outcome of an overwrite.
Can I update SKU without option columns?
That can be unsafe for products with variants. Shopify documents dependencies between variant fields and option fields; keep the relevant option columns intact.
Should I remove blank columns?
First distinguish blank cells from intentionally omitted columns and consult Shopify's overwrite rules. Removing dependent fields can also be unsafe.
Ready to check your file? Start with a copy of your export, run the preflight, review the report, and test a small import before any bulk overwrite.
Check my CSV locally →Official sources and next steps
Reference: Shopify's import and overwrite guidance, product CSV fields, and product export and backup steps. This independent guide is not affiliated with Shopify.