Shopify product CSV guide
Shopify product CSV import preflight checklist
Use this conservative sequence before retrying a rejected import or running a large migration. A structurally valid CSV can still be unsafe for a particular store, so keep a backup and treat Shopify’s import preview as a separate review step.
Check one file without uploading it. Run the free browser-local checker for exact row and column findings.
Working across client migrations? The Agency Batch License is ZAR220 once. It covers one organization across up to 10 authorized client migration or catalog projects, with automatic delivery and no subscription.
Six checks before import
- Keep the original export untouched. Shopify warns that product CSV imports cannot be cancelled after they begin. Sorting in a spreadsheet can also separate product rows from related image or variant rows, so work from a copy and preserve the source order.
- Confirm UTF-8 and valid CSV quoting. Re-export as UTF-8 CSV when the source encoding is uncertain. Straight double quotes delimit quoted CSV fields; curly quotation marks are ordinary content and do not repair malformed CSV structure.
- Compare exact header names. Treat unknown, case-shifted, duplicated, or whitespace-padded headings as review items. Do not delete dynamic metafield, market, or documented collection columns merely because a basic template does not contain them.
- Keep variant rows grouped by product handle. Review blank handles, duplicate expressed option combinations, missing option names or values, and rows moved away from their product. Image-only continuation rows should not be mistaken for product variants.
- Validate fields without guessing store state. Price, inventory, status, and image URL syntax can be checked locally. Metafield definitions, taxonomy availability, fulfillment services, markets, reference targets, and overwrite consequences require store context.
- Run a small test before a large migration. Shopify recommends that Partners use a development store for testing. Review the import preview, confirm a representative product and its variants, and only then expand the batch.
Scope boundary: CSV SafeCheck checks a documented subset and does not guarantee Shopify import acceptance. It cannot observe the target store, cancel an import, or determine whether an update will overwrite the intended record.
Primary sources
- Shopify Help Center: Importing products with a CSV file
- Shopify Help Center: Using product CSV files
Retrieved 1 September 2026. Recheck the live Shopify guidance before a consequential import because schemas and supported workflows can change.