01
Export a fresh baseline and keep it unchanged
Start from a current Shopify product export and preserve an untouched copy as your rollback reference. Shopify explicitly recommends backing up product data before a CSV import.
Shopify CSV audit guide
Audit a Shopify product CSV before you re-import it.
Bulk edits are useful because one file can change a lot of catalog data at once. That is also why the safest workflow is export, audit, review, import, and verify — with an unchanged baseline kept outside the working copy.
StoreCheck audits supported product catalog fields. It does not replace Shopify's import validation or decide merchant-specific pricing, inventory, taxonomy, or content intent for you.
Before you edit
Three Shopify CSV behaviors worth treating as high-risk.
These are import behaviors documented by Shopify, not StoreCheck assumptions. Read the current Shopify documentation again before a large production import because CSV behavior can change over time.
Imports are consequential
Shopify says a product CSV import can't be cancelled after it begins and recommends a backup before you start.
Variant option edits can change IDs
Shopify warns that changing Option1, Option2, or Option3 values can delete existing variant IDs and create new ones, which can affect dependencies that use those IDs.
Matching-handle overwrite is broad
When you choose to overwrite products with matching handles, Shopify can replace existing values for columns included in the import file. Review the import preview and file scope carefully.
Review-first workflow
Five steps from export to verified import.
02
Preserve Shopify's CSV structure
Keep the expected headers and product/variant row relationships intact. Avoid casually sorting or reshaping a product export: Shopify warns that spreadsheet sorting can separate products from image rows.
03
Audit the file before changing products
Upload the CSV to StoreCheck to turn supported catalog fields into a prioritized issue list across structure, content, images, pricing, inventory, SEO metadata, and organization.
04
Separate deterministic cleanup from merchant decisions
Treat obvious data defects differently from business choices. Pricing, inventory, taxonomy, content, handles, and variant options can carry merchant intent or downstream dependencies and should be reviewed deliberately.
05
Import deliberately, then verify with another scan
Review Shopify's import preview and overwrite choices before starting. After the import, export or scan the resulting catalog again and compare findings instead of assuming a bulk update behaved as intended.
What the CSV scan covers
Check the catalog fields that are easy to miss in a spreadsheet.
StoreCheck normalizes supported Shopify product-export headers and groups explainable findings across seven catalog areas.
Product structure
Missing or duplicate handles, malformed variant structure, duplicate option combinations, and identifier issues.
SKUs and variants
Missing or duplicate SKUs and variant-level structure that can affect operational workflows.
Images
Missing images, invalid image URLs, missing alt text, and suspicious image reuse.
Content
Missing, thin, duplicate, or highly similar product titles and descriptions.
Pricing and inventory
Clearly invalid or suspicious values and inconsistent sibling-variant configuration that deserve review.
Product SEO
Missing, duplicated, unusually short, or unusually long SEO titles and meta descriptions.
Catalog organization
Vendor, product-type, and tag gaps or inconsistencies, including duplicate and malformed tags.
Safe CSV cleanup is intentionally narrow.
StoreCheck does not treat every finding as permission to mutate a CSV. Its guarded deterministic safe-export path is limited to proven duplicate and empty tag hygiene cases, verifies the exact source file, preserves product boundaries, and reparses/rescans the candidate output before download. Pricing, inventory, handles, variant options, taxonomy, and content choices remain review-first.
See the catalog cleanup workflowCommon CSV audit questions
Know what the audit can — and cannot — guarantee.
Can StoreCheck guarantee that a Shopify CSV import will succeed?
No. StoreCheck audits supported product catalog fields and catches quality issues before you import, but Shopify remains responsible for validating and executing the import. Keep the file in Shopify's current product CSV format and review Shopify's import preview before proceeding.
Does StoreCheck automatically rewrite my Shopify CSV?
The audit itself does not rewrite the uploaded CSV. StoreCheck's guarded safe-CSV cleanup is deliberately narrow and only handles proven duplicate or empty tag hygiene cases when the source file and post-export validation checks pass. Other findings remain review decisions.
Should I sort a Shopify product CSV in Excel or Numbers?
Be careful. Shopify warns that sorting a product CSV in spreadsheet software can separate products from related image rows and cause image loss on import. Preserve product-row relationships unless you fully understand the file structure.
What should I do after a CSV cleanup import?
Verify the result. Export or scan the resulting catalog again, compare it with your baseline, and check that the intended findings disappeared without introducing new catalog problems.
Audit before import