SKU Management That Works: How to Cut Errors and Save Stock

A warehouse worker scans the barcode on a parcel with a handheld scanner, part of SKU management

SKU management is giving every item you sell its own short code, built by one rule, and keeping the list clean over time. It cuts errors because a code can't be mistaken for its lookalike the way a name can. The 500 ml and the 1 litre stop being confused at the till and at the count.

This guide explains what a SKU is, how to build codes that stay readable, and what a mix-up costs. The worked example is an Accra phone accessories shop, in cedis.

What is a SKU?

A SKU, short for stock keeping unit, is a unique code you assign to each product you stock. It is usually letters and numbers, and it tells your team exactly which item they are holding.

A SKU is yours alone. Investopedia notes that retailers create SKUs for their own tracking, so the same product carries different SKUs in different shops.

Each business builds its codes from the details that matter to it: type, colour, size, brand. A small shop might label a red, medium backpack like this:

One SKU, part by part
PartCodeMeaning
Item typeBKBackpack
ColourREDRed
SizeMMedium
Final SKUBKREDM, or BK-RED-MBackpack, red, medium

The hyphens are optional but help: BK-RED-M can be read aloud over the phone without a second try.

SKU, barcode and GTIN: three different things

A SKU is your code, a GTIN is the maker's number, and a barcode is the stripes a scanner reads. The barcode can carry either one.

SKU, GTIN and barcode compared
SKUGTIN (UPC, EAN)
Who makes itYouThe brand owner, through GS1
What it looks likeLetters and numbers, any length you chooseDigits only: 12 for a UPC, 13 for an EAN-13
Same in every shop?NoYes
Best forYour own goods, loose and repacked items, variantsPackaged goods scanned as they arrive

GS1 defines the GTIN as the number a company uses to identify each item it prices, orders or invoices. What is a UPC code covers the US version in depth.

What is SKU management?

SKU management is the work of creating codes by one rule, putting them on products and labels, and retiring them cleanly. It keeps one code per item and one item per code for the life of the shop.

A shop with 30 items can manage by name, until two of them look alike. From then on, codes pay for themselves, because they let you:

  • tell similar products apart at the till, on the shelf and at the count;
  • avoid entering the same product twice under two names;
  • cut mistakes when picking, packing or counting;
  • read sales, stock and reorders product by product.

3 core benefits of SKU management

1. Fewer inventory mistakes

Products with similar names cause the most errors, and a unique code removes the guess. A scan or a typed code picks one item; a search by name offers several, and staff take the first.

For example, an Accra shop sells two USB-C chargers that look the same: 20 W at GHS 120 and 25 W at GHS 150. These are example figures, not a real shop's.

Without separate codes, a cashier who searches for "charger" sometimes picks the 20 W while the customer holds the 25 W. If that happens three times a week, the table shows the month.

For example: four weeks of one lookalike mix-up, in Ghana cedis
What happensEffect
12 sales rung up at the wrong price12 × (150 − 120) = GHS 360 undercharged
The till takes 12 of the 20 W off stockThe 20 W shelf holds 12 more than its record
Nothing takes the 25 W off stockThe 25 W shelf holds 12 fewer than its record

One mistake creates two differences at the count, equal and opposite. That pattern points to a code problem, not theft, and it is the first thing to check in an inventory discrepancy.

Two codes, CHG-20W and CHG-25W, on printed labels end it. The scan picks the right charger, so the price and the stock follow.

2. Less missing or wasted stock

Clean codes make losses visible. Inventory shrinkage from theft, damage or miscounts hides inside a line shared by two products, and shows up the day each has its own code.

You notice sooner when one item's count falls short, so you can find the cause while it is still small.

3. Smarter restocking

Every product sells at its own pace, and only a code per item shows which. With SKU tracking and inventory software, each code carries its own sales, stock and reorder level.

Set the reorder point for each SKU from its daily sales and its supplier's lead time. That means fewer stockouts on fast sellers, and less cash in slow ones.

How to create effective SKUs

A good SKU is short, built by one rule, and readable without a cheat sheet. Eight rules keep codes clean for years.

  1. Start with the family. Two or three letters for what the item is: CHG for chargers, SHT for shirts.
  2. Then what tells lookalikes apart. Size, colour, strength or capacity, always in the same order.
  3. Put a hyphen between parts. SHT-BLU-L can't be read two ways; SHBLL can.
  4. Keep it to 6 to 10 characters, hyphens aside. Long enough to be unique, short enough to type and read on a label.
  5. Skip the letters O and I. On a worn label or a phone screen they read as 0 and 1. Several SKU guides go further and drop O and 0 altogether.
  6. Never start with a zero. Excel drops zeros at the start of a number, so 0451 typed into a cell becomes 451.
  7. Leave out anything that changes. Price, supplier and shelf change; a code that contains them goes wrong the day they do.
  8. Never reuse a code. A retired product keeps its code, or old sales and new stock get mixed in the reports.

