>>> article

Find the 20% That Drive 80%: SKU Rationalization for Founders

SKU rationalization for founders: a practitioner playbook to free working capital, lift margin, and avoid lost sales using scorecards, cadence, and demand...

Decorative SKU rationalization title card

SKU rationalization is the repeatable process of reviewing every item you sell and deciding whether it earns its place on a shelf, a warehouse rack, or a product detail page. Done right, it frees cash tied up in slow inventory, cuts operational complexity, and lifts blended margin, often without losing meaningful revenue. It matters most to inventory managers and brand owners watching days on hand climb while gross margin quietly erodes.


TL;DR:

  • SKU rationalization is most urgently needed when SKU count grows faster than revenue or days on hand increase without sales growth.
  • Accurate analysis requires 12 to 18 months of sales, margin, and inventory data from multiple systems, with clean item-master information.
  • Pilot changes in one category or region first, then monitor demand transference carefully before full rollout or discontinuation.
  • Assign clear ownership for SKU decisions, document thresholds precisely, and review the catalog regularly to prevent demand shifts from causing revenue losses.
  • External support from consultants can accelerate implementation, especially for complex or large catalogs, by providing diagnostics, execution, and governance assistance.

Commerce Catalyst
Bring Clarity to Your Product Portfolio
Commerce Catalyst helps consumer brand founders translate financial realities into actionable insights for sharper profitability and strategic decisions.
Explore Commerce Catalyst

Table of Contents

What Is SKU Rationalization and Why Does It Matter?

Every SKU you carry has a cost independent of whether it sells: warehouse slot fees, forecasting time, quality checks, packaging inventory, and the cognitive load on your team deciding what to reorder. McKinsey’s product-portfolio research documents a commercial-vehicle manufacturer that cut the number of components it deployed while affecting only a small share of total sales. That gap between complexity removed and revenue lost is the entire economic case for rationalization.

What Is SKU Rationalization and Why Does It Matter?: overview diagram

The benefits compound across three areas. Working capital improves first, since slow-moving inventory sitting on shelves is cash you can’t deploy elsewhere. Forecast accuracy climbs next, because fewer SKUs means cleaner demand signals and fewer stockout-or-overstock swings. Pick paths shorten and picking errors drop, since warehouse staff aren’t hunting through near-duplicate variants.

You likely need a rationalization pass now if you’re seeing any of these:

  • Days on hand creeping up quarter over quarter without a matching sales increase
  • SKU count growing faster than revenue, a classic sign of proliferation outpacing demand
  • Gross margin compressing even though unit prices haven’t changed
  • Warehouse or 3PL fees rising due to slotting and handling complexity
  • New product launches consistently cannibalizing existing SKUs instead of growing the category

Pro Tip: If you can’t say, without pulling a report, which 20% of your SKUs drive 80% of revenue, that’s your first signal a rationalization pass is overdue.

What Data Do You Need Before You Start?

You cannot rationalize a portfolio on instinct. Every credible framework, from Forrester’s to academic supply-chain research, starts with a clean data pull covering 12 to 18 months, long enough to smooth seasonality but recent enough to reflect current demand.

Pull these fields at minimum:

  • Sales velocity in units and revenue, split by channel and, if you operate retail, by store
  • Gross margin and markdown history, plus contribution margin after cost-to-serve
  • Days on hand, stockout frequency, and return rates with reason codes
  • Attach rate or basket data showing which SKUs sell alongside others
Data source What it provides
ERP / item master SKU attributes, cost basis, supplier lead times
POS system Store-level velocity, promotional lift
Ecommerce platform Online conversion, page views, cart attach rate
Warehouse management system Days on hand, pick frequency, storage cost
Finance system Gross margin, contribution margin, markdown spend

Accurate SKU-level analysis depends on clean item-master data. GS1 US’s guidance on UPCs is worth reviewing if your barcode and attribute data has drifted, which happens constantly as products get repackaged or resized without a corresponding item-master update.

How Do You Run a SKU Rationalization Process?

A rationalization program fails most often not from bad analysis but from skipping steps. Here’s the sequence that holds up across categories:

  1. Define objective and scope. Decide whether you’re targeting a single category, a channel, or the full catalog, and state the goal in dollars: cash freed, margin points recovered, or SKU count reduced by a target percentage.
  2. Assemble a cross-functional team with one accountable owner. Academic case studies on SKU deletion found that cross-functional involvement and supplier collaboration were critical to measurable savings, including one project that reported $6.7 million in savings.
  3. Clean the data, then apply a scorecard. Score each SKU against velocity, margin, and strategic fit, and sort into five buckets: keep, improve, regionalize, bundle, or sunset.
  4. Pilot in one category for one replenishment cycle. A contained pilot, industry practitioners at ThoughtSpot note, validates your scorecard before you touch the whole catalog.
  5. Implement operational changes with rollback triggers. Update procurement holds, ecommerce PDPs, and warehouse slotting, and set a specific sales or margin threshold that triggers reinstating a discontinued SKU.

Pro Tip: Build the rollback trigger into your scorecard before you sunset anything. Deciding “if sales of the substitute SKU don’t rise within 60 days, we bring the original back” up front removes the political fight later.

Academic work on SKU deletion argues decisions should model lifetime sales and supply-chain complexity rather than relying on trailing twelve-month velocity alone, since a SKU with modest current sales might still have years of profitable life left.

How Do You Prevent Losing Sales to Demand Transference?

