Shopify Catalog Audit: How to Find and Fix Product Data Issues

Most Shopify stores don't have a product problem. They have a product data problem.

A store selling 400 SKUs of outdoor gear might have 30 products with no cost recorded, 22 with no description, 14 missing images, and a tag system where "water-bottle," "Water Bottle," and "waterbottles" all coexist. None of those issues show up on the homepage. All of them quietly cost money: disapproved Google Shopping listings, fulfillment mispicks, margin reports you can't trust, and collections that miss half their products.

A catalog audit finds these issues systematically — and if you do it right, the whole thing takes under an hour, not a week.

What a Shopify Catalog Audit Actually Checks

A useful audit covers seven things, in rough order of business impact:

1. Missing cost per item — without COGS, every margin number in your reports is fiction
2. Missing SKUs — breaks fulfillment, 3PL syncs, and inventory reconciliation
3. Missing images — kills conversion and gets products disapproved from Google Shopping and Meta catalogs
4. Missing or thin descriptions — hurts SEO and conversion
5. Low-margin products — items priced below your margin floor, often leftovers from old sales
6. Out-of-stock products still live — wasted ad spend and frustrated shoppers
7. Duplicate or inconsistent tags — breaks automated collections and filtering

Write these down as a checklist. You'll run the same list every time, which is the point — an audit you can repeat beats a heroic one-time cleanup.

Step 1: Get a Baseline Number

Before fixing anything, measure where you stand. You want one number you can track month over month.

The manual way: export your products to CSV, open it in a spreadsheet, and count blanks in the SKU, Cost per item, Image, and Description columns. For a 500-product catalog with 1,500 variants, expect this to take 45–60 minutes the first time.

The faster way: a data quality dashboard does this continuously. BulkOps, for example, scores your catalog out of 100 and lists priority issues — a store might see 75/100 with flags for missing images, missing SKUs, no descriptions, and missing cost per item. Whatever tool you use, the goal is the same: a single score plus a count per issue type, so "clean up the catalog" becomes "fix these 37 specific products."

Step 2: Fix Missing Cost Per Item First

This is the highest-leverage fix because it unblocks everything downstream — margin reports, profit-based pricing, and low-margin detection all depend on cost data.

Filter your products to those with no cost set. If you stock branded goods, your supplier price lists have the numbers: a Lodge 10.25" cast iron skillet might cost you $14.40 against a $29.90 retail price; a Stanley Quencher 40 oz might be $22.50 against $45. Enter real costs where you have them. Where you don't, use your standard purchase discount off MSRP as a placeholder and flag it for correction — a placeholder cost beats a blank, because a blank silently excludes the product from every margin calculation.

With a bulk editor, sort by "no cost set," paste costs in a spreadsheet-style grid, and you can clear 100+ products in 15 minutes.

Step 3: Close the SKU Gaps

Filter for variants with empty SKUs. Then standardize: pick one format and apply it everywhere. A workable pattern is BRAND-PRODUCT-VARIANT, e.g. CAR-K87-NVY-L for a Carhartt K87 pocket tee in navy, size large.

Two rules save you pain later: never reuse an old SKU for a new product, and never encode information that changes (like price) into the SKU. If you sync to a 3PL or marketplace, fix SKUs before the next sync runs — duplicate and blank SKUs are the number one cause of inventory mismatches.

Step 4: Images and Descriptions

Filter products with no image and decide each one's fate: photograph it, pull approved brand assets (most wholesale brands like Patagonia or Yeti provide image libraries to stockists), or unpublish it until you have one. A product with no image shouldn't be live — it converts near zero and drags down your ad feed quality.

For descriptions, prioritize by traffic: fix your 20 most-visited products with thin or missing descriptions first. A solid product description runs 100–300 words, covers materials, dimensions, and use case, and answers the question a shopper would otherwise email you about.

Step 5: Margins, Stock Status, and Tags

Now the cleanup passes that protect revenue:

Low margins. With cost data in place from Step 2, filter for products below your margin floor — say, under 30% gross margin. You'll usually find old sale prices that never reverted and miscalculated bundle prices. Fix them with a formula (cost ÷ (1 − target margin)) rather than one by one.

Out of stock. Decide a policy: hide, keep live with a back-in-stock signup, or archive. Whatever you choose, apply it consistently — a smart tab or saved filter for out-of-stock items makes this a 5-minute weekly check instead of an occasional surprise.

Duplicate tags. Export your tag list and merge variants ("BFCM", "bfcm", "black-friday") into one canonical tag each. Automated collections only match exact tags, so every duplicate is a product silently missing from a collection.

Make It a Habit, Not a Project

The first audit is the big one. After that, schedule a 20-minute monthly pass: check the score, work the new flags, done. Stores that audit monthly typically deal with 5–10 new issues per cycle; stores that wait a year face hundreds.

One more rule: back up your catalog before any bulk fix. A bad find-and-replace across 1,500 variants is only a disaster if you can't roll it back.

If you'd rather not build this from CSVs, BulkOps gives you the audit out of the box — a live data quality score, priority issue lists (missing images, SKUs, costs, descriptions), low-margin and out-of-stock smart tabs, plus bulk editing and automatic backups to fix what you find safely. Try BulkOps free and see your catalog's score in about two minutes.