Check your Shopify product CSV before importing it
A product CSV can be valid enough to upload yet still change the wrong product details. Before you import, compare the edited file with an untouched export and review the rows most likely to affect variants, images, prices, and visibility.
Review your product CSV with Catalog Guard โ
1. Keep the original export
Export your current products from Shopify before editing them. Keep that file untouched. It gives you a reference for deciding whether a change in the import file is intentional. Catalog Guard can compare matching products in the two files; without the original export, it can still inspect the new file's structure but cannot know what existing values changed.
2. Check variant option names and values
Review Option1 Name and Option1 Value, plus the second and third option pairs when your products use them. For an update, changing an option value can represent a different variant identity rather than a harmless spelling edit. Check for missing option columns, duplicate option combinations, and changes in capitalization or trailing spaces. Confirm each flagged change against the original export.
3. Keep every product's rows together
A single product can occupy multiple CSV rows for variants and images. All rows with the same handle should remain together. Sorting the whole spreadsheet by price, SKU, or another column can separate those rows. If a handle reappears after another product, restore that product's contiguous block from a fresh export and reapply only the intended edits. Shopify also warns about sorting product CSV files because it can detach image links.
4. Review blank fields and image URLs
An included column with a blank value can be an intentional clear or an accidental omission. Pay particular attention to product descriptions, vendor, tags, SEO fields, and image columns. If the original export has image URLs and the edited file has none for a product, investigate before importing. A blank image cell on a continuation row is common, so examine the product's full group and the original file rather than treating every blank image cell as an error.
5. Compare prices and product visibility
When the original export is available, look for a paid variant becoming 0 and an active product becoming draft, archived, or unpublished. Those changes may be deliberate. Confirm them product by product, especially after bulk spreadsheet edits.
6. Review the report, then Shopify's preview
Catalog Guard points to affected products, rows, and columns and provides a downloadable findings report. It checks selected patterns in Shopify's native product CSV format; it does not inspect your live store or predict every result of Shopify's import. Review the final CSV and Shopify's own import preview before confirming. For the format and current import behavior, use Shopify's product CSV guidance as the primary reference.
Common questions
Can I check a Shopify CSV without an original export?
Yes. The checker can flag structural and row-level patterns in the file you plan to import. Add an original export to compare changes to matching existing products, including option combinations, image URLs, zero prices, and product visibility.
Does a clean report guarantee a safe import?
No. A clean result means no checked pattern was found. It does not verify your live catalog, app settings, remote images, or Shopify's final processing.
Which CSV format is supported?
Catalog Guard is built for Shopify's native product CSV. Inventory CSVs and third-party formats such as Matrixify are outside this version's scope.