A clothes shop has the same shirt in three sizes and two colours, and the till shows six lines called "Oxford shirt". Give each one a SKU that says what it is. Type the items below; the generator builds the codes and marks the ones that clash.
| Category | Product | Size | Colour |
|---|
| Product | SKU |
|---|
The generator runs in your browser. Nothing you type is sent anywhere.
Accents and signs drop out (Crème → CRE), and every letter is a capital, so the same item always gets the same code. The rule is plain enough that a new employee can read a SKU and say what is on the shelf.
The shop sells one shirt in three variants, two kinds of jeans and a belt. With three letters per part and a dash:
| Category | Product | Size | Colour | SKU |
|---|---|---|---|---|
| Shirts | Oxford shirt | M | White | SHI-OS-M-WHI |
| Shirts | Oxford shirt | L | White | SHI-OS-L-WHI |
| Shirts | Oxford shirt | L | Light blue | SHI-OS-L-LB |
| Jeans | Slim jeans | 32 | Navy | JEA-SJ-32-NAV-001 |
| Jeans | Straight jeans | 32 | Navy | JEA-SJ-32-NAV-002 |
| Belts | Leather belt | 95 | Brown | BEL-LB-95-BRO |
The three shirts differ only in size and colour, and the SKU shows exactly that. The two jeans clash: both give JEA-SJ-32-NAV. The running number keeps them apart. If you would rather read the difference, type "Straight leg jeans" instead, and the code becomes JEA-SLJ-32-NAV.
A good SKU is boring. It never changes, it never starts with a 0, and two items never share it.
Category in A, product in B, size in C, colour in D. For one-word fields, this gives the code in E:
=UPPER(LEFT(A2,3))&"-"&UPPER(LEFT(B2,3))&"-"&C2&"-"&UPPER(LEFT(D2,3))
To find a clash, put =COUNTIF(E:E,E2)>1 in F and filter for TRUE. When the codes are ready, print
them as Code 128 labels with the barcode generator.
A stock keeping unit: your own code for one item that you stock and sell. Each size and each colour that you count apart gets its own SKU. It is not the barcode: the barcode is printed for the scanner, the SKU is read by people.
Short enough to read on a phone screen and to type: 8 to 14 characters is common. Three letters per part and a dash between the parts is a good start.
Better not. A code that starts with 0 loses the 0 in a spreadsheet, and a long number can turn into 1.2E+11. Start with a letter, as the rules above do.
Two items can give the same code: Slim jeans and Straight jeans both start with S and J. The running number keeps them apart. You can also change a word, for example "Straight leg jeans", to get a different code.
Avoid it. Orders, price lists and online stores find the item by its SKU. Give the new code to a new item, and stop selling the old one.
No. The EAN or UPC comes from the manufacturer or GS1 and is the same in every shop. The SKU is yours. An item often has both: the SKU in your lists, the EAN on the label for the scanner. The barcode generator prints either one.
In Golden Inventory Web, the item code is the SKU. The CSV import of an item list keeps your codes, and the first pull from a Shopify or WooCommerce store links each store product to the item with the same SKU.
Rather keep it on your own Windows PC? Golden Inventory System 5 does stock, purchase orders and a till for $99, paid once.