SKU generator Readable item codes from the category, product, size and colour

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.

1. The rules

2. The items

CategoryProductSizeColour

3. The SKUs

ProductSKU

The generator runs in your browser. Nothing you type is sent anywhere.

How the generator builds a SKU

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.

Worked example: a clothes shop with six items

The shop sells one shirt in three variants, two kinds of jeans and a belt. With three letters per part and a dash:

CategoryProductSizeColourSKU
ShirtsOxford shirtMWhiteSHI-OS-M-WHI
ShirtsOxford shirtLWhiteSHI-OS-L-WHI
ShirtsOxford shirtLLight blueSHI-OS-L-LB
JeansSlim jeans32NavyJEA-SJ-32-NAV-001
JeansStraight jeans32NavyJEA-SJ-32-NAV-002
BeltsLeather belt95BrownBEL-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.

SKUs in Excel

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.

Questions

What is a SKU?

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.

How long should a SKU be?

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.

Should a SKU start with a number?

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.

Why does the generator add a number?

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.

Can I change a SKU later?

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.

Is the SKU the same as the EAN or UPC?

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.

Your SKUs, from the item list to the online store

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.

Get System 5, $99 once Start with the demo