Too Many SKUs? How SKU Count Affects Profitability

SKU count is the number of distinct stock keeping units a business carries. It influences inventory costs, operational complexity, sales, and ultimately profit margins.

SKU count refers to the total number of unique items your business stocks, where each SKU represents a distinct combination of product attributes such as model, size, color, or packaging. For a beginner, think of a SKU as a single line in your product catalog: more SKUs means more individual lines to buy, store, track, pick, and sell.

Why SKU count matters

At first glance, offering many SKUs can feel customer-friendly — more choice often attracts buyers. But every additional SKU brings a set of costs and operational consequences. Too many SKUs can dilute sales across items, increase inventory carrying costs, complicate forecasting, raise labor and storage expenses, and lead to higher rates of obsolescence or markdowns. Conversely, too few SKUs can limit market appeal and reduce sales opportunities. The goal is finding the right balance between assortment breadth and operational efficiency.

How SKU count affects profitability — the main pathways

• Inventory carrying costs: Each SKU ties up capital. Holding many slow-moving SKUs increases average inventory value and the percentage of working capital devoted to stock, reducing return on assets.
• Forecasting and stockouts: More SKUs usually mean less accurate forecasting for each item. Poor forecasts produce stockouts (lost sales) or overstocks (markdowns and obsolescence), both harming margin.
• Warehouse complexity and labor: A higher SKU count increases picking complexity, travel time, slotting needs, and training. Labor cost per order rises, reducing operational margins.
• Space utilization and fixed costs: Diverse SKUs with different sizes and storage requirements lead to inefficient space use and higher fixed warehousing costs per unit.
• Supplier and procurement complexity: More SKUs often mean more suppliers, smaller purchase quantities per item, higher ordering costs, and weaker negotiation leverage.
• Opportunity cost: Capital and shelf space devoted to slow SKUs could be redeployed to faster, higher-margin items or investment in marketing, improving overall returns.

Key metrics to watch

• Inventory turns: How often inventory is sold and replaced. More SKUs with low turns drag this down.
• Gross margin by SKU: Some SKUs sell more but at lower margin; others sell less but with higher margin. Total profit depends on both volume and margin.
• Sell-through and velocity: Rate at which each SKU converts into sales; helps identify slow movers.
• Stockout and fill rate: Service levels that affect customer satisfaction and repeat sales.
• Carrying cost per SKU: A percentage of cost that accounts for storage, capital, insurance, and obsolescence.

Practical examples

• A small online apparel retailer introduces dozens of color/size combinations. Many sizes/colors never sell enough to justify reorder, but they occupy warehouse space and require separate listings, increasing returns and customer confusion. Consolidating to core best-selling combinations increases turns and improves margins.
• A food distributor carrying seasonal specialty items finds unsold goods at season end that require deep discounts. Reducing SKUs to those with proven seasonal velocity and using limited-time bundles for variety reduces waste and preserves margin.

Strategies to optimize SKU count (beginner-friendly steps)

1. Collect reliable data: Use sales history, inventory levels, gross margin, and forecasting accuracy by SKU. A basic spreadsheet or your inventory management/WMS system can show velocity and turns.
2. Segment SKUs: Run an ABC analysis by revenue or margin and an XYZ analysis by demand variability. ABC tells you which SKUs drive revenue; XYZ shows predictability. Focus rationalization on low-impact, unpredictable SKUs.
3. Set business rules: Define thresholds for minimum velocity, margin contribution, or inventory turns. For example: consider discontinuing SKUs that haven’t sold in 12 months or have turns below 1 per year unless strategic reasons exist.
4. Consolidate and simplify: Combine similar SKUs, streamline packaging, or reduce product variations. Introduce configurable options (e.g., build-to-order) rather than stocking every combination.
5. Test and pilot: Remove a small set of low-performing SKUs and monitor impacts on sales, customer complaints, and returns. Use the results to refine rules.
6. Coordinate with teams: Align merchandising, sales, marketing, and customer service before retiring SKUs. Communicate reasons and provide alternative recommendations for customers.
7. Automate replenishment: Use inventory management or WMS rules for reorder points that account for SKU velocity — automation scales better than manual tracking as SKU count grows.

Best practices

• Regularly review SKU performance (quarterly or biannually) rather than waiting for a crisis.
• Keep a clear product lifecycle process: introduce, evaluate, and retire SKUs with documented criteria and approvals.
• Use data to drive decisions, not anecdotes. Sales or marketing intuition is valuable but should be validated by numbers.
• Consider customer impact: if a SKU is strategic for a key account, document the business case for retaining it despite low velocity.
• Work on upstream processes like supplier lead time reduction and forecasting improvement to make it feasible to carry fewer SKUs without raising stockouts.

Common mistakes to avoid

• Cutting SKUs without customer insights: Removing a niche SKU that drives small but profitable, repeat business can harm relationships.
• Relying only on revenue: High revenue SKUs with thin margins or promotions can look important but erode profit.
• Ignoring hidden costs: Administrative, listing, and return processing costs tied to SKUs are often overlooked when assessing SKU profitability.
• One-time snapshot decisions: Making rationalization choices based on a short sales window (e.g., a holiday spike) can misclassify seasonality.

Quick checklist to get started

• Export SKU sales and inventory data for the last 12–24 months.
• Calculate turns, gross margin contribution, and sell-through for each SKU.
• Classify SKUs into priority groups (core, discretionary, candidate for discontinuation).
• Create a retirement plan with timelines, markdown rules, and customer communication templates.
• Implement monitoring for unintended consequences (e.g., increased returns or lost sales from key segments).

Optimizing SKU count is not about minimizing choices for customers; it's about maximizing profitable choices and operational efficiency. A thoughtful approach — using data, clear rules, and cross-functional input — can reduce costs, free capital, simplify operations, and often improve customer experience by focusing on items that matter most. Start small, measure impact, and iterate.