§ Guide

SKU Truth: Why Your Catalog Is Lying (and What It's Costing You)

The data-quality problems hiding inside most industrial catalogs—missing alternates, stale pricing, ambiguous part numbers—and a practical audit you can run this week.

Short answer: the spreadsheet version of your catalog is almost always lying. Missing alternates, stale prices, ambiguous part numbers, and orphaned records are the four leaks we find at every manufacturer and distributor—and every one of them quietly bleeds margin.

The four leaks you'll find

  • Missing alternates — the part your rep quoted is on a 12-week lead time; the equivalent part is in your warehouse. The catalog doesn't know they're related.
  • Stale pricing — cost files from Q2; quotes going out in Q4; margin has walked off the job.
  • Ambiguous part numbers — the same SKU refers to three different revisions. Your reps know which; your new hires don't; your AI agent never will.
  • Orphaned records — items with no category, no supplier, no active status. They show up in quotes and cause quiet embarrassment at the counter.

A one-week audit you can run

  • Day 1 — export the catalog to CSV. Flag any row missing category, supplier, active status, or list price. Count them. That number is your first leak metric.
  • Day 2 — cross-reference every SKU quoted in the last 90 days against in-stock inventory. Flag every time a quote used an out-of-stock SKU when an alternate was on the shelf.
  • Day 3 — sample 50 SKUs at random. For each, ask: does a new hire have enough here to build a quote without asking a veteran? If fewer than 40 of 50 pass, your catalog is leaning on tribal knowledge.
  • Day 4 — walk the dates. Flag any cost or price that hasn't been refreshed in 120+ days.
  • Day 5 — present the leak metrics to your ops leader. Now you're talking about data, not feelings.

Why this matters more every quarter

Enterprise buyers are running procurement agents. Those agents don't call your sales team, don't open PDFs, and don't tolerate ambiguity. If your catalog can't answer “what's the current price, the lead time, and the alternate for this part” in a machine-readable format, you aren't in the consideration set. See AI-ready infrastructure for what the machine-readable version looks like.

The fix is sequenced, not heroic

Don't rip-and-replace your ERP. Layer a clean catalog on top of it: inventory visibility first, then a real inventory system, then pricing and alternates. Each layer removes one class of leak.

Next reads: AI for distribution and layering AI on top of your ERP.