In this article, learn about:
Why slow movers persist and how to catch sell-through signals before they become excess inventory
How to set up an early-warning system using sell-through rate, weeks of supply, and reorder gap
How to read retailer POS data and distinguish demand problems from distribution and execution failures
How to apply a keep-fix-cut framework to make deliberate SKU rationalization decisions
Excess inventory rarely arrives without warning. In most cases, the slow mover was visible in the sell-through data for weeks, sometimes months, before it became a markdown, a deduction dispute, or a discontinued item with channel inventory to unwind. Product assortment management is the discipline that catches those signals early enough to act on them.
This article is written for suppliers, not merchants. Most assortment content is written for buyers deciding what to carry. This piece focuses on the supplier side: reading sell-through velocity at the SKU and account level, setting thresholds that surface slow movers before they become excess inventory, and making keep-fix-cut decisions deliberately rather than by default.
The stakes are real. IHL Group's research puts global inventory distortion losses at $1.73 trillion annually, and vendor issues are identified as the primary driver of both overstocks and out-of-stocks. Buyers have data-driven reasons to scrutinize supplier assortments. The supplier who surfaces a problem first and arrives with a recommendation controls the narrative. The one who waits to be told has already lost the conversation.
Why Slow Movers Persist: The Timing Problem
Slow movers persist for one reason: suppliers act on assortment data late. The item is visibly underperforming, weeks of supply are creeping upward, and sell-through is trailing the category baseline. Without a systematic review cadence and clear thresholds, these signals drift until a buyer flags the item or a markdown hits the invoice.
The fix is more about having consistent habits than it is adopting a more sophisticated tool. It is a consistent habit. Generating reports on weekly read of sell-through by SKU and account, with thresholds defined in advance so action is not discretionary, is a great place to start.
What Is a Sell-Through Rate and Why Does It Matter?
Sell-through rate is units sold divided by units available, expressed as a percentage over a defined time window, typically four weeks or 13 weeks depending on the category's natural replenishment cycle. A sell-through rate of 60% means 60% of available inventory moved through to the consumer in that window.
The number matters because it sits upstream of everything else: inventory health, forecast accuracy, buyer confidence, and gross margin. A sell-through rate that trails the category baseline by more than 10 to 15 percentage points for two or more consecutive periods is usually worth investigating. It won't always indicate a demand problem. That is what the next section covers, but it is the first signal worth catching.
Setting Up an Early-Warning System for Slow Movers
The goal is a simple threshold logic a supplier can implement and review weekly, even without a dedicated analytics team. Three metrics do most of the work:
Sell-Through Rate Versus Category Baseline
Pull the sell-through rate for each SKU at each account where it is active. Compare it to the category's historical average. A SKU running 15 or more points below baseline for two consecutive four-week periods warrants a closer look.
Weeks of Supply
Divide current channel inventory by the four-week average sales rate. A weeks-of-supply figure climbing above eight to 10 weeks, when the item's typical replenishment cycle is four weeks, signals that inventory is accumulating faster than it is moving. This is often the first visible sign before sell-through rates deteriorate noticeably.
Reorder Gap
How long since the last purchase order was issued for this SKU at this account? A lengthening reorder gap means the buyer has enough inventory and is not replenishing. Combined with the weeks-of-supply signal, it suggests the item is slowing structurally, not just from a one-off timing gap.
A spreadsheet tracking these three metrics weekly, with conditional formatting to flag anything outside the threshold, will surface 80 to 90% of slow movers before they become an excess. The discipline is in the cadence more than the choice of tools.
How to Read Retailer Sell-Through Data Like an Operator
Point-of-sale (POS) data answers specific questions. Knowing what those questions are, and what POS can't tell you, is what separates a useful read from a misleading one.
POS data tells you units sold per store per week at the account level, by SKU and size. From this, you can calculate the sell-through rate, identify which stores are turning inventory and which are not, and spot velocity trends over time. What POS can't tell you on its own is whether a velocity problem is a demand problem, a distribution problem, or an execution problem. These three failure modes look similar in aggregate and require different responses.
Demand Problem vs. Distribution Problem vs. Execution Problem
A demand problem is when units per store per week are weak across all stores where the item is stocked. The item is on the shelf and visible, but consumers are not choosing it. This is a true velocity signal and warrants a keep-fix-cut analysis.
A distribution problem is when velocity looks fine where the item is stocked, but store count is the issue. The item is performing where it exists but has not been set in a meaningful portion of the chain. The fix is a conversation about distribution expansion, not a sell-through intervention.
An execution problem is the most commonly misread signal. Phantom inventory (inventory recorded in the system but not physically on the shelf), voids (planogram positions empty due to replenishment failures), and off-shelf placement all suppress sell-through in ways that look like demand failures. shelf), voids (planogram positions empty due to replenishment failures), and off-shelf placement all suppress sell-through in ways that look like demand failures.
Before drawing conclusions from a weak sell-through read, check whether the item is actually available on a shelf where the system says it should be. Void rates above 5 to 7% in any given week are a reliable sign that execution, not demand, is the problem.
The supplier who can separate these three failure modes in a buyer conversation is demonstrating a level of operational fluency that changes how the relationship works. Most vendor conversations about slow movers don't reach this granularity, and the ones that do are shorter and more productive.
The Keep-Fix-Cut Framework for SKU Rationalization
Not all slow movers should be cut. The keep-fix-cut framework forces a deliberate call on each underperformer rather than letting the tail persist by default or cutting indiscriminately.
When to Keep
Some items earn their shelf space for reasons that don't appear in velocity data. An item may anchor a size or flavor architecture: the 16-oz size moves slowly, but its presence protects the facing for the 32-oz size that moves well. Some items are seasonal and will show weak velocity outside their window; cutting them based on an annual average distorts the read. Some items earn a facing strategically because the retailer wants the breadth, even if sell-through is modest.
The test for a keep decision: does this item earn margin, protect adjacent items, or fulfill a buyer requirement that its removal would threaten? If yes, keep it and document why.
When to Fix
Fix applies when the demand signal is there, but something operational is suppressing it. This is where the distribution-versus-execution analysis from the previous section matters. An item with acceptable velocity where stocked but low distribution is a fix candidate, not a cut. An item losing velocity because of a packaging issue, a pricing mismatch at retail, or a planogram placement problem can often be recovered. Fix candidates require a specific intervention with a defined timeline. If the intervention has not moved the needle within two review cycles, the item moves to cut.
When to Cut
Cut applies to the item where the demand signal is structurally weak, the intervention window has closed, and holding inventory serves no one. This is the Coca-Cola logic scaled down. In 2020, Coca-Cola cut roughly half its brand portfolio, retiring products like Tab, which still had a devoted fanbase but represented 0.03% of sales, to concentrate resources on products with the greatest growth potential. The chief executive described the review as ruthless prioritization that began as a pandemic supply chain triage and became a permanent strategy.
The same logic applies to a supplier managing 40 SKUs. The item that accounts for 2% of revenue and requires 15% of the category management attention is a candidate for removal.
McKinsey's analysis of SKU rationalization in consumer goods identifies two lenses for the keep-fix-cut decision:
market-back: what consumers and retailers value and are willing to pay for
supply-forward: what the supply chain can efficiently produce and deliver).
Cutting an item that is complex to manufacture and moving slowly is a stronger case than cutting one that is simple to produce. Both lenses belong in the analysis, and it is worth keeping the over-cutting risk in view.
A supplier who rationalizes too aggressively can lose breadth that buyers actually require, trigger out-of-stocks on items that were seasonal rather than structurally weak, and create the impression of a shrinking line at precisely the moment the buyer is evaluating whether to give more shelf space. The antidote is documentation. Every cut decision should have a written rationale that will hold up in a buyer conversation.
Excess Inventory Starts Earlier Than You Think
The common framing of excess inventory as a fulfillment or logistics problem misses where it originates. Excess inventory is an assortment decision that was made too late, or in many cases, deferred rather than made at all. The IHL Group figures cited earlier attribute more than $400 billion in annual inventory distortion losses to vendor-side issues. The operational translation: slow movers accumulate in the channel because suppliers did not act on the signals they already had.
The early-warning system described here surfaces those signals at the SKU and account level, on a weekly cadence, with thresholds defined before the review begins. It requires three metrics, a spreadsheet, and a standing block of time to look at it. For most suppliers managing 30 to 60 active SKUs across a small number of accounts, that is roughly an hour a week.
That hour determines whether a slow mover becomes a keep-fix-cut decision in week six or a markdown dispute in week 22.
How Visibility Across Orders and Inventory Makes This Possible
The method described here depends on access to data that is current, complete, and connected across accounts. Suppliers who manage assortment well are typically the ones whose order, inventory, and sell-through data flows consistently rather than through manual retailer portal exports assembled once a month.
The method described here depends on access to data that is current, complete, and connected across accounts. Suppliers who manage assortment well are typically the ones whose order, inventory, and sell-through data flows consistently rather than through manual retailer portal exports assembled once a month.
SPS Analytics connects sell-through and inventory data across retail accounts so suppliers can monitor days of supply, surface early signals of decline, and act before slow movers become excess. For a deeper look at how data quality affects planning decisions downstream, see Forecast Accuracy and Forecast Bias.