Which Styles Can You Drop? A Retail Guide to SKU Rationalization

Put two black commuter backpacks side by side. Both carry a 15-inch laptop and both sell for $90. One has a zipper that opens almost flat. The other rolls shut, with room at the top for a change of clothes. To a buyer trying to trim the fall order, they look like an obvious pair to consolidate. To someone who rides a bike to work and changes on arrival, that closure might be the reason to buy the bag.
That difference is the commercial question behind SKU rationalization. When a style leaves the assortment, how many shoppers will take another product you carry, and how much will you earn on their purchases? A sales ranking tells you which bag moved faster. To decide which purchase order to sign, you need an estimate of what happens to the department when one disappears.
Each backpack comes in one size, so removing a style removes a single stock keeping unit, or SKU. A jacket in five sizes and three colors presents a different choice. Drop one color and five SKUs go. Drop the only extended size and you remove an option for customers who may have no substitute anywhere on the rack.
How Much Business Stays When One Bag Goes?
Imagine a group of stores that normally sells 80 roll-tops and 100 zip bags over four weeks. The buyer proposes taking the roll-top out of those stores for four weeks, while stores that keep both bags serve as the comparison. Before the trial begins, both groups should have similar customer traffic, sales trends and access to inventory. Count net units after returns for both styles, and allow the same time for returns in every period.
Stock the test stores with enough zip bags to satisfy extra demand, keep prices and promotions comparable, and record where the bags are displayed. A zip bag moved from a bottom shelf into the front window has picked up a second advantage. If the real proposal includes giving that bag the roll-top’s shelf space, go ahead and test that arrangement. Record it so the same display can be reproduced when the fall order arrives.
Suppose the comparison stores trade as expected. Based on their trend and the test stores’ earlier sales, the buyer would still expect the test stores to sell 100 zip bags and 80 roll-tops with both available. During the trial they sell 148 zip bags. The 48 above expectation give a working estimate of demand transfer. Divide 48 by the 80 roll-top sales the buyer expected and you get a 60 percent transfer rate to the zip bag.
The pair sold 148 units against a combined expectation of 180, leaving 32 units to investigate. A customer might have bought a canvas messenger in the next bay, ordered a roll-top on the website or left empty-handed. Look at other bags and at online sales in the area before calling the whole gap a loss for the retailer. An order placed online and collected in a trial store belongs in the channel accounting only once. Credit it again as a store sale and the assortment will look more resilient than it was.
The Slower Style Can Still Pay Its Way
Price the fall order under a simple set of assumptions. The sales being compared cover the same four-week run, no other style picks up measurable sales, and units remaining at period end have the same net recovery under either buy. After landed product cost and variable selling costs, each roll-top sale contributes $20 and each zip bag $25. Use the prices customers actually pay, and account for return-related costs on terms consistent with the net unit count.

The first 100 zip sales happen under either choice, so they cancel out. Keeping the roll-top earns $1,600 on its 80 sales. Dropping it earns $1,200 on the 48 additional zip bags. Suppose omitting the roll-top also eliminates a $275 style-specific setup charge for this production run: the smaller assortment then recovers $1,475 in additional contribution and avoided cost. On these assumptions, keeping both bags comes out $125 ahead for the run.
At $25 per extra zip bag, 53 transferred sales would exactly cover the $1,325 left after the setup saving. That is just over 66 percent of the roll-top’s expected buyers, and a 54th sale would tip the decision toward dropping the roll-top. The threshold gives the buyer a more productive question for the line review: is there reason to expect at least six more shoppers than in the trial to switch bags?
A crowded stockroom may carry a cost as well, although a free shelf earns nothing on its own. If another approved bag can take that space, estimate the contribution it adds after allowing for sales it takes from the zip bag. If the lease and staffing stay the same either way, removing one style does little to reduce those bills. And if the setup charge was paid last month and can’t be recovered, take the $275 saving out of the comparison.
Decide How Far The Evidence Travels
Before applying that 60 percent rate everywhere, read the stores separately. A location next to a commuter rail station might have little difficulty selling a zip bag to someone who came in for a roll-top. A store serving cyclists could lose an important part of its range. Examine several comparable weeks and the number of sales behind each pattern. At a small store, two households choosing the same bag can swing the percentage without telling the buyer much about next season.
The test also assumes the supplier can deliver the extra zip bags. If the fall allocation caps the group at 130 zip bags, moving from 100 to 130 yields only 30 additional sales, even if 48 shoppers would switch. At $25 apiece, that recovers $750 before the setup saving. Check this constraint at the stores, and for the weeks when commuters shop. A late top-up may arrive after the customers who would have switched have bought somewhere else.
For a larger range, assortment optimization software can help a merchant compare product attributes and store-level demand before choosing which pairs to investigate. Keep the final decision at the level the evidence supports. A four-week store trial can justify a narrower order for certain locations. Dropping every color online as well would remove options the trial never tested.
At the fall line review, the buyer can mark the zip bag for a deeper order in stores where shoppers switched, keep the roll-top where its closure earned its place, and leave a small test running where the difference is still a handful of sales. The two black bags may appear together on the line sheet again. This time the buyer can say which customers each one is there to serve and what it would cost to send those customers looking elsewhere.