As an e-commerce catalog expands to hundreds or thousands of products, silent data errors inevitably slip through.
A variant created without an SKU breaks warehouse fulfillment. A product listed without weight prevents carrier shipping calculators from quoting correct rates. Missing images damage customer conversion rates, while empty product descriptions hurt search engine indexing. Checking each product manually inside the Shopify admin panel is exhausting and almost impossible at scale.
With Shop Engine, you can run a complete, automated catalog health audit directly from your Windows desktop for free. In less than a minute, it scans your entire catalog and generates a multi-tab Excel report highlighting every single missing attribute.
Here is how to audit your Shopify catalog and review your store health score.
Step 1: Open Shop Engine and Link Your Store
- Launch Shop Engine on your Windows PC.
- Make sure your store session is active at the top under ACTIVE SHOPIFY STORE.
- If you are opening the app for the first time, provide your store domain (e.g.,
your-store.myshopify.com) and your Admin API token (shpat_...), then click Connect Store.
Step 2: Select the Catalog Audit Module
In the SELECT REPORT section:
- Click on the Report type to export dropdown menu.
- Choose Catalog Audit (or Auditoría de Catálogo if your interface is set to Spanish).
- The date period selector will hide automatically, as the audit scans your entire live catalog in real time.
Step 3: Run the Audit Engine
Click the green Generate Report button.
Shop Engine will query the Shopify Admin API in the background, paginating through every active and draft product and evaluating 9 distinct data integrity criteria across every variant:
- Critical operational fields: Missing SKU, Missing Barcode, and Missing or $0.00 Price.
- Logistics fields: Missing Weight (vital for real-time shipping rate calculations).
- SEO & Marketing fields: Missing Description, Missing Images, Missing Product Type, Missing Vendor, and Missing Tags.
Step 4: Review Your 3-Sheet Excel Audit Workbook
When the audit completes, click Open Folder on the confirmation popup. Open the newly generated workbook (e.g., Audit_Nov_2026.xlsx) to review your findings across three clean sheets:
1. Audit Overview
Provides high-level management metrics, including:
- Catalog Health Score: An overall percentage (0–100%) reflecting the completeness of your catalog data.
- Scanned Products & Variants: Total items inspected.
- Variants with Issues: Number of specific options requiring immediate attention.
2. Issue Breakdown
Categorizes every discovered error by frequency and severity:
- Shows the exact count and percentage for each error type.
- Labels items as Critical (missing SKUs, missing prices, missing barcodes) or Improve (missing tags, vendors, or descriptions) so you know what to prioritize.
3. Detailed Issues
The operational checklist for your team or catalog manager:
- Lists each affected item with its exact Product ID, Product Title, Variant Title, and SKU.
- Columns clearly display a Yes or No for every error flag, making it effortless to filter by specific issues in Excel and fix them directly in Shopify.
Running this audit once a month keeps your store data clean, prevents costly fulfillment delays, and ensures your products remain optimized for both search engines and shoppers.