SKU rationalization: How to optimize your product catalog for profit

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.

What is SKU rationalization?

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.

Why SKU rationalization matters for ecommerce sellers

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:

• Warehouse space occupied by slow-moving inventory
• Working capital locked in unsold products
• Increased complexity in inventory management
• Higher error rates in picking and fulfillment
• Diluted marketing spend across too many products

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

How to identify SKUs for rationalization

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:

Table 1: SKU metrics

The 80/20 analysis

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:

• Does this product attract customers who buy other items?
• Is this a seasonal product currently in its off-season?
• Would removing this SKU create gaps in my product offering?
• What would I do with the freed-up capital and warehouse space?

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.

The SKU rationalization process

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.

Step 1: Gather accurate data

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.

Step 2: Segment your catalog

Group SKUs into categories based on performance:

• Stars: High sales velocity, high margin. Invest more inventory here
• Cash cows: Steady sales, decent margin. Maintain current levels
• Question marks: New or inconsistent performers. Monitor closely
• Dogs: Low sales, low margin. Candidates for elimination

Step 3: Make rationalization decisions

For each underperforming SKU, choose an action:

• Keep: Product that serves a strategic purpose despite low individual performance
• Reduce: Lower inventory levels to free up capital
• Discount: Clear existing stock through promotions
• Eliminate: Discontinue and liquidate remaining inventory

Suggested read: Amazon FBA Accounting Spreadsheet: Real Transaction Guide

Step 4: Execute and monitor

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

Common SKU rationalization mistakes to avoid

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.

Cutting too aggressively without considering product relationships

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

Ignoring seasonality in your analysis

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.

Using incomplete cost data to calculate profitability

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.

Treating rationalization as a one-time project

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

Tools that make SKU rationalization easier

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:

• SKU-level profitability reporting across all sales channels
• True margin calculations that include fees, shipping, and returns
• Inventory turnover and velocity metrics
• Historical performance trends for seasonality analysis

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.

Frequently asked questions (FAQs)

What is an example of SKU rationalization?

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.

How to perform SKU rationalization?

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.

What is the difference between SKU and inventory?

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.