Every product in your catalog started with a good reason. A customer asked for it. A supplier offered a deal. A sales rep promised it would move. Fast-forward a year and the warehouse is full of variants nobody orders, shelf space is stretched thin, and the team spends more time managing exceptions than filling orders.
That is SKU proliferation, and it is one of the quietest margin killers in operations. The fix is not a one-time purge. It is a repeatable review process called SKU rationalization: score every item, decide what stays, and communicate the changes so the business does not panic.
SKU rationalization is not about having fewer products. It is about having the right products - the ones that earn their shelf space, warehouse slot, and management attention.
Why catalogs grow faster than they should
Product catalogs expand for understandable reasons: new customer segments, supplier promotions, seasonal experiments, private-label extensions. The problem is that additions are easy and removals are hard. Nobody wants to be the person who killed a SKU that "might still sell."
The numbers tell the story. In 1970, the average grocery store carried about 7,000 SKUs. Today that number exceeds 40,000, according to Inbound Logistics. Across industries, the pattern is the same: additions outpace removals, and the long tail quietly drains cash.
Every SKU on the shelf costs 20-30% of its value per year in storage, handling, insurance, and depreciation. Slow movers sit longer and cost more per unit sold.
More SKUs means more demand signals to track. Thin demand streams are noisy and hard to predict, which leads to either overstocking or stockouts on the tail.
Similar-looking variants in adjacent bins increase mispicks. Each additional SKU adds a decision point for warehouse staff.
When planners manage thousands of items, the slow movers get ignored until they become dead stock. By then the write-off is already locked in.
Boston Consulting Group estimated that in consumer packaged goods alone, $16 billion to $28 billion in profits are lost to unnecessary product complexity. The drag is not limited to large corporations. Small teams feel it even more because every slow-moving SKU competes for the same limited warehouse space, cash, and management time.
The 80/20 reality of most catalogs
Before you start cutting, you need to see the shape of your catalog. In nearly every product assortment, a small share of SKUs generates most of the value. The Pareto principle - roughly 80% of revenue from 20% of items - holds remarkably well across retail, wholesale, and manufacturing.
An Inbound Logistics case study illustrates the extreme version: a craft supplies distributor with 5,000 SKUs found that only 2% (105 items) qualified as A-class products. More than 4,000 items generated just 5% of annual sales. The analysts had to create a D category because the standard A-B-C tiers could not capture how little the tail contributed.
If you have not run an ABC analysis on your own catalog recently, start there. Our ABC inventory analysis guide walks through the math step by step. The output gives you a clear picture of which items are pulling their weight and which ones are just taking up space.
Gut-feel pruning is how teams accidentally discontinue a low-volume item that a key account depends on. Always score before you cut.
How to score every SKU: a practical decision framework
ABC analysis sorts items by revenue contribution, but revenue alone does not tell the full story. A high-revenue SKU with negative margin is worse than a moderate seller with healthy profit. A solid SKU rationalization process scores items across multiple dimensions so the decision is balanced.
The five scoring dimensions
Units sold per period. Flag anything with zero movement for 90+ days. Compare against category averages, not just absolute thresholds.
Revenue minus COGS for that SKU. Use GMROI (gross margin return on investment = gross margin / average inventory cost) to see how much profit each dollar of inventory generates. A GMROI below 1.0 means the item is losing money on the shelf.
How long does the average unit sit before it sells? Compare this to your category target. Items with 180+ days on hand in a fast-turn category are strong candidates for review.
Is this SKU a must-stock for a key account or a contractual obligation? Low-volume items that anchor a relationship need a different evaluation than low-volume items nobody asks for.
Some items exist to complete an assortment, attract foot traffic, or support a bundle. If removing the SKU would hurt the performance of higher-value items, that matters.
Sorting into four buckets
Once every SKU has a score across those dimensions, sort them into action buckets.
Strong velocity, healthy margin, reasonable days on hand. These are your A and solid B items. Protect their stock levels and service.
Moderate performance or mixed signals (for example, decent margin but slowing velocity). Review again next quarter with updated data.
Near-duplicate variants splitting demand. Merge sizes, colors, or packaging options into fewer SKUs that cover the same need.
Low velocity, low margin, no strategic role, no customer dependency. Plan an exit: markdown, bundle, return to supplier, donate, or write off.
GMROI = gross margin / average inventory cost. A result of 3.2 or higher is a common retail benchmark. Below 1.0 means the item costs more to hold than it earns. Use it alongside velocity to separate profitable slow movers from unprofitable fast movers.
Spotting the hidden drains: what the data reveals
When you run the scoring exercise for the first time, a few patterns almost always surface.
Items with zero or near-zero sales for 6+ months that nobody has formally reviewed. They sit in the system, occupy bin locations, and get counted every cycle - all for no return.
Products that sell but lose money after you account for freight, handling, and markdowns. One case study found that 20% of a manufacturer's SKUs - including $1.2 million in negative-margin products - were actively eroding performance.
Two sizes of the same product where 95% of demand goes to one size. Or three colors where one color accounts for 80% of sales. The tail variants add complexity without meaningful revenue.
Parts, accessories, or refills for a parent product that was discontinued months ago. The parent left but the children stayed.
The Netstock 2025 Supply Chain Planning Benchmark Report found that 17% of SMBs carry more than 10% of their inventory unsold for 12+ months, up from 12% the prior year. Excess stock averaged 38% of total SMB inventory. That is a lot of cash sitting on shelves doing nothing.
How to set a review cadence that sticks
A one-time cleanup feels productive, but catalogs grow back. The only way to keep complexity in check is a repeatable review cadence. Here is a practical rhythm that balances thoroughness with operational reality.
Review a simple report of zero-movement SKUs, items below margin threshold, and days-on-hand outliers. This takes 30 minutes and catches problems early.
Pick one product category per quarter. Re-score every SKU in that category, update the keep/watch/consolidate/discontinue buckets, and action the discontinue list.
Once a year, run the full scoring exercise across the entire catalog. Align it with budget planning so discontinuation savings feed into the next year's inventory investment.
Avoid running major rationalization during peak season. Schedule removals during quieter windows so the team can manage the transition without risking service on high-demand items.
Do not wait for the next scheduled review if you see a sudden spike in return rates, a warehouse space crunch, a merger or supplier consolidation, or a jump in carrying costs. These events call for an immediate rationalization pass.
Communicating SKU changes without causing panic
The analysis is the easy part. The hard part is getting sales, purchasing, and leadership to agree on what goes. SKU discontinuation touches revenue forecasts, customer relationships, and supplier contracts. If you spring it on people, expect resistance.
Build a cross-functional review team
SKU rationalization should not live in one department. Assemble a small working group with representatives from operations (who see the warehouse impact), finance (who see the margin data), sales or account management (who know which customers care), and purchasing (who manage supplier terms). Give the group clear decision rights: who can approve a discontinuation, who can escalate, and what data is required to make the call.
Lead with data, not opinions
When you present the discontinuation list, show the numbers: velocity, margin, days on hand, GMROI, and customer dependency. "This SKU sold 3 units in 12 months, has a GMROI of 0.4, and no active customer orders" is harder to argue with than "I think we should drop this."
Give stakeholders a window to respond
Publish the proposed discontinuation list 2 to 4 weeks before execution. Let sales flag any customer dependencies you missed. Let purchasing flag contractual obligations or minimum-order commitments. If someone wants to keep an item, they need to provide a business case, not just a feeling.
Internal communication checklist
- Share the scoring criteriabefore sharing the results. People accept outcomes more easily when they understand the method.
- Publish the proposed listwith a clear response deadline (2-4 weeks).
- Document exceptionswith a business case. If a low-scoring SKU stays, record why so the decision can be revisited.
- Notify affected teamsof the execution timeline: when orders stop, when remaining stock is cleared, when the SKU is deactivated in the system.
- Update master datapromptly. A discontinued SKU that lingers in the ordering system will get reordered by accident.
Exiting a SKU without wasting what is left
Once a SKU is approved for discontinuation, you still need to clear the remaining inventory. Letting it sit is not a plan - it just delays the carrying cost.
Discount the item to accelerate sales. Set a time limit: if it does not clear in 30-60 days at the reduced price, move to the next option.
Pair the slow mover with a popular product as a value-add. This works well for accessories, consumables, or complementary items.
Some suppliers accept returns or exchanges, especially if the product was part of a promotional push. Check your terms before assuming this is off the table.
If you operate multiple locations, another site may have demand for the item. Transfer before you write off.
When all else fails, donate for a tax benefit or write off the remaining value. The goal is to free the bin, the system record, and the management attention.
Preventing the catalog from growing back
Pruning without changing the habits that caused the bloat is like weeding a garden without pulling the roots. The catalog will grow right back.
New-SKU gate checklist
- Require a business case for every new SKU.Projected volume, target margin, expected days on hand, and the customer or segment it serves.
- Set a trial period.New items get 90-180 days to hit minimum velocity and margin targets. If they miss, they go on the watch list automatically.
- Apply a one-in, one-out rulewhere practical. If a new variant enters, identify the weakest existing variant in the same category for review.
- Review supplier-pushed additions critically.A good deal on unit cost does not help if the item sits for 9 months and gets written off.
These gates do not block innovation. They make sure every new item earns its place instead of drifting in unchecked.
A 30-day SKU rationalization sprint
If you have never done a formal rationalization, here is a four-week plan to get started without disrupting daily operations.
30-day sprint
- Week 1 - Pull the data.Export 12 months of sales, margin, and inventory data by SKU. Run an ABC analysis and calculate GMROI for every item. Flag zero-movement and negative-margin SKUs.
- Week 2 - Score and sort.Apply the five scoring dimensions (velocity, margin, days on hand, customer dependency, strategic role). Sort every SKU into keep, watch, consolidate, or discontinue.
- Week 3 - Review and align.Share the proposed discontinuation list with the cross-functional team. Collect feedback, document exceptions, and finalize the exit list.
- Week 4 - Execute and measure.Begin clearing discontinued stock (markdown, bundle, return, transfer, or write off). Deactivate SKUs in the system. Set a 90-day follow-up to measure the impact on carrying cost, warehouse utilization, and order accuracy.
What good looks like after the cleanup
Teams that run a disciplined rationalization process typically see results across several areas.
Fewer slow movers means less cash tied up in storage, insurance, and depreciation. Industry data suggests holding cost reductions of 15-30% on the pruned portion of the catalog.
Removing dead weight lifts the average. Our inventory turnover guide explains how to read and improve this metric.
Fewer SKUs means fewer bin locations, fewer pick paths, fewer count lines, and fewer forecasting headaches. The warehouse gets easier to run.
Concentrated demand across fewer items produces cleaner signals. Planners spend less time chasing noise in the tail.
The dollars that were parked in slow stock can be reinvested in faster-moving, higher-margin inventory - or simply improve your cash position.
A healthcare equipment provider profiled by Beckway reduced its catalog from 7,000 SKUs to 300 and identified $750,000 in savings, with 15% annual savings from supply chain optimization alone. You do not need a 97% reduction to see results, but even a modest prune of the bottom 10-20% of your catalog can unlock meaningful improvements.
Final takeaway
A bigger catalog is not a better catalog. Every SKU should earn its place through velocity, margin, or strategic value. If it cannot, it is consuming cash, space, and attention that could go to the products your customers actually buy. Build a repeatable scoring process, set a review cadence, and make pruning a normal part of how you manage inventory - not a crisis response.