Many merchants often fall into a common blind spot: in an attempt to satisfy every consumer, they list every possible product variation on their website, hoping to maximize revenue. However, over time, the warehouse begins to overflow, capital gets tied up, and the number of Stock Keeping Units (SKUs) in the backend system becomes too high to count—yet revenue remains stagnant.
Are you also facing this dilemma of “seeing high revenue but seeing no cash”? The root cause of this issue lies entirely in SKU management.
What is a SKU? Why is it the Lifeblood of E-commerce Operations?
SKU (Stock Keeping Unit) is the most basic, smallest proprietary unit used in e-commerce, retail, and logistics management to identify and manage inventory items.
Many novice sellers frequently confuse SKUs with barcodes (UPC/EAN) or product items. Simply put, a “Product” is a marketing concept facing the consumer, while a “SKU” is the management language used for the warehouse and backend system.
Example: A classic “100% Cotton Solid Color T-shirt” is a single Product. However, when it is offered in 3 colors (Black, White, Grey) and 4 sizes (S, M, L, XL), it generates 3×4=12 distinct SKUs within the inventory system.
The Hidden Risks of Having Too Many or Too Few SKUs
In business strategy, the number of SKUs is a double-edged sword. Having too many or too few can cause severe internal damage to a company:
Risks of Blind SKU Expansion (SKU Proliferation):
Declining Capital Turnover: Every new color or specification means tying up capital to meet the manufacturer’s Minimum Order Quantity (MOQ).
Skyrocketing Warehousing and Logistics Costs: Storage space gets occupied by slow-moving, dead stock, causing management difficulty to increase exponentially.
Consumer Choice Paralysis: Too many similar options can easily trigger “choice paralysis” among consumers, which actually lowers conversion rates.
Risks of an Overly Sparse SKU Selection:
Missed Market Opportunities: Failing to meet core consumer preferences easily hands traffic over to competitors.
Difficulty Increasing Average Order Value (AOV): Lacking room for cross-selling or product bundling.
Therefore, the core purpose of SKU optimization is not to blindly slash products, but to find the profit-maximizing golden balance between “meeting market demand” and “controlling inventory costs.”
How to Build a Standardized SKU Coding System from Scratch
Many small and medium enterprises (SMEs) directly use randomly generated strings from systems or rely on “secret codes” that only veteran employees understand. This becomes a massive disaster when scaling up. A well-designed SKU code must possess four traits: uniqueness, readability, consistency, and scalability.
It is recommended to adopt a hierarchical logic for SKU coding: “Category Code – Series Code – Attribute Code (Color/Spec) – Size Code.” For example:
| Hierarchy | Description | Example Code | Actual Meaning |
| Top Category | Main product category (2-3 English letters) | APP | APP |
| Sub-category / Series | Product series or style (2-3 letters/numbers) | TEE | T-Shirt |
| Core Attribute | Color, material, or primary spec (3 letters) | BLK | Black |
| Secondary Attribute | Size, capacity, or weight (1-2 letters/numbers) | M | Medium） |
Following this system, the final SKU code for this medium-sized black T-shirt is: APP-TEE-BLK-M.
3 Pitfalls to Avoid in SKU Design:
Mixing similar characters: Do not use the uppercase letter “O” alongside the number “0”, or the uppercase letter “I” alongside the number “1”. This leads to inventory count errors by warehouse staff.
Including special characters: Avoid symbols like `@, , $, %, &…` or spaces. These characters frequently cause code errors or formatting issues when exporting Excel reports or integrating with ERP systems.
Treating codes as product descriptions: Do not try to cram “2026-Latest-Summer-Best-Seller-Slim-Fit” into the code. Codes require brevity and logic; leave detailed descriptions to the product title.
Execution: Data-Driven SKU Rationalization
Once your store accumulates hundreds or thousands of SKUs, you need to perform regular SKU Rationalization. This should not be based on gut feeling, but driven by scientific data models.
Step 1: Group Products Using ABC Analysis (The 80/20 Rule)
According to the 80/20 rule, roughly 80% of a company’s revenue is generated by 20% of its core SKUs. We can divide all SKUs into A, B, and C categories based on revenue contribution or sales volume:
Category A (Core Blockbusters): Accounts for about 15% to 20% of total SKUs but contributes 70% to 80% of profits. Supply must remain stable to prevent stockouts.
Category B (The Backbone): Accounts for about 30% of SKUs and contributes 15% to 20% of profits. These products perform steadily and hold growth potential; maintain normal inventory levels.
Category C (Marginal Long-Tail): Accounts for up to 50% of SKUs but contributes less than 5% of revenue. These items must be optimized or ruthlessly eliminated.
Step 2: Cross-Reference “Inventory Turnover Rate” and “Gross Profit Margin”
Looking solely at sales volume creates blind spots (e.g., items that sell fast but have razor-thin margins and net losses after logistics). We must introduce a two-dimensional matrix combining Inventory Turnover Rate and Gross Profit Margin:
Inventory Turnover Rate=Cost of Goods Sold (COGS)÷Average Inventory Value}
Using this formula, we can classify SKUs into four quadrants and apply corresponding operational strategies:
| Product Type | Data Characteristics | Operational Strategy |
| Star Products | High Turnover + High Margin | Full Support: Prioritize marketing budget and sign long-term supply agreements to prevent stockouts. |
| Volume Drivers | High Turnover + Low Margin | Structure Optimization: Attempt to raise prices or bundle them with high-margin products to increase profitability. |
| Rising Stars | Low Turnover + High Margin | Boost Marketing: Check if traffic is insufficient. Stimulate sales via influencer endorsements, homepage exposure, or flash sales. |
| Dead Stock | Low Turnover + Low Margin | Ruthless Liquidation: Stop replenishment immediately. Liquidate stock through add-ons, clearance sales, or Buy-One-Get-One (BOGO) deals to free up warehouse space. |
Digital Transformation: Ditch Excel for Automated Tools
When your monthly order volume surpasses 500 orders or you sell across multiple channels, manually updating inventory via Excel sheets is inefficient and leads to overselling disputes.
Two Core Systems Every Modern E-commerce Business Needs
ERP System (Enterprise Resource Planning): Integrates global data across finance, purchasing, sales, and inventory. When an item is sold on the front end, the ERP automatically deducts inventory and alerts purchasing teams once the “safety stock level” is breached.
WMS System (Warehouse Management System): Focuses on internal warehouse operations like bin location management, picking route optimization, and stocktaking. Paired with PDA barcode scanners, warehouse staff can locate a specific SKU in seconds, dropping error rates below 0.01%.
Core Benefits of Automation
Real-Time Multi-Channel Synchronization: Selling an item on your official website automatically updates and deducts stock on Shopee, eliminating overselling.
Accurate Reorder Point Forecasting: Based on historical big data, the system calculates the optimal lead time, preventing both tied-up capital and sudden stockouts.
Conclusion & Action Checklist: Build a Lean, High-Turnover E-commerce Operation
SKU optimization is a continuous operational discipline rather than a one-off project. The e-commerce market changes rapidly; last year’s bestseller can easily become this year’s dead stock. To keep your business agile and highly profitable, establish the following mechanisms starting today:
[ ] Quarterly Stocktakes: At the end of each quarter, hold routine SKU review meetings and strictly execute ABC analysis.
[ ] Enforce the “One-In, One-Out” Principle: When R&D or purchasing teams want to introduce a brand-new SKU, require them to evaluate and eliminate an underperforming Category C SKU to prevent system bloat.
[ ] Embrace Automation: Delegate repetitive inventory counting and stock deduction tasks to specialized software early on, preserving your valuable time for market strategy and brand building.
