← All posts
CatalogJuly 20266 min readBy Siddharth Deepak — Founder

SKU Rationalization: Find the SKUs Quietly Eating Your Profit

Most catalogs follow a brutal curve: the top fifth of SKUs funds everything, and a long tail quietly burns cash on storage, returns, and ad spend.

The shape of almost every catalog

Rank your SKUs by contribution dollars and the curve is nearly always the same: a short head that generates most of the profit, a long middle that roughly breaks even, and a tail that costs money to keep alive. The tail doesn't look scary on a revenue chart — it looks scary on a contribution chart.

The three-bucket pass

The math that sorts the buckets

sku_contribution = Σ(order_line_revenue) − Σ(cogs) − Σ(alloc_fees + fulfillment + returns) − attributed_ads
tail_flag = sku_contribution < 0 AND assist_rate < 5%

The assist check matters: some low-margin SKUs are how customers discover you. Check what fraction of repeat customers' first orders contained the SKU before killing it.

What a pass is worth

Cutting a genuinely negative tail does three things at once: contribution goes up, inventory carrying cost goes down, and ad accounts stop bidding on products that lose money per conversion. It's the rare move that improves the P&L and simplifies operations in the same step.

Run rationalization quarterly — costs drift and yesterday's keeper becomes today's leak.
Computed, not estimated

ProfitFalcon runs this exact math on your store exports — every number verifiable.

Try ProfitFalcon free