Shopify Catalogue Scraper

Guide

A 10-point checklist for auditing your Shopify catalogue

6 min read, published 16 November 2026

Shopify’s admin is good at editing one product at a time and poor at showing problems across a whole catalogue. Exporting your storefront as shoppers see it, one row per variant, makes those problems easy to find. This checklist covers the issues that most often cost sales or confuse customers, with a spreadsheet method for each.

Start by running your own store through the scraper and opening the CSV in Google Sheets or Excel. The export guide explains how to keep SKUs and IDs intact.

1. Variants with no SKU

Filter the sku column to blanks. Every row that appears is a variant your warehouse, ERP or marketplace feed cannot match. Fix these first if you sync stock with any other system.

2. Duplicate SKUs

Add a helper column with =COUNTIF(sku_column, sku_cell) and filter for values greater than 1. Duplicates usually come from copying a product and forgetting to change the codes, and they cause stock to be deducted from the wrong item.

3. Zero or suspicious prices

Sort by price ascending. Anything at 0.00 can be ordered for free. Then look at the top of the list sorted descending: an extra zero typed by mistake stands out immediately.

4. Broken “was” prices

Rows where compare_at_price is filled but discount_pct is empty have a compare-at price equal to or lower than the selling price. Depending on your theme, shoppers may see a sale badge with no saving, or a strike-through price that is cheaper than the real one. Clear the compare-at price on these after a sale ends.

5. Discounts nobody intended

Sort by discount_pct descending. Very deep discounts on new-season products, or on a single size of a product, are often leftovers from an old promotion or a bulk edit that went wrong.

6. Products without images

Filter image_count to 0. Listings without photos convert badly and can be rejected by Google Shopping and other marketplaces.

7. Long-term sold-out lines

Filter available to FALSE and switch the table to Grouped by product, or pivot by product_id, to find products where every variant is unavailable. Sort those by updated_at: products that have been sold out for months clutter collection pages and search results. Restock, hide or archive them.

8. Missing size or colour combinations

Pivot one product type by the size option. Products with far fewer variants than their siblings may have sizes that were never created, rather than ones that sold out.

9. Inconsistent types, vendors and tags

Use the vendor and product type filters in the tool, or a pivot on those columns, to list every distinct value. Near-duplicates such as “T-Shirt”, “T-shirts” and “Tee” split your automated collections and filters. Choose one spelling and update the rest.

10. Missing weights

Filter grams to 0 where requires_shipping is TRUE. If you use weight-based shipping rates, these items may ship for free or at the wrong rate.

Make it a habit

Run the audit monthly, or after any large import or bulk edit. Keeping the previous export lets you compare: matching rows on variant_id shows exactly what changed. The column reference covers every field used above.