File-in / file-out repair tool
Free Shopify CSV Import Checklist
Use this checklist before uploading a Shopify product CSV to Shopify admin, Matrixify, or another bulk import tool. It is a practical preflight list, not a full repair export.
Fast path: run these manual checks, then use the CommerceFix free scan to preview counts, categories, and the first five affected rows. Paid repair generation stays locked until checkout.
Before-upload checklist
| Check | Why it matters | CommerceFix output if repairable |
|---|---|---|
Handle is present | Missing or duplicate handles can merge products, split variants, or create import confusion. | fixed_import_safe.csv + error_report.xlsx |
Title is not blank | Blank titles make product rows hard to review and can break clean product creation. | fixed_import_safe.csv |
Option1 Name and Option1 Value match | Incomplete option pairs create variant risk, especially when rows use Default Title. | fixed_import_safe.csv + before_after_preview.html |
Image Src is a valid URL | Blank, duplicate, or non-http image URLs are common reasons images do not import. | fixed_import_safe.csv + error_report.xlsx |
Image Alt Text is filled where useful | Blank alt text is a CSV-level SEO gap that can be patched without changing product rows. | seo_patch_only.csv |
Metafield: title_tag [string] exists | Missing SEO titles make bulk product imports lose metadata work. | seo_patch_only.csv |
Metafield: description_tag [string] exists | Missing or duplicate descriptions create cleanup work after import. | seo_patch_only.csv |
| Quotes, commas, and newlines are escaped | Bad quoting can shift columns and make the row look different to Shopify than it looked in a spreadsheet. | error_report.xlsx + safe-row repair where possible |
Broken CSV sample
Handle,Title,Option1 Name,Option1 Value,Image Src,Image Alt Text,Metafield: title_tag [string],Metafield: description_tag [string]
,Ceramic Mug,Size,,cdn.example.com/mug.jpg,,,
linen-shirt,Linen Shirt,Size,M,https://cdn.example.com/linen.jpg,,Linen Shirt,Linen ShirtWhat the free scan gives you
- Issue counts and categories.
- The first five example rows with row number, field, severity, and suggested repair.
- A before/after preview for safe sample rows only.
What stays paid
fixed_import_safe.csv: import-safe repaired Shopify product CSV.seo_patch_only.csv: SEO title, meta description, and image alt text patch file.error_report.xlsx: row-level QA report.before_after_preview.html: reviewable change preview before upload.
Use this for directory and community posts
If someone asks why a Shopify CSV import failed, send this checklist first. It gives them a manual preflight path and a free scanner without asking for Shopify login or API access.