Here is the old shirt example, fixed. "BL" could mean blue or black, so the colour gets three letters.

Building a shirt SKU
AttributeBeforeAfter
CategorySHSHT
ColourBLBLU (blue) or BLK (black)
SizeLL
SKUSHBLLSHT-BLU-L

Best practices for SKU management

Use inventory software that supports SKUs

Software should refuse a code that is already taken, which a spreadsheet won't do. It should link each code to its name, unit, cost, price, stock and reorder level.

Connect SKUs to barcodes or QR codes

Scanning beats typing for speed and accuracy, so every code should be scannable. The question is whose number goes in the barcode.

Should the maker's barcode be your code?
SituationUse as the code
Packaged goods with a maker's barcode, sold as they comeThe maker's number: scan it in, no label needed
Loose, repacked or own-brand goods with no barcodeYour own code, on a printed label
One maker's barcode on items you sell at different pricesYour own code for each, on a label
Some units arrive with damaged or missing barcodesKeep the maker's number, and print labels from it

A scan takes typing out of the sale; how barcodes and QR codes reduce human error goes through the rest.

Set reorder points and key item details

Naming the SKU is half the job. Record each code's unit, cost, price and supplier, and set the stock level that triggers a reorder.

Keep your SKUs consistent

One person issues new codes, from a written rule, and nobody else. Once a quarter, sort the list by name and look for the same product under two codes.

Simple SKU management example

The old version of this article coded an electronics shop's stock like this. The codes work, but they break most of the rules above.

An electronics shop's SKUs, before and after
ProductBeforeProblemAfter
Dell laptop, 15-inchHWDLPD15"HW" is on every code and tells nobody anythingLAP-DEL-15
Dell laptop, 13-inchHWDLPD13Brand and type are run together in "DLPD"LAP-DEL-13
HP monitor, 27-inchHWMONHP27Type comes before brand here, after it above, and the O looks like a zeroMNT-HP-27
Logitech keyboard, standardHWKYBLGSTNine letters with no break to read byKBD-LGT-STD

Every new code follows family, brand, then size. A new 14-inch Dell laptop gets LAP-DEL-14 without anyone asking how.

Add the codes to your inventory system, print matching barcode labels, and the team can scan, check stock and reorder without guesswork. The codes then become the first column of your inventory list.

Tools to improve SKU management

Four tools do most of the work, and the first usually includes the other three.

  • Inventory management software. Create, search and report by SKU, from the counter or a phone.
  • Barcode generators. Turn each code into a barcode; most inventory systems have one built in.
  • Alerts and reports. Low-stock alerts and sales by SKU, so you know what sells and what sits.
  • Label printers. Print SKU codes as barcodes or QR codes on stickers, so items are ready to scan.

How to manage SKUs in ArmPOS

In ArmPOS, each product's Code Product is its SKU, and ArmPOS won't accept the same code twice. These steps set up and keep a clean code list.

  • Give each product its code. Code Product must be unique. Scan the maker's barcode into it, or type your own code. See Add your first products.
  • Give each variant its own code. A shirt in three sizes is one product with three variants, each with its own code and stock. Variant codes must be unique across all products and variants. See Products with variants.
  • Keep the symbology right. Barcode Symbology starts on Code 128, which takes letters and numbers. Leave it there for your own codes; an EAN-13 takes digits only.
  • Print labels. Products › Print Labels prints each product's name and a barcode of its code, with the price if you want it. A variant's label uses the variant's code. See Print barcode labels.
  • Start similar products from a copy. Duplicate on the product list starts a similar product from a copy; give it its own name and code. See Find, edit and update products.
  • Import codes in bulk. The product import refuses a file with a code already in use, and names the product. See Import products from a spreadsheet.
  • Sell and report by code. At the POS, a scan or an exact code and Enter puts the product in the cart. The Stock Report lists every product by code and name. See The POS screen and Stock reports.

To change many prices at once, Products › Import (Update Only) matches each row by code, so clean codes save hours there too. Shops in Ghana and everywhere else use the same steps.

Frequently asked questions

What is the difference between a SKU and a barcode?

A SKU is a code; a barcode is a way of printing a code so a scanner can read it. The barcode on your label can carry your SKU or the maker's GTIN.

Is a SKU the same as a UPC?

No. You create a SKU for your own shop, while a UPC is the maker's 12-digit number, the same in every shop that sells the item.

How long should a SKU be?

Six to ten characters, hyphens aside, is enough for most shops. Shorter codes can't carry the family and the size; longer ones are slow to type and hard to read.

Can two products share a SKU?

Never. Two items under one code become one line of wrong stock, and the count can't tell you which one is missing.

Should a SKU include the price or the supplier?

No. Prices and suppliers change, and a code that contains them is wrong the day they do. Keep them in their own fields.

Start with your lookalikes this week: give each its own code and a printed label. To have the till refuse duplicate codes for you, create a free ArmPOS account.