Import guide

Shopify Product CSV Pre-Import Checklist

A checklist for validating Shopify product CSV files before import.

Recommended first tool

Start with Shopify CSV Validator

Check Shopify product CSV files for required fields, duplicate handles, prices and image URLs.

Open Shopify CSV Validator

What this guide covers

Check product identity first
Validate URLs and prices
Run a generic CSV check too
Keep sample and rollback files

Check product identity first

Product imports are safest when every product has a stable handle and every variant has a clear SKU. Duplicate handles may be intentional when rows represent variants of the same product, but accidental duplicate handles can update or merge products in ways you did not expect.

Start by checking required product columns, handles, titles, vendors, option names, option values, variant SKUs and variant prices. Fix identity issues before editing descriptions or marketing fields.

Validate URLs and prices

Bad image URLs and non-numeric price values are common import problems. Variant Price should be a plain number, not a currency-formatted string. Image URLs should be reachable and should not contain copied placeholder text.

If a product has variants, confirm Option1 Name and Option1 Value are present where needed. Missing option values can create confusing product variants or rejected rows.

Run a generic CSV check too

A Shopify-specific checker catches platform rules, but generic CSV quality still matters. Missing values, mixed types, empty columns, duplicate rows and bad dates can create problems in metafields, inventory files or product updates.

Run CSV Data Quality Checker before the final upload. It gives a broad report that helps catch unexpected spreadsheet issues outside the core Shopify columns.

Keep sample and rollback files

Before uploading a corrected product CSV, keep the original export, a reviewed issue report and the final fixed file. If the import updates products unexpectedly, those files help identify which rows changed.

For large catalogs, test a small subset first. Local preflight catches obvious problems, but Shopify store settings, apps, and custom fields can still affect final import behavior.

Example Shopify preflight

Load the Shopify sample in Shopify CSV Validator. Review missing required values, duplicate handles and invalid price rows. Then run CSV Data Quality Checker on the same file before preparing the final upload.

FAQ

Are duplicate Shopify handles always wrong?

No. Variants can share a product handle. The key is to confirm duplicates are intentional variant rows rather than accidental product collisions.

Should blank Variant SKU values block import?

They may not always block import, but they make inventory and update workflows harder to reconcile. Treat blank SKUs as a warning to review.

Related guides

Next workflow