Auditing the Catalog for Dead or Unprofitable Entries

Why this matters

Every price book accumulates dead weight. A line item gets added for one customer, a seasonal service never gets removed after the season that justified it, a bundle gets underpriced at launch and nobody revisits it once volume picks up. None of this is dramatic on its own, but a catalog nobody has audited in a year or two is quietly training your office staff to quote from muscle memory instead of from what actually makes money. A regular audit is how you find the entries that are costing you margin, confusing customers, or simply sitting there unused.

Step 1: Pull twelve months of catalog usage

Before touching a single price, get the data. For every line item, pull:

• How many times it was sold in the last twelve months.
• Average margin on those jobs (labor plus material cost against what was actually collected, not the list price).
• Callback or rework rate tied to that specific service, if you track it that granularly.
• How it was priced last time it was reviewed, and how long ago that was.

If your system does not cleanly separate line items this way, this step alone is worth doing by hand once. It is the single most revealing exercise in a catalog audit because gut sense about "what we sell a lot of" is wrong more often than owners expect.

Step 2: Sort every entry into one of four buckets

With usage and margin in front of you, sort the whole catalog:

1. Healthy. Sold regularly, margin holds up, no unusual callback pattern. Leave these alone; an audit is not an excuse to fix what isn't broken.
2. Dead. Zero or near-zero sales in twelve months. These are candidates for retirement, not for a price adjustment, because nobody is buying them at any price you have tried.
3. Underpriced. Sold regularly but margin is thin or negative once true labor and material cost are counted. These need a price correction, not removal, since demand clearly exists.
4. Problem child. Decent margin on paper but an outsized callback or complaint rate. These need a scope or process fix before a price fix; raising the price on a service that keeps generating rework just makes the rework more expensive.

Step 3: Investigate before you cut anything

A dead entry is not automatically a bad entry. Before retiring it, check:

• Was it ever marketed or shown to customers? A line item buried on page three of an internal list that customer-facing staff never mention will show zero sales regardless of demand. That is a visibility problem, not a demand problem.
• Is it a loss-leader on purpose? Some low- or no-margin entries exist to open the door to a bigger job. Confirm whether this one is doing that job before cutting it as "unprofitable."
• Is it seasonal? A service with zero sales in an off-season audit window is not dead, it is dormant. Check a full seasonal cycle before retiring anything tied to weather or calendar demand.

Step 4: Act on each bucket

• Retire dead entries cleanly. Remove them from active booking and pricing tools, but keep a record of what they were and why they were cut, so a future team doesn't accidentally reintroduce the same underperformer. See related: The Not-in-Our-Catalog Referral-Out Decision Tree for how to handle a customer who asks for a retired line item.
• Reprice underpriced entries with the real cost basis, not the old assumption. If material or labor cost has risen since the entry was last priced, correct it to current cost plus your standard target margin, not to "a little more than before."
• Fix problem children at the process level first. Update the checklist, add a required diagnostic step, or restrict who is qualified to run that service, then re-measure before deciding whether a price change is also needed.
• Leave healthy entries untouched, but note the audit date so the next review has a clean before/after comparison.

Step 5: Set a standing cadence

A one-time cleanup fades within a year if there is no repeat schedule. Put a catalog audit on the calendar, at minimum annually, and tie it to a natural business rhythm (end of fiscal year, start of the busy season) so it does not get skipped when things get busy. A quarterly light-touch check (usage counts only, no deep repricing) between annual full audits catches drift early and keeps the full audit from becoming a multi-day project every time.

References

• See related: Building the Catalog Entry for a Brand-New Service Line
• See related: Catalog Consistency Across Multiple Locations
• Trade-standard practice for periodic price-book review
• U.S. Small Business Administration guidance on pricing and margin analysis