What this generator does
A SKU (stock keeping unit) is your own code for one product variant. A T-shirt in black, size small, has a different SKU from the same shirt in white, size large, because you count and reorder them separately.
- Category code. The broadest part, such as TEE for T-shirts or MUG for mugs.
- Style numbers. A number for each design. Set the first number, how many styles, and how many digits to pad to, so 1 becomes 001.
- Colors and sizes. Short codes separated by commas. Leave either blank if your product doesn't vary that way.
- Separator. A hyphen makes SKUs easier to read aloud and type. Choose none if your system prefers plain codes.
The generator makes one SKU for every combination, broadest part first. It runs in your browser and nothing you type is sent anywhere.
How the SKUs are built
| Part | Example | Rule |
|---|---|---|
| Category | TEE | Broadest group, always first |
| Style number | 101 | Padded to the same number of digits |
| Color | BLK | Short code, same length where you can |
| Size | XL | Last, because it changes most often |
| Number of SKUs | 24 | styles × colors × sizes |
Codes are turned into capitals, and spaces, slashes and other symbols are removed. Only letters and digits are kept, joined by the separator you choose.
Worked example
A brand sells 2 T-shirt designs, style 101 and style 102, in black (BLK), white (WHT) and navy (NVY), each in sizes S, M, L and XL.
- 2 styles × 3 colors × 4 sizes = 24 SKUs
- The first is TEE-101-BLK-S and the last is TEE-102-NVY-XL
- The longest is TEE-101-BLK-XL at 14 characters, hyphens included
Every SKU has its parts in the same order, so a buyer or packer can read the style, color and size straight from the code.
SKU vs barcode
A SKU is made up by your business for your own stock. Another seller can give the same product a completely different SKU. A barcode number such as a UPC or EAN is different. It comes from GS1 and stays the same whoever sells the product. You can make as many SKUs as you like, but barcode numbers have to be licensed. When you need one, the EAN-13 barcode generator adds the check digit and draws it.
Tips for SKUs that last
- Start with a letter. Spreadsheets often drop leading zeros, so 012345 can turn into 12345. The generator warns you if a SKU starts with a digit.
- Avoid O and I. They are easy to misread as 0 and 1. Pick codes such as NVY or BLU rather than ones that need them, where you can.
- Keep it short. Many guides suggest about 8 to 12 characters. Long codes are slow to type and easy to get wrong.
- Keep the order fixed. Use the same parts in the same order for every product, even when you add a new category later.
- Don't reuse old SKUs. When a product is discontinued, retire its SKU so your sales history stays clear.
- Don't copy your supplier's code. Their numbers can change, and two suppliers can use the same code for different items. Keep theirs in a separate column.
- Watch for clashes without a separator. Without one, style 1 in color 01 and style 10 in color 1 both become 101. The generator flags duplicates like this.
Next steps
With SKUs in place you can count stock by variant. Work out when to reorder each one with the reorder point calculator and see how fast it sells with the inventory turnover calculator. Then paste the CSV into your product list and publish it as a price list or a line sheet buyers can order from by SKU. If you keep your list in a spreadsheet, read how to make a price list in Excel.