How to Compare Shopify Product CSVs After a Migration
A practical way for agencies and freelancers to compare before-and-after Shopify product exports, catch missing variants, price changes, image URL mismatches, and redirect mapping errors, and sign off with evidence. No Shopify admin login required.
11/20/20263 min read
A catalog can look “moved” and still be wrong. A missing variant, a quiet price change, a new image URL, or a redirect that points to the wrong product will not always show up in a quick click-through of the new store.
If you run Shopify migrations for clients, or you are signing off a move for your own store, a before-and-after comparison of the product exports is one of the most reliable checks you can do. It does not require a Shopify admin login, and it does not change the live store.
This is a practical method you can use on any migration: a platform change, a store-to-store move, a supplier import after the move, or a rebuilt product file.
Decide what this review will cover
Write down the scope before you export anything. For most catalog sign-offs, the useful scope is:
Products and variants (identity, prices, options, status, image references)
Redirect maps, if old URLs are supposed to land on new product pages
A catalog comparison will not prove that checkout works, that the theme is correct, or that apps still fire. Keep those on a separate list with a named owner.
Export two comparable files
Export a complete product catalog from the source (or the pre-migration store) and a complete product catalog from the destination Shopify store, both as UTF-8 CSV, including headers.
Use Shopify-format headings where you can: Handle, Title, Variant SKU, Variant Price, Status, option fields, and image fields, or the current equivalents. If the source is not Shopify, adapt those columns before you compare. A partial export only proves differences inside that slice, so use complete, comparable files where possible.
If redirects are in scope, also keep two maps: the expected list (old URL → intended new URL) and the configured list from the destination store. The usual columns are Redirect from and Redirect to.
Record the export date, time, timezone, and who pulled each file. Keep customer, order, payment, and credential data out of these files.
Match rows with care
Match variants by exact unique SKU first. When SKUs are missing or duplicated, match by handle plus option values only when that pair is unique. Hold duplicates for manual review. Do not force a match.
Then look for:
SKUs or handle/option pairs in the source file that did not arrive
Extra rows that appear only in the destination file
Changed prices, barcodes, options, titles, or status
Changed or missing image URLs
Expected redirects that are missing, and configured redirects that point somewhere else, plus duplicate sources, chains, and loops in the map
A changed image URL is a reference change, not proof that the picture failed to load. Open a sample of important URLs on the live store. A redirect map review is also not a live HTTP crawl. After the map looks right, spot-check important old URLs in a browser.
Write down accepted differences
Some differences are intentional: a planned price update, a CDN rewrite, a title cleanup. Document those with a short reason and an owner. What you want at sign-off is not a file with zero differences at any cost. You want no unexplained differences.
Know what a clean comparison does not mean
A clean comparison means the supplied checks found no differences, not that the live store is safe to launch. You still need your usual review of the storefront, collections, checkout, apps, and anything legal or contractual.
A free checklist, and a $49 evidence report
We published a free printable Shopify Migration QA Checklist you can use on client projects. It follows the same steps as this article and includes a short sign-off record.
If you want a printable evidence report with exact source-row numbers, Shopify Migration Proof compares before-and-after Shopify-format product CSVs and optional redirect maps. It does not log into Shopify and does not change a store.
The fictional sample plants five differences so you can see the report format. The report event is not charged for the sample. Check the Pricing tab for any separate platform compute.
A completed comparison report is $49, plus any separate Apify compute. You set a run charge limit before you start.
Shopify Migration Proof is an independent product of J T Hunt Enterprises LLC. It is not affiliated with or endorsed by Shopify. It is a reconciliation aid, not validation of an entire migration.
