The Catalog Sprawl Problem
Catalog growth is a natural symptom of a brand finding its footing. You add a new colorway because a retailer asked. You launch a variation because a loyal customer wanted it. You try a different size run because you thought the demand was there. Over time, you end up with 280 active SKUs where 180 might have been enough — and most of the excess is in the tail: SKUs that account for the last 5–10% of revenue but consume a disproportionate share of forecasting effort, DC space, and open-to-buy budget.
SKU rationalization is the discipline of systematically identifying and acting on that tail. Done well, it doesn't mean stripping your catalog to the bare minimum — it means understanding which SKUs are genuinely contributing to your business objectives (revenue, margin, customer acquisition, channel strategy) and which ones are just consuming working capital and planning bandwidth.
Most growing brands carrying 150+ SKUs have never done a structured rationalization. The typical outcome of a first-time exercise: 15–25% of SKUs identified for discontinuation or consolidation, with meaningful freed capital and a measurably simpler forecasting workload.
Building Your SKU Performance Matrix
The starting point for any rationalization effort is a clean performance matrix: a single view of every active SKU across the dimensions that matter for your specific business. The minimum viable set of dimensions typically includes:
- Revenue contribution (trailing 52 weeks): Absolute revenue and percentage of total catalog revenue.
- Gross margin per unit: After COGS, not before. SKUs that look good on revenue often look different on margin once returns and wholesale margin stacking are accounted for.
- Sell-through rate: What percentage of units received in the last two seasons sold through at full price? This is the single most honest indicator of how well demand matched supply.
- Inventory turn rate: How many times did this SKU's average inventory position turn in the past year?
- Weeks-of-stock on hand (current): How long will current inventory last at the current selling rate?
- Forecasting error (MAD or MAPE): How accurately were you forecasting this SKU? High-error SKUs are systematically harder to plan and should be rationalized unless they carry strategic importance.
The matrix itself is not the output — it's the input. The analysis that follows sorts SKUs into quadrants based on these dimensions and identifies action categories.
The Four Action Categories
A rationalization exercise ultimately sorts SKUs into four action categories, regardless of how sophisticated the underlying analysis is:
1. Core — Protect and Optimize
High revenue, good margin, strong sell-through, manageable WOS. These SKUs are your business. The rationalization exercise validates them and ensures they're getting the buying and forecasting attention they deserve — including proper safety stock and replenishment priority.
2. Strategic — Invest Selectively
Lower revenue or margin today, but either growing velocity, serving a strategic channel relationship, or anchoring a customer segment you need. These SKUs require judgment — not automatic retention, but also not automatic cuts. The question is whether the strategic value is explicitly defined and time-bounded.
3. Underperforming — Fix or Exit
Low sell-through, high WOS, often poor margin. The usual suspects in this category are colorway variations on proven styles that weren't validated before launch, size extensions into runs that don't have sufficient demand, and geographic-specific assortments that never reached critical velocity. The question for each: is the underperformance fixable (pricing, placement, channel shift) within a defined timeframe? If not, plan the exit now.
4. Tail — Discontinue Systematically
The true tail: SKUs with less than 1% of catalog revenue, sell-through below 50%, and no strategic rationale for retention. These are the ones that should be marked for discontinuation in the next buying cycle. The goal isn't to cut them overnight — you may have committed inventory that needs to be sold through. But the clear designation prevents them from being reordered by default.
A Scenario: The Colorway Trap
Consider a growing accessories brand with 340 active SKUs, approximately 90 of which were colorway variations of their core bag line. The original strategy had been to give retailers wide color assortment so every door could offer variety. The practice reality: seven colorways accounted for 78% of unit sales across the bag line. The remaining 83 colorways collectively represented 22% of unit sales but required individual forecasting, individual inventory positioning, and individual markdown decisions.
The rationalization analysis revealed that 41 of those 83 tail colorways had a trailing-52-week sell-through rate below 45%. The capital tied up in slow-moving colorway inventory represented approximately 3.5 months of working capital that could have been redeployed into deeper buys on the top seven.
The decision wasn't to immediately discontinue all 41. Some had committed inventory that needed a clearance strategy first. But the analysis created a clear roadmap: 41 colorways phasing out over two seasons, 7 receiving deeper buy commitments, and the remaining 42 subject to quarterly sell-through review before any reorder decisions.
The planning team's workload dropped meaningfully because they were no longer writing forecasts for SKUs that didn't have enough history to forecast reliably anyway.
What Rationalization Is Not
We're not saying a smaller catalog is always better. There are businesses where breadth is the value proposition — marketplace sellers, specialty retailers with a curation mandate, brands serving customers who need full-size runs and won't tolerate gaps. For those businesses, catalog depth is a feature, and the rationalization logic needs to be adjusted accordingly (more focus on fill rate performance by size/spec, less on revenue contribution).
What rationalization addresses is catalog size that outpaced the planning infrastructure's ability to manage it. If your team can accurately forecast and allocate 80 SKUs but you're carrying 200, the extra 120 SKUs are creating more planning noise than commercial value.
The Buying Cycle Integration
Rationalization only produces durable results when its outputs are integrated into the buying cycle. The most common failure mode: a rationalization exercise produces a list of discontinuations, the list gets filed, and the following season's buy meeting doesn't reference it. New SKUs are added without accountability to the discontinuation targets, and catalog size grows again within 18 months.
The integration mechanism is simple but requires discipline: before any new SKU is added to the buy plan, the buyer must identify a corresponding discontinuation or confirm the SKU is replacing an existing one (variation on a proven style, not a net addition). SKU adds and SKU exits should run on the same ledger.
Some planning teams formalize this as a "slots" model: the catalog has a defined maximum number of active SKUs per category, and adding a new slot requires retiring an existing one. The ceiling forces explicit prioritization rather than default accumulation.
Rationalization isn't a one-time cleanup — it's a discipline that prevents future complexity from compounding. The brands that build it into their buying process don't need emergency cleanup exercises. They just carry less dead weight as a matter of routine.
