A SKU (Stock Keeping Unit) is an alphanumeric code used to identify each unique variant of a product. Every combination of color, size, and material gets its own SKU. The SKU system is the foundation of e-commerce — inventory tracking, order management, reporting, and multi-channel synchronization all rely on it.
1. What Is a SKU?
- Definition: A unique code identifying a product variant, created by the seller
- Example: "Black Men's T-Shirt XL" →
TS-MEN-BLK-XL
- Purpose: Track each variant separately — stock, sales, supply, reporting
- Who creates it? The seller/brand (unlike barcodes, not universal)
- Where used? E-commerce panel, warehouse, invoicing, marketplace, ERP
2. SKU vs Barcode vs GTIN
| Feature | SKU | Barcode (EAN/UPC) | GTIN |
|---|
| Created by | Seller (internal) | GS1 organization | GS1 organization |
| Uniqueness | Company-level unique | Globally unique | Globally unique |
| Format | Alphanumeric, flexible | 13 digits (EAN) / 12 (UPC) | 8-14 digit number |
| Purpose | Internal inventory | Scanning, point of sale | Marketplace listing |
| Required | Optional (but critical) | Retail required | Amazon/Google required |
| Cost | Free | GS1 membership fee | GS1 membership fee |
| Example | TS-MEN-BLK-XL | 5901234567890 | 05901234567890 |
3. Why SKUs Matter
| Benefit | Description | Without SKU |
|---|
| Inventory tracking | See real-time stock for each variant | Don't know how many of each size remain |
| Order accuracy | Ship the right product to the right customer | Risk of wrong color/size shipment |
| Multi-channel | Same SKU across all marketplaces | Stock mismatch, overselling |
| Reporting | Best-selling variant, slow-moving stock | Can't analyze at product level |
| Warehouse | SKU-to-shelf location mapping | Packing errors, time waste |
| Procurement | SKU-based reordering | Unclear which variant to reorder |
| Returns | Identify returned items by SKU | Can't add returns back to inventory |
4. How to Create SKUs
Category — Product — Color — Size (or attribute)
Format: [CATEGORY]-[PRODUCT]-[COLOR]-[SIZE]
Example: TS-MEN-BLK-XL
TS = T-Shirt (category)
MEN = Men's (target)
BLK = Black (color)
XL = Extra Large (size)
Industry SKU Examples
| Industry | Product | SKU | Logic |
|---|
| Apparel | Men's Black T-Shirt XL | TS-MEN-BLK-XL | Category-Gender-Color-Size |
| Apparel | Women's Red Dress M | DRS-WMN-RED-M | Category-Gender-Color-Size |
| Footwear | Nike Air Max White 10 | SHO-NIKE-AM-WHT-10 | Category-Brand-Model-Color-Size |
| Beauty | Moisturizer 50ml | BTY-MOIST-50ML | Category-Type-Size |
| Electronics | iPhone 15 Pro 256GB Black | PHN-APL-15P-256-BLK | Category-Brand-Model-Capacity-Color |
| Food | Filter Coffee 250g Colombia | COF-FLT-250-COL | Category-Type-Size-Origin |
| Jewelry | 925 Silver Name Necklace | JWL-NCK-925-NAM | Category-Type-Material-Custom |
| Home | Soy Candle Lavender 200g | CND-SOY-LAV-200 | Category-Material-Scent-Size |
5. SKU Naming Rules
| Rule | Correct | Wrong |
|---|
| Keep short (8-15 chars) | TS-MEN-BLK-XL | TSHIRT-MENS-BLACK-EXTRALARGE-2026 |
| Use dashes or underscores | TS-MEN-BLK-XL | TSMENBLKXL |
| Use uppercase | TS-MEN-BLK-XL | ts-men-blk-xl |
| Avoid 0/O and 1/I confusion | Minimize ambiguous chars | O1I1OO |
| No spaces or special chars | TS-MEN-BLK | TS MEN BLK #1 |
| Consistent structure | Every product same format | Different format per product |
| Meaningful abbreviations | BLK=Black, WHT=White | A1, B2, C3 (meaningless) |
| Never reuse | Deleted SKU never used again | Assign old SKU to new product |
SKU-Based Inventory with Beekod
Multi-marketplace stock sync, SKU-based reporting, and automated stock updates for efficient operations.
Start Free Trial
6. SKU and Multi-Channel
- Single SKU system: Same SKU across all marketplaces and your own site
- Stock sync: Sale on one channel → stock updates everywhere
- Overselling prevention: SKU-based tracking → zero risk of out-of-stock sales
- Integration: SKU is the "joining key" for marketplace integrations
- Mapping: Enter your SKU in marketplace "seller SKU" field
7. SKU-Based Reporting
| Report | What You Learn |
|---|
| Best sellers | Which variant (color/size) sells most? |
| Slow movers | Which SKUs aren't selling? — discount or liquidate |
| Stock turnover | How many days until each SKU runs out? |
| Profitability | Cost vs revenue per SKU — most profitable variant |
| Return rate | Which SKU gets returned most? — quality/size issue |
| Procurement | Which SKU needs reordering when? |
| Tool | Feature | Suited For |
|---|
| Excel / Google Sheets | Simple tables, formulas, free | Starter (1-100 SKUs) |
| E-commerce platform | Shopify, Beekod, WooCommerce built-in | Mid-size (100-5,000) |
| Integration software | Multi-channel sync | Multi-marketplace |
| ERP (SAP, etc.) | Enterprise stock + accounting + supply | Large scale (5,000+) |
| WMS | Warehouse shelf + barcode + packing | High-volume operations |
9. How Many SKUs?
| Business Size | SKU Count | Management |
|---|
| Starter | 10-100 | Excel + e-commerce panel sufficient |
| Growing | 100-1,000 | Integration software needed |
| Mid-size | 1,000-10,000 | ERP + integration required |
| Enterprise | 10,000+ | ERP + WMS + automation required |
10. Common Mistakes
| Mistake | Result | Solution |
|---|
| Not using SKUs | Inventory chaos, wrong shipments | Set up SKU system from product one |
| Inconsistent format | Search and reporting becomes hard | Define standard format upfront |
| Too-long SKUs | Typos, confusion | 8-15 characters ideal |
| Reusing SKUs | Reporting confusion | Deleted SKUs never reused |
| Different SKU per channel | Stock sync breaks | Same SKU across all channels |
| No variant distinction | Can't tell which color/size sold | Each variant gets its own SKU |
Conclusion
SKU is the foundation of your e-commerce operation. Build a consistent, meaningful SKU system from your very first product. This simple habit will save you in inventory tracking, order accuracy, multi-channel management, and reporting.
