Selling & Business Models
How should I create and use product SKUs in a small online store?
The short answer
Create one unique SKU for every inventory-tracked product or variant, then use that same internal code across purchasing, storage, listings, orders, returns, and accounting. A good SKU is short enough to type, stable over time, and meaningful enough to distinguish similar items.
Use a simple structure
A practical SKU can contain three or four parts:
category – model – color – size
For example:
- TEE-BOOK-NVY-M.
- MUG-GARD-WHT-11.
- KIT-CAND-START.
Use abbreviations from a controlled list. Do not let one person write “BLK,” another “BLACK,” and a third “BK.” Keep the code under a manageable length and avoid spaces, punctuation that software may interpret, and personally identifying customer information.
Give every sellable variant its own code
A navy medium shirt and navy large shirt need separate SKUs because stock and fulfillment differ. A bundle also needs a bundle SKU, plus a record of the component quantities it consumes. If you sell the same physical item on Etsy, Shopify, and at markets, map all channel listing IDs to one master SKU.
WooCommerce's inventory documentation describes an SKU as a unique product or variation identifier used to track inventory. Its smart inventory documentation also distinguishes the store SKU from a supplier SKU, which is helpful when vendors use their own codes.
Do not encode facts that change often
Avoid price, storage bin, supplier, or year in the main SKU unless permanence is intentional. A mug may move from shelf A2 to B7 without becoming a new product. Keep changing details in separate fields.
Never reuse a retired SKU for a different product. Old orders, refunds, and reports must continue to mean the same thing. Mark the item inactive and create a new SKU when material, dimensions, included parts, or another fulfillment-critical specification changes.
Maintain one master catalog
Your SKU sheet should include the same core fields your store platform uses. WooCommerce's product-management documentation explains how products and variations are managed in its core system, while Shopify's inventory documentation covers its stock-tracking workflows.
Include:
- SKU and plain-language product name.
- variant details.
- barcode or marketplace IDs.
- supplier and supplier SKU.
- landed cost and date updated.
- storage location.
- reorder point.
- active channels.
- status: active, paused, discontinued, or replaced.
Run a duplicate check before issuing a new code. Print the SKU on shelf labels, pick lists, packing slips, and return notes where useful. Train yourself to investigate by SKU rather than “the blue one.”
Test with one order and one return
Place a test order for two similar variants. Confirm that the storefront, payment, pick list, shipping label, inventory reduction, customer email, and bookkeeping all point to the correct SKU. Then process a return and confirm stock goes back to the right item.
The test is complete when another person could pick the correct product without seeing your product photo.
WAHMN's Business Blueprint Launch System can help you build this kind of dependable operating foundation as the store goes live.
Sources and further reading
- WooCommerce: Smart Inventory Management Documentation
- WooCommerce: Managing Products
- Shopify Help: Inventory Management
A free next step
You don't have to build this alone
Bring your questions, share what you're working on, and meet other women building businesses from home. It is free to join.