A t-shirt in three colours and four sizes is one product on your website but twelve different things in your stockroom. Each of those twelve needs its own count, its own reorder decision and its own line in a sales report, and a SKU is what gives it one. SKUs look like a clerical detail when a catalogue has twenty items. By the time it has two thousand, the quality of your SKUs decides whether stock counts, order imports and profit reports can be trusted, or whether someone has to fix them by hand every week. Below: what a SKU is, how it differs from a barcode and how to design SKUs well.
What is SKU
A SKU (stock keeping unit) is a code a business assigns to each distinct product variant it stocks and sells, such as one shirt in one colour and one size.
- Full name: stock keeping unit.
- Who sets it: the business itself. It is internal, not a global standard.
- Why it matters: it is the key that ties inventory, orders and reports together.
SKU vs barcode
Three identifiers often get mixed up:
- SKU. Internal, defined by you, one per sellable variant. Readable by your team.
- Barcode (UPC, EAN, GTIN). A globally unique number, usually issued through GS1 and printed as scannable bars. The same item has the same barcode in every shop that sells it.
- Platform product ID. The number WooCommerce or Shopify assigns internally. It changes if you recreate the product or move to another platform, so it is a poor key for reporting.
A product can carry all three. The SKU is the one you control.
How to design a SKU scheme
Good SKUs follow a fixed pattern of short segments, from general to specific.
Example: clothing SKUs
| Product | SKU |
|---|---|
| T-shirt, blue, medium | TSH-BLU-M |
| T-shirt, blue, large | TSH-BLU-L |
| Hoodie, black, small | HOD-BLK-S |
Practical rules
- Keep it short, eight to twelve characters, using letters, digits and hyphens only.
- Avoid characters that are easy to confuse, such as O and 0 or I and 1.
- Do not start with a zero, because spreadsheets often strip leading zeros.
- Do not encode things that change, such as price or supplier.
- Use upper case consistently.
SKUs for an online store
- Stock and reports: every stock figure, reorder point and sales report is keyed on SKU.
- Profit: when costs are tracked per SKU, so is profit. The landed cost of an imported shipment has to be spread across the exact variants it contained.
- Several channels: when the same product sells through more than one store or channel, one shared SKU per variant is what allows orders from different sources to be matched to the same item.
Common mistakes
- Reusing SKUs. Giving a discontinued SKU to a new product merges two histories into one.
- One SKU for several variants. If blue and black share a code, you cannot tell which colour is running out.
- Blank SKUs. Variants without a SKU cannot be matched reliably by any system that imports your orders.
- Inconsistent formatting. "tsh-blu-m", "TSH-BLU-M" and "TSH-BLU-M " with a trailing space look the same to people but not always to software.
- Renaming SKUs on live products. Anything keyed to the old code, from reports to supplier orders, silently stops matching.
Related concepts
- Inventory management: SKUs underpin it, along with reorder points and stock valuation methods such as FIFO.
- Variants: the product options (size, colour) that each get their own SKU.
SKUs in StoreChart
- Order matching: when an order arrives from a connected WooCommerce or Shopify store, StoreChart matches each line item to a product in that store by SKU, after trimming spaces and converting it to upper case.
- New SKU: if no product has that SKU, a new product is created.
- No SKU: a line with no SKU at all gets a generated fallback code.
That makes consistent, unique SKUs in your store platform the difference between clean inventory in StoreChart and a catalogue full of accidental duplicates.
Frequently asked questions
Can two different products share the same SKU?
No, a SKU must be unique per distinct sellable variant. Two products sharing a SKU will corrupt inventory counts and reporting, since the system can no longer tell which physical item actually sold or shipped.
Is a SKU the same as a barcode?
No. A barcode is a standardized, often supplier- or industry-assigned code meant for scanning at checkout, while a SKU is an internal code a business defines itself for its own inventory and reporting needs, the same product can carry both at once.
What happens to a SKU when a product is discontinued?
The SKU should stay assigned to that exact historical variant rather than being reused for a new product, so past orders and inventory reports remain accurate. A replacement product should get its own new SKU even if it looks similar.
