🔧 Quick Info: This tool scans your Shopify catalog and flags products with missing or invalid data – empty SKUs, duplicate SKUs, missing descriptions, pricing errors, missing alt text, and 8 other data quality checks. Choose which products to scan, select which checks to run, and download a report of all issues found.
What It Does
The Missing Data Finder scans your Shopify product catalog and flags products (and their variants) that are missing important information or have data that looks wrong. You choose which products to check and which kinds of problems to look for, and the tool produces a downloadable report listing every issue it found. The scan runs in the background. When it finishes, the report is ready to download, and you can have it emailed to you automatically.
What Problems Can It Find?
You can check for any combination of these 13 data quality issues:
- SKU is empty – Products/variants with no SKU
- Duplicate SKUs – The same SKU used on more than one variant
- Barcode is empty or invalid – Missing or malformed barcodes
- Images without alt tags – Images missing alt text (important for accessibility and SEO)
- Price > Compare at price – The selling price is higher than the “compare at” price, which usually signals a pricing mistake
- Products without collections – Products not assigned to any collection
- Products without description – Empty product descriptions
- Products without images – The product has no featured image
- Products without product type – The Product Type field is blank
- Products without product vendor – The Vendor field is blank
- Products without tags – No tags applied
- Products without variants – Products that have no variants
- Variants without image – Variants with no image assigned
When Should You Use This?
Use this tool whenever you need to audit your catalog for data quality issues. Common scenarios include launching a new sales channel, ad campaign, or feed (Google Shopping, marketplaces) where missing fields cause rejected products, running a periodic catalog “health check” to keep your data clean, confirming nothing was dropped after a bulk import or migration, or suspecting pricing errors, duplicate SKUs, or accessibility gaps like missing alt text.
Before You Get Started
- Make sure your Shopify store is connected.
- Decide which products you want to check – everything, or a narrower set (a collection, product type, vendor, tag, status, or stock level).
- Have an email address ready if you’d like to be notified when the report is done.
How to Use It
1 Open the Tool
Navigate to the Missing Data Finder tool in your Your Store Wizards dashboard for your Shopify store.
2 Select Products to Scan
In the Select Products step, choose which products to scan. You can either pick a collection, or use the filters to narrow things down:
- Product Handle – One handle, or a comma-separated list. Leave blank for all products
- Product Type – One type or a comma-separated list. Leave blank for all
- Product Vendor – One vendor or a comma-separated list. Leave blank for all
- Product Tags – One tag or a comma-separated list. Leave blank for all
- Product Status – Active, Archived, or Draft (defaults to all)
- Product Published Status – Published or Unpublished (defaults to all)
- Product Stock Status – Out of Stock or In Stock products (defaults to all)
Note: when you pick a collection, the other filters are hidden – the collection defines the product set.
3 Select Checks to Run
In the Select Fields step, tick the checks you want to run. You can select as many as you like, or use the toggle-all option to select them all at once. Choose from the 13 data quality checks listed above.
4 Configure Export Options
In the Export Options section:
- Filename – Defaults to
missing_data_<today's date>; change it if you like - File Format – Choose CSV or Excel (Excel/.xlsx is the default)
5 Confirm Email Address
In Email Delivery, choose whether you’d like an email when the report is ready, and confirm the email address (your account email is filled in for you).
6 Start the Scan
Start the export. The scan runs in the background – you don’t need to keep the page open.
When it’s done, download your report (and/or open the email link).
File and Field Reference
Each row in the report represents one issue found. The report is delivered as a CSV or Excel (.xlsx) file, based on your choice in Export Options.
| Column | Description |
|---|---|
| Additional info | Extra context about the issue. |
| Error | A description of what’s wrong. |
| Field | Which field or check the issue relates to. |
| Handle | The product handle. |
| SKU | The SKU of the affected product/variant. |
| Variant title | The affected variant (when the issue is variant-level). |
Troubleshooting
My report is empty
That’s good news – no problems were found for the products and checks you selected. Try widening your product filters or selecting more checks if you expected results.
I didn’t get the email
Check your spam folder, confirm the email address you entered, and make sure Email Delivery was set to “Yes.” You can still download the report from the tool once it finishes.
The export is taking a while
Large catalogs take longer. The scan runs in the background, so you can leave the page – you’ll be notified when it’s ready.
I only want to check one collection
Pick the collection in the Select Products step; the other filters are hidden because the collection defines the product set.
What’s the difference between “Products without images” and “Variants without image”?
The first flags products with no featured/main image; the second flags individual variants that have no image of their own.