Product Data Audit Template: Find What's Broken in Your Catalog (Free Download)

Your catalog has bad data in it right now. I can say that with confidence because every catalog does. Products get added in a rush, descriptions get copy-pasted, images go missing, SEO fields stay blank. It happens slowly and then all at once.

The problem is that bad product data costs you money in ways that are hard to measure. A missing description kills conversion. A missing alt tag hides you from Google Image Search. Wrong variant options confuse customers into bouncing. No compare-at price means your sale looks like your regular price.

I built an audit template that checks all of it. Download it, run through your catalog, and you'll know exactly which listings need work and how bad the damage is.

Why product data degrades

Nobody launches a store with bad data on purpose. The decay is gradual.

Your first 20-50 products were uploaded carefully. Then you added 200 more in a weekend and descriptions got shorter. Tags became inconsistent: some products got "Size" as an option name, others got "Sizes." You skipped alt text because you were in a hurry. Nobody noticed because there was no checklist.

Seasonal products pile up. Holiday bundles and clearance items get thrown in with minimal data. Half of them are still in your catalog months later with titles like "Holiday Bundle 2024" and no description.

Multiple people touching the catalog makes it worse. Your VA used different tag formats. A freelancer uploaded products with SKUs as handles instead of URL slugs. Another person left inventory tracking off and now 40 products show as in-stock with no actual quantity.

This is normal. Every store with more than 50 products has some version of this problem. The question is how bad it is and where to start.

What the audit checks

The template checks each product across seven areas: titles, descriptions, images, pricing, variants, SEO, and tags.

Titles get a quality score from 1 to 5. A 1 is missing or gibberish. A 5 is specific enough that a search engine knows what the product is and a customer knows whether to click. "Blue Shirt" is a 2. "Classic Cotton Crew Tee - Riverbank Apparel" is a 4.

Descriptions get three checks: existence, word count, and uniqueness. Thin descriptions hurt both conversion and SEO. A product with an 8-word description is essentially undescribed. The uniqueness check catches copy-paste: if you duplicated the same description across 15 products and changed only the color name, Google sees that as duplicate content.

Images check count, alt text, and background consistency. Products with zero images are invisible. Products missing alt text are invisible to Google Image Search and screen readers. Background consistency matters because if half your products are shot on white and half on a kitchen counter, your collection pages look chaotic.

Pricing catches products with missing compare-at prices. If you run sales by reducing prices but never set the original price in the compare-at field, customers see no strikethrough, no savings badge, no urgency. The sale is invisible.

Variants checks for option name accuracy and whether inventory tracking is on. A product with bundle sizes listed under an option called "Color" confuses the storefront dropdown. On Shopify, the Variant Inventory Tracker field must be set to "shopify" or inventory tracking does nothing, silently.

SEO checks meta title and meta description. If blank, Shopify auto-generates them from the title and description. That's not terrible, but a hand-written meta title under 60 characters with your target keyword will outperform the auto-generated version. Prioritize your top 20% by revenue for custom SEO fields.

Tags check existence and format consistency. Products without tags are invisible to collection filters. Products with inconsistently formatted tags create filter chaos: "crew-neck" and "Crew Neck" and "crewneck" show up as three separate filter options for the same thing.

Scoring and prioritizing

The template has an Overall Score column from 0 to 100. Sort it ascending: the worst products float to the top.

Products scoring below 40 are critical. These are actively hurting your store: confusing customers, wasting crawl budget, making your catalog look unfinished. Fix these first, or unpublish anything truly broken. Products scoring 40-69 need scheduled attention. Work through them in batches of 20-30. Products above 70 are fine for now.

A catalog with most products scoring below 40, widespread duplicate descriptions, or completely random tag formatting is usually better served by a full rebuild than incremental fixes. Export your catalog, clean the data in a fresh spreadsheet, and re-import. The Shopify CSV import template covers the re-import process if you're on Shopify.

The five example products

The template comes with five example rows showing a range of catalog quality issues.

classic-cotton-crew-tee (Score: 98) is the benchmark. Every field filled, images have alt text, tags are consistently formatted, SEO is complete, inventory is tracked.

bamboo-wireless-charger (Score: 52) has one image with no alt text and blank SEO fields. The product itself is fine; the listing is half-optimized. Common in stores that prioritize getting products live over getting them right.

rustic-oak-shelf (Score: 25) has no description, no compare-at price, inventory tracking off, mixed-background images, and inconsistent tags. This is the listing that was rushed and never revisited.

holiday-gift-bundle-2025 (Score: 30) has a vague title with no keywords, an 8-word description copied from another listing, no tags, and mislabeled variants: it uses "Color" as the option name when the actual variants are bundle sizes.

MS-LAV-6PK (Score: 15) has a raw SKU as the URL handle, no title, no images, no price. This is a draft that was somehow published. It needs a complete rebuild or should be unpublished immediately.

Delete the example rows and replace them with your own products.

If your audit turns up more problems than you have time to fix, send me your catalog export at flash@tryflash.ai. I'll run the audit, fix the data, and re-import the clean version to your store. Product data cleanup is one of the most common jobs I handle.

Frequently asked questions

How do I audit product data in Shopify? Export your catalog from Shopify admin (Products > Export > All products as CSV). Open the export and check each product for: missing or thin descriptions, blank image alt text, blank SEO meta fields, Variant Inventory Tracker not set to "shopify," inconsistent option names, and missing compare-at prices. Sort by completeness to find the worst offenders first. The audit template automates this scoring process across 7 dimensions with a single score per product.

What is a good product data quality score? Products above 70 are in good shape. Products scoring 40-69 need scheduled cleanup — they have gaps that affect SEO or conversion but aren't actively breaking anything. Products below 40 are actively hurting your store: confusing customers, wasting crawl budget, or creating a broken experience. A catalog with most products below 40 is usually better served by a full data rebuild than incremental fixes.

Why does product data degrade over time in ecommerce stores? The first products get uploaded carefully. Then velocity increases: 200 products added in a weekend with short descriptions, inconsistent tags, skipped alt text. Multiple people touch the catalog with different formatting habits. Seasonal products get created in a rush and never cleaned up. Inventory tracking gets disabled on some products and nobody notices. The decay is gradual and invisible until you look at the whole catalog at once.

How do I fix duplicate product descriptions across my catalog? Export your catalog as CSV, sort by the Body (HTML) or description column, and identify rows with identical text. Rewrite descriptions from scratch for each affected product — paraphrasing is not enough to avoid Google's duplicate content detection. Prioritize products with the most traffic first. If you have hundreds of duplicates, a full catalog rebuild with unique descriptions for every SKU is more efficient than fixing them one at a time.

Which Shopify product fields are most commonly incomplete? In order of how often they're missing: Variant Inventory Tracker (silently disabled, causes inventory tracking failures), compare-at price (products look full-price even when discounted), image alt text (invisible to Google Image Search and screen readers), SEO meta description (auto-generated is worse than hand-written for top products), and tags (inconsistent formatting creates broken collection filters). These five fields drive the majority of low audit scores.

How do I find Shopify products with inventory tracking turned off? Export your catalog as CSV and filter for rows where the Variant Inventory Tracker column is blank or not equal to "shopify." Products with tracking off show as perpetually in-stock with no actual quantity management. Tracking can look completely normal in the Shopify admin product editor but be silently disabled at the variant level. The only reliable way to catch it across your full catalog is via CSV export or a systematic variant-level audit.