More products should mean more sales, right? Not always.
Many ecommerce sellers discover that expanding their catalog shrinks their margins. Storage costs climb, slow-moving inventory ties up cash, and operational complexity multiplies with every new SKU added.
SKU rationalization solves this problem by helping you identify which products deserve shelf space and which ones quietly drain your profits.
In this guide, you will learn how to implement SKU rationalization and which metrics matter most.
The SKU rationalization process is an inventory optimization operation where you ensure that each SKU contributes effectively to your business's profitability, efficiency, and overall goals.
In practical terms, it means auditing every product you sell and making deliberate decisions about whether to keep it, expand it, reduce it, or eliminate it entirely.
This process matters because product catalogs naturally expand over time. You add seasonal items, test new variations, respond to competitor moves, and chase trends.
Without regular rationalization, you end up with hundreds of SKUs that consume resources without contributing meaningful revenue.
Webgility provides SKU-level profitability reporting that shows exactly which products generate profit after all costs are factored in. Instead of guessing which items to cut, you make decisions based on real margin data across every sales channel.
Every SKU in your catalog carries costs beyond the purchase price.
Storage fees, picking and packing labor, listing management, and capital tied up in inventory all add up. When a product sits unsold, those costs compound.
The hidden costs of SKU proliferation:
For multi-channel sellers, the challenge intensifies.
Each sales channel requires inventory allocation, listing optimization, and fee tracking. A product that performs well on Amazon might lose money on eBay after accounting for different fee structures.
Without channel-level SKU analysis, you cannot make informed rationalization decisions.
Suggested read: SKU Management: Complete Guide to Stock Keeping Units Shopify
Not every slow seller should be cut. Some products serve strategic purposes like attracting new customers or completing a product line. Effective SKU rationalization considers multiple factors before making decisions.
Key metrics to analyze:
|
Metric |
What it tells you |
|
Sales velocity |
How quickly inventory moves |
|
Gross margin |
Profit after COGS |
|
True margin |
Profit after fees, shipping, and storage |
|
Inventory turnover |
How often stock sells and replenishes |
|
Days inventory outstanding |
How long products sit before selling |
Table 1: SKU metrics
Start by identifying your top 20% of SKUs by revenue. These products likely generate 80% of your sales. Then examine the bottom 20%, the long tail of slow movers that consume disproportionate resources.
For each underperforming SKU, ask:
Webgility's reporting dashboards show performance by SKU and by channel, making it easy to spot products that underperform across all platforms vs. those that simply need repositioning.
SKU rationalization works best as a regular practice rather than a one-time project. Quarterly reviews keep your catalog lean and responsive to changing market conditions.
You cannot rationalize effectively without complete cost data. This includes purchase costs, marketplace fees, shipping expenses, storage costs, and return rates for each SKU.
Many sellers struggle here because their data lives in disconnected accounting systems.
Sales data in one platform, fees in another, inventory costs in a spreadsheet. Webgility solves this by syncing orders, fees, and inventory data into QuickBooks automatically, creating a single source of truth for SKU-level profitability analysis.
Group SKUs into categories based on performance:
For each underperforming SKU, choose an action:
Suggested read: Amazon FBA Accounting Spreadsheet: Real Transaction Guide
Implement your decisions and track the results.
Did eliminating slow movers free up capital as expected? Did reducing inventory levels cause stockouts on products you underestimated? Use these learnings to refine your next SKU rationalization cycle.
Suggested read: Shopify Multi-Location Inventory: 5 Costly Problems
Even well-intentioned SKU rationalization efforts can backfire when sellers rush the process or work with incomplete information. Understanding these common pitfalls helps you avoid costly errors.
A slow-selling accessory might seem like an obvious candidate for elimination, but that accessory could be the reason customers choose your store over competitors.
Before cutting any SKU, analyze attachment rates and consider whether the product completes a collection that drives higher-value purchases.
Removing one item can sometimes reduce sales across an entire product line.
Suggested read: Inventory Management Statistics and Trends
A winter jacket that barely moves in July is not a poor performer. It is simply out of season.
Review at least 12 months of sales data before making decisions about any product, and account for predictable demand fluctuations tied to holidays, weather, and shopping cycles.
Cutting a seasonal product during its off-season means losing revenue when demand returns.
Revenue alone tells you nothing about whether a product makes money.
A high-selling item with thin margins, frequent returns, and expensive shipping might lose money on every sale. Effective SKU rationalization requires true margin calculations that include marketplace fees, payment processing costs, shipping expenses, storage fees, and return rates.
Without this complete picture, you risk keeping money-losers and cutting hidden winners.
|
Rider Shack managed over 13,000 SKUs across online and physical stores but lacked the data visibility to make informed rationalization decisions. After implementing Webgility to automate inventory sync and transaction tracking, the team gained real-time SKU-level performance data across all channels. The result: $1,400 per month in reduced costs and 10 to 15 hours saved weekly, with time now spent on strategic inventory decisions instead of manual data entry. |
Markets shift, customer preferences evolve, and new competitors emerge constantly.
A SKU that performed well last year might be losing relevance today, while a previous underperformer could be gaining traction. Build SKU rationalization into your regular business rhythm with quarterly reviews rather than treating it as an occasional cleanup exercise.
Consistent analysis keeps your catalog aligned with current demand and prevents inventory bloat from creeping back.
Suggested read: Shopify Inventory Not Tracked: Risks, Workflows & Automation
Manual SKU analysis is possible but time-consuming, especially for sellers with hundreds or thousands of products.
The right tools automate data collection and surface insights that would take hours to compile manually.
What to look for:
Webgility provides these capabilities by connecting your sales channels to QuickBooks and tracking every transaction at the SKU level. Fees, shipping costs, and returns are automatically captured and allocated, giving you the accurate profitability data that effective SKU rationalization requires.
Schedule a demo with Webgility today.
An example of SKU rationalization is reviewing a product catalog and removing low-selling or unprofitable SKUs, such as discontinuing slow-moving color or size variations that add cost but generate little revenue, while keeping high-performing items.
SKU rationalization is performed by analyzing sales data, margins, and demand patterns to identify underperforming SKUs. Businesses then decide whether to eliminate, merge, or redesign those SKUs to reduce complexity and focus on products that drive the most value.
An SKU is a unique code used to identify a specific product and its variations, while inventory refers to the actual stock of products a business has on hand. In simple terms, SKUs track what the product is, and inventory tracks how much of it you have.