Cutting a SKU doesn’t erase the demand behind it. Customers either shift to a substitute product you still sell, which is fine, or they abandon the purchase entirely. This shows up as lost revenue nobody planned for. Without estimating that transference, teams routinely overstate the savings from a cut and understate the risk.

Test transference before you commit to a full sunset:

  • Run pre/post comparisons on similar SKUs you’ve already discontinued
  • Use geo holdouts, removing a SKU in one region while keeping it live in another, to isolate the real substitution rate
  • Analyze adjacent-SKU sales lift in the weeks after a comparable discontinuation
  • For larger catalogs, build propensity or basket models to predict which customers will substitute versus churn

AlixPartners warns against haphazard cuts and recommends scenario-based modeling precisely because transference risk is so easy to underestimate.

Pro Tip: Phase the sunset instead of pulling a SKU cold. Cut inventory replenishment first, watch how demand redistributes over one cycle, then discontinue the listing once you’ve confirmed where the demand actually went.

Who Should Own SKU Decisions, and How Often?

Rationalization becomes political the moment it lacks clear ownership. Assign a category owner who runs the analysis, a finance approver who signs off on margin assumptions, an operations lead who owns implementation, an ecommerce or content owner who updates listings, and a sales liaison who manages customer and retailer communication.

Document your scorecard with explicit thresholds, not vague judgment calls, and log every exception with a review date attached. Forrester’s framework stresses customer segmentation and migration planning before you discontinue anything a meaningful customer segment depends on.

Set the cadence and stick to it:

  • Quarterly light reviews that flag emerging low performers before they become entrenched
  • One annual deep review covering the full catalog against strategic priorities
  • Supplier and contract check-ins tied to minimum order quantities, lead times, and redistribution of committed inventory

This cadence discipline is the same operational rigor covered in profitability best practices for scaling brands, and it’s what separates a lasting program from a one-time cleanup that quietly reverses itself within a year.

What Tools Do You Need to Support the Process?

You don’t need enterprise software to run a credible program, but you do need specific capabilities in place, whether bought or built.

  • An authoritative item master in your ERP with consistent SKU attributes across systems
  • Business intelligence with SKU-level drilldown and attribute filtering, so you can slice by category, channel, or margin band
  • Cost-to-serve modeling that accounts for storage, handling, returns, and any special handling fees
  • Experiment or holdout capability to measure demand transference before a full rollout
  • Automation touchpoints that place procurement holds, update product detail pages, and adjust bill-of-materials or pack configurations without manual rework

If your rationalization plan involves consolidating variants or updating PDPs, improving product pages for conversion and SEO during the migration prevents a common failure mode: losing organic traffic on a page you merged instead of redirected properly.

How Does Commerce Catalyst Approach SKU Rationalization?

A DTC Financial Health Assessment typically surfaces SKU-related constraints before a founder even frames the problem that way. Margin dilution, working capital strain, and forecasting chaos usually trace back to the same root cause: too many SKUs competing for the same shelf space and marketing dollars.

This diagnostic work can be paired with unit-economics modeling, running CAC, LTV, and MER against specific SKU scenarios before anything gets sunset. That sequencing matters because a SKU with thin margin but strong customer acquisition value can be worth keeping even when a scorecard alone would flag it for removal.

In a typical first wave, brands act on a meaningful minority of their catalog rather than a sweeping cut, with actions split across three types:

  • Full discontinuation for SKUs with weak velocity and no strategic role
  • Consolidation, merging near-duplicate variants into one SKU with fewer options
  • Repricing or repackaging to fix a margin problem without losing the product entirely

Get Expert Help Running Your SKU Rationalization Program

Running a rigorous rationalization program while managing daily operations is where most internal efforts stall out, not because the framework is unclear, but because nobody has the bandwidth to own it end to end. Some consulting services provide founders a faster path: a diagnostic that pinpoints which SKUs are dragging on cash and margin, followed by execution support rather than just a report you file away.

Commercecatalyst

The DTC Financial Health Assessment identifies which SKUs are constraining your cash flow and margin, and prioritizes which cuts, consolidations, or repricing moves matter most. For brands that need ongoing execution rather than a one-time report, the Fractional COO engagement can run the cross-functional governance a rationalization program requires, including the scorecard reviews and supplier coordination that keep results from reversing. If you’re unsure which operational move to tackle first, the Next Move Finder tool helps you pressure-test SKU cleanup against other priorities before you commit resources. Start with the diagnostic to see exactly where your portfolio is costing you.

Where to Read More on Portfolio Rationalization

For teams that want to go deeper into the research behind this framework, these sources cover the consulting and academic foundations referenced throughout this article:

Sources

FAQ

What is the 80/20 rule for SKU rationalization?

It’s the observation that roughly 20% of your SKUs typically generate around 80% of revenue, which means the remaining SKUs deserve close scrutiny for whether they earn their shelf space, cash tied up, and operational overhead.

What does it mean to rationalize a SKU?

Rationalizing a SKU means evaluating it against sales velocity, margin, and strategic fit, then deciding to keep it as is, modify it, consolidate it with another SKU, or discontinue it entirely.

What does SKU mean?

SKU stands for stock keeping unit, a unique code identifying a specific product variant, including its size, color, or packaging, that a business tracks for inventory and sales purposes.

How do you do a SKU analysis?

Pull 12 to 18 months of sales velocity, gross margin, days on hand, and return data by SKU, then score each item against a simple keep, improve, consolidate, or sunset framework before making any changes.

>>> next step

Want to see where your business actually stands?

Run the numbers through the diagnostic, or talk it through with someone who has been in your seat.

Get the Diagnostic Book a Founder Hour