While your product line continues to expand with new colors, new sizes, limited-edition variations, and more, your margins are getting slimmer. Warehouse space is overstocked, forecasting is a nightmare, and your operations team is wasting hours on a few moving SKUs. This is a common challenge for growing ecommerce businesses.
This is the situation for thousands of eCommerce businesses with SKU bloat: too many product variants, not enough clarity, and too much capital tied up in products that don’t belong on shelves. The solution is not indiscriminate product removal but a systematic, data-driven process known as SKU rationalization.
When done correctly, rationalizing SKUs isn’t just about saving money but also about improving your customer experience, unlocking working capital, and providing breathing room for your supply chain.
In this guide, we’ll walk you through each step: what SKU rationalization is, how to do it, which metrics are important, and how a platform like SpxCommerce’s B2C eCommerce platform can make your catalog optimization process faster and smarter.
What is SKU Rationalization?
A SKU is a unique alphanumeric code that stores each variant of your product in your catalog, such as “Blue Sneaker, Size 10” vs. “Red Sneaker, Size 10.” Each variant has its own product number (SKU), inventory level, storage cost, and revenue contribution.
SKU rationalization (also known as product rationalization or SKU optimization) is the systematic effort to analyze all SKUs within your catalog and decide whether to keep, modify, bundle, or eliminate them based on profitability, demand, and strategic fit.
Research has shown that companies can reduce SKU complexity by 33% without reducing the variety of products available to customers, improving operational efficiency while preserving customer choice.
The objective of SKU rationalization is not simply to reduce product assortment. It’s to ensure that all of your products have a positive impact on your bottom line and on your customers’ value proposition.
What is the Role of SKU in the Supply Chain?
Understanding the role of SKUs within the supply chain is essential before beginning SKU rationalization. Each SKU influences a number of functions in the supply chain:
| Supply Chain Function | SKU Impact | Risk of SKU Bloat |
|---|---|---|
| Procurement | Each SKU requires separate sourcing, supplier management, and purchase planning. | Greater sourcing complexity, higher minimum order quantity (MOQ) challenges, and increased dependence on multiple or single suppliers. |
| Warehousing | Each SKU requires dedicated bin/storage space and inventory tracking. | Picking errors, warehouse overcrowding, and higher storage costs. |
| Demand Forecasting | Individual demand forecasts are required for each SKU. | Forecasting errors, leading to overstocking or stockouts. |
| Order Fulfillment | As the number of SKUs increases, picking, packing, and order processing become more complex. | Longer order fulfillment times, increased labor costs, and reduced operational efficiency. |
| Product Catalog | Each SKU requires unique product content, images, specifications, and metadata. | Inconsistent catalog quality, higher content management effort, and growing content debt. |
As SKU numbers grow out of control (SKU proliferation), the operational load increases across all functions listed above. Maintaining a lean and responsive supply chain requires a structured SKU rationalization strategy.
Why does Product Rationalization Matter at Scale?
The bigger the catalog, the stronger the argument for rationalization. Why it’s more of a strategy than a one-time cleanup for growing eCommerce businesses:
- Lowers Inventory Carrying Costs: The costs of storing, insuring, and handling unsold products can be as high as 30% of inventory value per year. By removing low-velocity SKUs, this money can be freed up.
- Reduces Forecast Errors: Cleaner demand signals from fewer SKUs enable more precise forecasting and more intelligent reordering decisions.
- Improves Customer Experience: The “paradox of choice” exists: too many choices lead to decision fatigue. A curated catalog is better at converting.
- Accelerates Fulfillment: Streamlined storage leads to simpler warehouses, faster picking, and fewer mispicks.
- Strengthens Supplier Negotiating Power: One way to benefit from consolidating SKUs is to negotiate for more units with fewer suppliers, thereby increasing your leverage.
- Free Product & Marketing Resources: All active SKUs need content, images, campaigns, and support. Eliminating underperforming SKUs allows teams to focus on high-value products.
What is the step-by-step process for the SKU Rationalization Process?
The SKU rationalization process is well-defined and repeatable. To perform it, simply follow these steps:
1. Audit Your Product Catalogs
Export all the active SKU’s and their related information, such as sales volume, revenue, margin, days in inventory, storage cost, return rate, supplier lead time, etc. Criteria need to be determined cross-functionally (merchandising, ops, finance). Every active SKU should be included in the evaluation.
2. Define Your Rationalization Criteria
Set some thresholds in advance before you analyze, for instance: “Any SKU with less than 10 units sold in 90 days and a gross margin below 20% should be considered for discontinuance. Define the evaluation criteria collaboratively across merchandising, operations, and finance teams.
3. Classify the SKUs into Tiers
Organize SKUs into categories: Keep, Optimize, Transition, and Discontinue. Here are some great classification tools, such as ABC analysis and velocity scoring.
4. Evaluate Contextual Factors
Before acting on data alone, add context: Is this SKU bundled with others that lead to high AOV transactions? Is it seasonal? Does it fill out a category that offers conversion? Some low-velocity SKUs may still support strategic product positioning or complementary sales.
5. Implement clearance actions
Discontinued SKUs: Flash sales, bundle promotions, or wholesale clearance planning. Don’t write down inventory that may be valuable. Update your catalog at once on all sales channels.
6. Monitor and Repeat
SKU rationalization is not a project that can be completed once and for all. Review your catalog every quarter or every half-year to stay on top of demand trends and business goals. Integrate it into your product information management process.
What is the Key Framework for SKU Rationalization Analysis
The decision on which SKU to choose should never be made based on gut instinct. Reliable SKU rationalization analysis is based on existing frameworks:
1. ABC Analysis
Determine the revenue contribution of SKUs: A-items, i.e., top 70-80% of revenue (typically 10-20% of SKUs), B-items, middle tier, C-items, bottom 50-60% of revenue (high SKU count, low revenue contribution). C-items are the first rationalization targets to consider.
2. Profitability Matrix
Create a 2×2 matrix with gross margin (Y-axis) and sales velocity (X-axis), and mark the plot points with the plot SKUs. Product actions are clearly identified in the four quadrants: “protect” in the upper-right corner, “discontinue” in the lower-left corner, “optimize or promote” in the upper-left corner, and “reprice or bundle” in the lower-right corner.
3. Portfolio Overlap Analysis
Find redundancy: If you are carrying 5 or more similar SKUs that serve a similar customer need and differ only marginally, then consolidate to 2 or 3 products. This makes assortment less complicated but does not compromise coverage.
4. Lifecycle Stage Assessment
Assign each SKU to its product lifecycle phase: introduction, growth, maturity, or decline. If the SKUs are in decline and have no strategic future, they are excellent candidates for discontinuation, and if the SKUs are in growth despite low margins, they should also be investment targets.
What are the metrics to track in SKU Rationalization?
SKU rationalization with data can reduce unprofitable products, optimize inventory, boost cash flow, and maximize profits. Here are the essential eCommerce metrics you should track regularly.
1. Inventory Turnover Rate
Inventory Turnover Rate is the number of times a SKU is sold and replaced over a given time. It shows how efficiently stock is passing through the company.
A high turnover rate typically indicates high demand and good inventory management, while a low turnover rate indicates too much inventory, poor demand forecasting, or overstocking.
Formula:
Inventory Turnover Rate = Cost of Goods Sold (COGS) ÷ Average Inventory
Where:
Average Inventory = (Beginning Inventory + Ending Inventory) / 2
2. Gross Margin per SKU
Gross Margin per SKU measures the profit generated after subtracting the direct cost of producing or purchasing the product. It indicates whether a SKU generates profit before operating expenses. One of the most basic profitability measures for product evaluation.
Formula:
Gross Margin = revenues − cost of goods sold (COGS)
Gross Margin % = Gross Margin / Revenue x 100.
3. Carrying Cost per SKU
Carrying Cost is the sum of the costs of holding stock until it is sold. Such costs are frequently hidden, but can have a substantial impact on profitability, particularly for low-velocity items.
Formula:
Carrying Cost = Storage Cost + Insurance + Handling + Capital Cost + Other Holding Costs
Or,
Carrying Cost % = (Annual Carrying Cost ÷ Average Inventory Value) × 100
4. Days Inventory Outstanding (DIO)
Days Inventory Outstanding (DIO) is the mean number of days a product spends in inventory before it is sold.
The higher the DIO, the slower inventory moves and the more cash is tied up in inventory.
Formula:
DIO = (Average Inventory ÷ Cost of Goods Sold) × Number of Days
For annual calculations:
DIO = (Average Inventory ÷ Annual COGS) × 365
5. SKU Velocity
SKU Velocity refers to the speed at which a product sells within a given time frame. It is not the same as turnover, which measures the number of products sold over a particular time period and is useful for comparing products with different demand patterns.
Formula:
SKU Velocity = Units sold / Time period
6. Return Rate per SKU
Return Rate is the percentage of units sold that are returned to customers. When returns are high, profits are lost due to reverse logistics costs, customer service costs, damaged inventory, and refunds.
It helps identify quality issues, inaccurate product descriptions, and customer dissatisfaction.
Formula:
Return Rate = (Returned Units ÷ Units Sold) × 100
7. Revenue Contribution Percentage
Revenue Contribution is a way of measuring each SKU’s contribution to overall business revenue. It identifies which SKUs contribute the most revenue and which long-tail products generate limited business value. This is a frequently used metric in Pareto (80/20) analysis.
Formula:
Revenue Contribution % = (SKU Revenue/Total Revenue) x 100
8. Contribution Margin per SKU
Contribution Margin is the actual profit of a SKU once all variable costs of selling the SKU have been deducted from sales. It also includes other expenses such as fulfillment, shipping, commissions, and marketing, unlike the gross margin.
Formula:
Contribution Margin = Revenue − Total Variable Costs
Contribution Margin % = (Contribution Margin ÷ Revenue) × 100
How to optimize SKU?
In addition to the process and the numbers, there are organizational habits to be built to avoid SKU bloat in the future:
- Adopt a “launch criteria” gate: Before launching a new SKU, a business case should be created that represents the projected turns, margin, and inventory risk.
- Adopt standardized SKU naming: Consistent, structured naming (e.g., CATEGORY-COLOR-SIZE-VARIANT) can make catalog analysis much easier and less error-prone.
- Try product bundling: If you are going to remove a low-performing SKU, try bundling it. Bundles can breathe new life into slow-moving inventory and boost the AOV in tandem.
- Link SKU decisions to channel strategy: If a SKU is not selling well online, it could be doing well on a marketplace. Rationalize by channel, not at the aggregate level.
- Automate SKU performance alerts: Define alerts on your platform for when a SKU is below velocity and/or a margin floor, instead of waiting for a quarterly audit.
- Coordinate SKU changes across functions: SKU discontinuations impact marketing campaigns, customer service scripts, and supplier contracts. Inform all involved prior to implementation.
Why is SKU rationalization at scale better done with SpxCommerce?
When managing SKU rationalization via spreadsheets, disparate systems, and multiple sales channels, unnecessary catalog complexity can result. The centralized Product Information Management (PIM) system serves as a single source of truth for all SKU information, simplifying processes with SpxCommerce’s AI-powered marketplace and eCommerce development platform.
Our ProactiveAI features provide businesses with valuable insights into customer behavior, enabling them to identify high-performing products, optimize their assortment, and make informed SKU decisions with confidence.
Multi-channel sync ensures that inventory and catalog listings updated in real time, avoiding stock discrepancies and listing errors across storefronts and marketplaces. Designed for enterprise-level operations, we also support sophisticated catalog management and governance, vendor-specific SKU management, and structured taxonomies.
SpxCommerce’s integrated analytics features track sales velocity, margins, returns, and cross-sell performance, all of which help to make better-informed decisions about SKU rationalization and contribute to long-term catalog growth and efficiency.
Conclusion
SKU rationalization is not a salesman’s nightmare, and it is a salesman’s dream. A fat catalog is a hidden expense for your business: it increases costs, makes it harder to predict, slows ordering and service, and weakens the customer experience. Organizations that continuously optimize their product assortment improve forecasting accuracy, inventory utilization, and long-term profitability.
When you follow a SKU-based rationalization process, audit your catalog, use the appropriate analytical models, monitor the metrics that matter, and use the right platform, your product portfolio will be more effective and have lower friction.
Whether you want to create a new marketplace or optimize an existing eCommerce business, SpxCommerce offers the infrastructure, AI intelligence, and catalog architecture to make it a reality.
