Key Takeaways:
- SKU rationalization is about cutting complexity. The goal is a leaner, more profitable catalog where every product earns its place.
- Data drives good decisions. Sales velocity, gross margin, and inventory turnover rate are the core metrics to evaluate before any SKU gets cut.
- Your point of sale is the starting point. The data you need (per-SKU sales history, margin, and on-hand quantity) should already be sitting in your POS reports.
- Treat it as an ongoing practice. A quarterly review keeps your assortment aligned with actual demand and prevents inefficiency from quietly building back up.
Having more products on your shelves does not automatically mean more money in your pocket. Carrying too many SKUs quietly drains resources: it ties up cash in slow-moving inventory, complicates forecasting, strains warehouse capacity, and makes it harder for your team to focus on what actually sells.
The Pareto Principle states that roughly 20% of a retailer’s SKUs account for 80% of its revenue. This varies widely by industry – grocery is more 50/50 and some specialty retail is even 10/90 – but serves as a good general rule of thumb for most merchants.
That leaves a long tail of products that consume shelf space, staff time, and working capital without meaningfully contributing to the bottom line. This guide covers what SKU rationalization involves, how to run the process step by step, which metrics matter most, and the mistakes that undermine even well-intentioned efforts.
What Is SKU Rationalization?
SKU rationalization is the strategic process of evaluating every product in your catalog and making a deliberate decision about whether it deserves to stay. That might mean keeping it, scaling it back, consolidating it with a similar item, or discontinuing it entirely.
It is not simply reducing inventory levels, which is about how much stock you carry. Rationalization is about which products you carry at all. You can hold lean inventory on a bloated catalog and still have the same underlying problem. The process is also not a one-time cleanup: catalogs grow naturally over time, and without a regular review, junk accumulates quietly until it becomes hard to ignore.
SKU vs. UPC: What Is the Difference?
An SKU (stock-keeping unit) is an internal identifier that a retailer assigns to a product to track it in its own system. A UPC (universal product code) is a standardized barcode used across the industry, meaning two retailers can carry the exact same product and assign it completely different SKUs.
This distinction matters for rationalization because SKU data is specific to your business. Your SKU-level sales history, margin data, and turnover rates reflect your store’s performance rather than an industry benchmark.
Signs Your Product Catalog Needs to Be Rationalized
SKU proliferation tends to creep up gradually, which is part of why it is so easy to ignore. Here are the clearest signals that it is time to take a hard look at your assortment:
- Inventory carrying costs keep rising even when sales stay flat or decline
- Stockouts on popular items happen regularly because capital is tied up in slower products
- Fulfillment errors are increasing as staff navigate a more complex catalog
- Demand forecasting feels unreliable because too many low-volume products obscure patterns
- Slow-moving inventory is occupying shelf or warehouse space
- Multiple similar SKUs are competing with each other rather than with your competitors
PRO TIP!
If your staff have informal workarounds for certain products (like moving them to the back, skipping them during cycle counts, or routinely marking them down just to move them), that is a signal. Products that are difficult to manage are often not worth managing.
How to Conduct a SKU Rationalization Analysis
SKU rationalization works best when it follows a consistent, repeatable process rather than relying on instinct or reacting to a crisis. Without active rationalization, most specialty retail catalogs grow roughly 8–12% per year in SKU count, with no equivalent growth in revenue contribution. A quarterly review keeps that from compounding.
The steps below provide a framework for methodical work:
Step 1: Audit Your Current Product Catalog
Before you can make any decisions, you need an accurate picture of what you are working with. Pull together units sold over the past 12 months, gross margin per unit, on-hand inventory levels, carrying costs, return rates, and days since last sale for every SKU in your catalog.
Your point-of-sale system should be the starting point for this. Most retail POS platforms can export per-SKU sales history, margin, and on-hand quantity in a single report, so you do not have to start from scratch in a spreadsheet. The goal is to establish a single, reliable source of truth before drawing any conclusions. Decisions made on incomplete data tend to create new problems rather than solve existing ones.
Step 2: Define Your Rationalization Criteria
Not every business should rationalize against the same benchmarks. A specialty food retailer has different margin expectations than a boutique retail store, so before you start ranking products, define what good looks like for your specific operation.
Common criteria include a minimum sales volume over a set period, a minimum gross margin threshold, a minimum inventory turnover rate, and whether a product serves a defined strategic purpose. Documenting these criteria in advance keeps the review objective and gives you a defensible rationale if suppliers or internal stakeholders push back.
Step 3: Apply ABC Analysis
ABC analysis is a straightforward way to segment your SKUs by contribution to the business. A items are your top performers, typically the 20% of SKUs generating the bulk of revenue and margin. B items are mid-tier contributors. C items are your lowest performers and the starting point for your rationalization review.
It is important to treat C items as candidates for review, not automatic cuts. A C-tier item might anchor a category, support a key customer relationship, or fill an assortment gap that would be noticed if it disappeared.
PRO TIP!
Run your ABC analysis at the category level, not just across your entire catalog. A product that looks like a C performer overall might be a genuine A performer within a niche category that matters to your customers.
Discover Advanced Analytics and Custom Reports
Speak with a product specialist and learn how KORONA POS can work for your business.
Step 4: Check for Cannibalization and Strategic Value
Before cutting any product, look at its attachment rate: how often does it appear in the same transaction as other items? A slow-selling accessory that frequently completes a higher-value purchase may be worth keeping even if it never makes your top-performers list on its own.
Cannibalization is the flip side. If several similar SKUs are splitting demand from the same pool of customers, you may be carrying more variety than the market supports. Consolidating those SKUs could simplify operations without costing you any meaningful revenue.
PRO TIP!
Check the promotional history on products before writing them off. A SKU that has never been featured in a promotion, placed prominently, or bundled with anything has not had a fair shot.
Step 5: Make the Call: Keep, Consolidate, or Cut
Once your analysis is complete, every SKU should fall into one of three categories. Keep it if it performs well or serves a clear strategic purpose. Consolidate it if it overlaps with similar SKUs and could be merged or standardized. Cut it if it fails your performance thresholds, and removing it would free up resources without materially affecting revenue or the customer experience.
For products you decide to cut, plan the exit carefully. Run down existing inventory, communicate changes to suppliers ahead of time, and where relevant, consider how to transition customers who rely on that item.
What SKU Rationalization Looks Like in Practice
The five steps above are straightforward in isolation. Here is how they play out together for a real retail operation.
Marcus runs an independent sporting goods store. He carries about 340 active SKUs across equipment, apparel, footwear, and accessories. Inventory turnover has been sluggish, and he keeps running out of his best-selling foam rollers and resistance bands while sitting on trail shoes in odd sizes that have not moved in months.
The audit (Step 1) reveals that Marcus has not sold 47 SKUs even once in the past 90 days. Another 31 have not sold in the past 180. Combined, those 78 SKUs represent roughly $8,400 in tied-up inventory that is doing nothing for his business.
Setting criteria (Step 2): Marcus establishes his thresholds before making any cuts: a minimum of 8 units sold per quarter, a gross margin floor of 38%, and an inventory turnover rate of at least 2x annually. He documents these in a shared spreadsheet so the decisions are traceable and consistent.
ABC analysis (Step 3): Across his full catalog, Marcus’s top 60 SKUs (roughly 18% of his assortment) account for 74% of revenue. His C-tier has 140 products, a surprisingly long tail. When he runs the analysis at the category level, he notices that trail footwear performs better proportionally within that category than it does across the whole catalog. He decides not to over-cut that line, even though trail shoes appear weak in the aggregate view.
The cannibalization check (Step 4): Marcus discovers he carries four SKUs of the same mid-weight hiking sock from the same manufacturer, two colorways in both regular and merino. They are splitting demand from the same customer pool without adding any meaningful variety. He also notices that a $34 locking carabiner is a C-tier SKU by revenue, but it appears in the same transaction as a climbing harness more than 60% of the time. The revenue looks weak because the purchase price is low. The attachment rate tells a different story.
The call (Step 5): Marcus cuts 29 SKUs outright, mostly low-velocity accessories and duplicate colorways across apparel. He consolidates 12 more sock and base layer options into fewer size and colorway combinations. The carabiner stays. He marks down existing inventory on the discontinued items to run it down quickly and notifies his two main suppliers of the changes before his next order cycle.
Three months later, his stockroom has measurably more open space, his reorder process is simpler, and his best-selling SKUs are stocking out less frequently — because he reinvested the freed capital into deeper inventory positions on the things that actually move.
SKU Rationalization Checklist
Work through each step before making any cuts to your catalog.
Key Metrics for SKU Rationalization
Running a rationalization review means getting comfortable with a specific set of performance indicators. Here are the ones that matter most:
- Sales velocity: Units sold per day, week, or month, showing whether a product generates consistent demand.
- Gross margin per SKU: Revenue minus cost of goods sold. Margin is more informative than revenue alone because a high-revenue SKU with thin margins may be contributing less than it appears.
- Inventory turnover rate: How many times your inventory for a given SKU sells through in a year. A low rate signals you are carrying more stock than demand justifies.
- Sell-through rate: The percentage of inventory sold within a given period, which is particularly useful for evaluating seasonal products.
- GMROI (Gross Margin Return on Inventory Investment): Profit earned for every dollar invested in inventory. A GMROI below 1.0 means you are losing money on that inventory position.
- Attachment rate: How often a SKU appears alongside other products in the same transaction, which reveals its role in the broader purchase journey.
- Return rate: High returns may signal a product quality issue or a mismatch between description and customer expectations, worth investigating before discontinuing.
PRO TIP!
If your point-of-sale system cannot surface SKU-level profitability, that visibility gap is your first problem to solve. SKU rationalization decisions are only as reliable as the data behind them. In KORONA Studio, per-product performance data is available under Evaluations > ABC Analysis and Evaluations > Commodity Group Report, and can be filtered by date range, location, or product group.
Common SKU Rationalization Mistakes to Avoid
Even retailers who approach SKU rationalization with good intentions tend to stumble on the same issues. Here is what to watch for:
- Cutting based on revenue without looking at margin. A product with strong sales can still drag down profitability if its margins are thin.
- Ignoring seasonality. A SKU that looks like a C performer in trailing 12-month data might be an A performer during a specific season. Segment your analysis by time period before drawing conclusions.
- Skipping supplier and customer communication. Discontinuing a product without notice can strain vendor relationships and frustrate loyal customers. Give people time to adjust.
- Treating rationalization as a one-time event. Catalogs grow back. Build reviews into your operational calendar rather than running one cleanup and moving on.
- Moving too fast. A phased approach, starting with your clearest underperformers, gives you time to observe the impact before making broader changes.
How Often Should You Rationalize Your SKUs?
For most retailers, a quarterly review is the right cadence. It keeps your catalog responsive to changing demand without requiring a major operational lift each time, and makes it easier to catch seasonal anomalies before they skew your annual data.
At a minimum, a full rationalization review should happen once a year, ideally before your major buying season when reorder decisions carry the most financial weight. Good trigger points to build into your calendar include end-of-season inventory reviews, any significant assortment expansion, and whenever carrying costs begin rising relative to revenue.
Wrapping Up: SKU Rationalization Is How Retailers Stay Lean and Profitable
Every product you carry has a cost: storage space, staff attention, working capital, and operational complexity. Most of those costs are invisible until they are not, and SKU rationalization is the process that makes them visible before they compound.
The retailers who manage their assortments most effectively are not the ones carrying the most products. They are the ones who carry the right products, know exactly which they are, and review that question regularly. A leaner catalog, managed well, is a genuine competitive advantage.
