SKU Profitability: Finding the Products That Quietly Lose Money

Operbit · September 15, 2026

Why Revenue Rankings Lie

Every company knows its best-selling SKUs. Almost none know their most profitable ones, because the standard report stops at gross margin (price minus purchase cost), and gross margin is where the lying starts. The products quietly losing money are almost never the obvious dogs; they're respectable mid-tier sellers whose true costs never made it into the math.

The Three Layers of Honest Cost

• Landed cost: purchase price plus freight, duties, and inbound handling. For imported goods this moves margin by five to fifteen points, and a SKU-level average freight allocation is usually wrong in both directions.
• Cost-to-serve: what it costs to stock, pick, and ship this SKU: warehouse space for slow movers, special handling, breakage, returns rate. A bulky C-item that turns twice a year is renting your warehouse below market.
• Cost of complexity: the hardest to see: every additional SKU adds purchasing lines, counts, planogram slots, and forecast error. This is why the fix is usually rationalization, not repricing.

The Method, Compressed

Pull twelve months of sales by SKU. Apply real landed costs: actual freight by shipment where you have it, honest allocation where you don't. Layer a simple cost-to-serve model: storage by cube and turns, handling by order lines, returns at actuals. Then rank the portfolio by contribution dollars, not margin percent (a 60%-margin item selling twelve units a year is not helping), and read the bottom quintile with a cold eye.

What the Bottom Quintile Deserves

Four verdicts, in order of preference: reprice (some losers are one honest price increase from respectable), reorder differently (bigger, rarer purchases fix some freight-driven losers), keep knowingly (a real traffic-driver or line-completer can earn its loss, but now it's a decision, not an accident), or cut. In our category work with distributors, the cut list typically runs ten to twenty percent of SKUs. The shelf and working capital it frees are the fastest money in the building.

This analysis is where our analytics and category practices meet: the numbers come from the analytics retainer, and the shelf decisions run through category management with ShopperExperts. If the data to do it doesn't exist yet, that's a sign worth reading too: seven signs you've outgrown spreadsheets.