Inventory
A SKU (stock keeping unit) is the code a business gives each distinct item it stocks and sells, down to every size, colour, pack or model it counts separately. SKUs are internal. You design them, they mean something to your own team, and no two items in your system share one.
Nearly every other record hangs off the SKU: stock levels, purchase orders, price lists, sales history, margin reports. Set the structure up properly at the start and reporting stays simple. Get it wrong and every month-end report needs a spreadsheet to patch it. That is why a clean SKU system sits at the centre of good inventory management, alongside keeping dead stock, understocking and overstocking under control.
What Is a SKU?
Formally, a SKU or stock keeping unit is a unique alphanumeric code assigned to one specific product variant so that it can be tracked and managed. In practice it is the identifier that your item master, warehouse, purchasing team and point of sale all use to mean the same thing.
It is also the unit inventory is measured in. You identify products by it, check stock levels by it, and work out inventory turnover and profitability item by item with it.
ALSO READ: Why is Cycle Stock Important for Your Business?
SKU vs Barcode vs GTIN vs Serial Number vs Batch
| Identifier | Who assigns it | Identifies | Typical use |
|---|---|---|---|
| SKU | You | One item variant in your range | Stock control, ordering, reporting |
| GTIN / barcode (EAN, UPC) | The brand owner, through GS1 | One trade item, the same in every shop | Scanning at receiving and at the POS |
| Serial number | The manufacturer | One individual unit | Warranty, after-sales, high-value items |
| Batch / lot number | The manufacturer or you | A production run of the same item | Expiry, recalls, quality (batch tracking) |
Each retailer assigns SKUs its own way, so the same 120-gram tube of the same toothpaste can carry a different SKU in two different stores. The barcode on the tube is identical in both, because it carries the GTIN the brand owner registered.
One product, then, can have one GTIN and a different SKU in every shop that sells it. Your item master should hold both, with the SKU as the key and the GTIN as an attribute, so a scanner and your own codes land on the same record. There is more on scanning in barcodes and QR codes for inventory tracking.
How Are SKUs Created?
A SKU is built from letters, numbers or both, and each part says something about the product: category, brand, model, colour, size and so on. Nobody publishes a single standard. Some rules hold everywhere, though.
- Every stock keeping unit code is unique, and it is never reused.
- Keep it short. Long SKUs get misread on the shelf and mistyped at the counter.
- Leave out special characters such as /, *, #, & and spaces.
- Don’t use the letters O and I on their own. They are too easily read as 0 and 1.
- Avoid leading zeros, which spreadsheets tend to strip the moment someone opens an export.
- Make sure everyone who handles stock understands the system, not just the person who designed it.
How to build a SKU format, step by step
- List the attributes that change how you stock or sell the item. That is usually category, brand or supplier, model, and one or two variant attributes such as size and colour. Leave out anything that changes often, like price, supplier cost or location.
- Put them in order from broad to specific, so that SKUs sort sensibly in reports.
- Give each attribute a short code of fixed length. Two or three characters is usually enough. Write the code list down and keep it under change control, or sooner or later someone invents a second code for the same brand.
- Join the codes with a separator (a hyphen is the most common) and finish with a variant or sequence part.
- Test the format on your awkward items, meaning bundles, items sold by weight, and items that come in several pack sizes. If it can’t handle them, fix it now, before the whole item master is built on it.
SKU examples
| Part | Meaning | Example |
|---|---|---|
| CAT | Category | SHO (shoes) |
| BRD | Brand or own label | OWN |
| MDL | Model | RUN2 |
| CLR | Colour | BLK |
| SZ | Size | 42 |
Put together, that gives SHO-OWN-RUN2-BLK-42. Anyone in the warehouse can read it, and it sorts by category first. For products sold in sizes the size usually goes at the end, as it does here.
A distributor might use BEV-WTR-500-24 for beverages, water, 500 ml, carton of 24. A watch retailer could use WCH-M1-LTR-BLU for watch, model 1, leather strap, blue dial. In both cases the hyphens separate the parts, and store staff can decode the code at a glance.
One thing to keep out of your SKU is the supplier’s own item code. It belongs in a separate “supplier item code” field. Suppliers change their codes, and you don’t want to recode your range every time one of them does.
ALSO READ: Common Inventory Management Mistakes to Avoid
How Many SKUs Do You Really Have?
Count the product variations you actually stock, meaning every combination of model, size, colour, pack and so on. The trap is multiplying every attribute by every other one when some options only exist for some variants.
Take a watch retailer selling two models of the same watch. Each comes with four strap types: steel, rose-gold metal, two-tone steel and gold-tone metal, and leather. Only the leather strap comes in colours, six of them. Dials come in six colours.
The quick sum is 2 models × 4 strap types × 6 strap colours × 6 dials = 288. It is wrong, because it assumes every strap type comes in six colours, and the metal straps do not. The right count is 2 models × 9 strap options (3 metal straps + leather in 6 colours) × 6 dials = 108 SKUs, and that assumes every combination is actually stocked.
If some dial and strap pairings are never offered, the real number is lower again. It is worth getting right. Every SKU you create needs a reorder point, a shelf location, a stock count and a line in the margin report, and phantom SKUs that will never be stocked clutter every one of them.
SKUs and Units of Measure
A question that comes up a lot: should a carton and a single piece be two SKUs?
Usually not. If it is the same physical product and you simply buy in cartons and sell in pieces, keep one SKU and define the conversion (1 carton = 24 pieces) in the item’s units of measure. Separate SKUs make sense only when the pack is a different sellable product with its own barcode and price, such as a gift pack or a multipack sold as one unit.
Get this wrong and you get the classic symptom, stock showing 24 times too high or too low. See units of measure in inventory and product bundling.
Why SKUs Matter
Online shops, physical stores, warehouses and fulfilment centres all run on SKUs, whatever their size.
Accuracy is the first payoff. Stock levels, reorder points, cycle counts and stocktaking all work per SKU, and that is how shrinkage and data-entry errors get found before they pile up.
At the counter, a POS system uses the SKU to ring up the right price and reduce the quantity on hand. When a customer can’t find an item, staff can check availability in seconds.
SKUs also separate variants that look alike on the shelf. The same watch with different straps and dials becomes WCH-M1-LTR-BLU, WCH-M1-LTR-WHT, WCH-M1-LTR-CRM, WCH-M1-STL-BLU and WCH-M1-STL-CRM, and each one is counted, priced and reordered on its own.
And they show what makes money. Sales, margin and stock reports by SKU tell you which products earn their place and which need reordering, and they give an online shop what it needs to recommend products alongside each other for cross-selling.
ALSO READ: What is Negative Inventory and How Can you Prevent it?
Application of SKUs in a Small Shop
Picture a small grocery store with ten brands of jam. A customer asks for one of them, the owner walks over to the shelf, and it has sold out. The customer leaves without buying anything.
Now give each jam its own SKU. The owner checks the system first, sees there are none in stock, and can offer an alternative or say when it will be back. Over a few months the same data shows which brands sell fastest, so the popular ones get reordered before they run out.
How Are SKUs Used in Ecommerce?
SKUs track stock coming in and going out, and they matter even more once a third-party fulfilment provider is involved. One of the first things the provider will ask is how many SKUs you have, because that drives storage space and order complexity. Most providers keep each SKU in its own bin or shelf to speed up picking and packing.
The services they offer are built around the SKU:
- Syncing inventory automatically with your online store, matched by SKU.
- Showing stock per SKU in real time.
- Setting a reorder level for every SKU.
- Bundling several SKUs into one offer.
- Combining the same product listed on several marketplaces.
- Assembling and packing kits before they ship.
None of it works unless the same SKU means the same thing in your online store, your ERP and the warehouse. See the benefits of ecommerce and ERP integration.
SKUs in a Saudi Item Master
Keep SKU codes in Latin letters and digits, even when item descriptions are bilingual. Arabic and English names belong in the description fields. The code itself has to type, scan and sort the same way on every device and in every report.
Store the GTIN, the VAT category and the unit of measure on the item, not on the invoice line. Getting the VAT treatment right, whether standard 15%, zero-rated or exempt, starts in the item master. Set the item up correctly once and every invoice and credit note inherits it.
And use one SKU per item across all branches and warehouses, with location tracked as a separate dimension. That way stock in Riyadh and stock in Dammam add up to one company total.
For the wider setup, see inventory management fundamentals in ERP and retail ERP.
Using SKUs to Manage the Range
With a clean SKU on every item, you can start asking the questions that move margin:
- Which SKUs make up most of sales? Use ABC analysis.
- Which SKUs haven’t moved for months? Check inventory aging.
- Which SKUs earn the best return on the stock tied up in them? Work out GMROI by SKU.
Retiring slow, low-return SKUs is usually cheaper than finding more warehouse space.
Related reading
- Common Inventory Management Problems and Solutions
- What is Pipeline Inventory and Decoupling Inventory?
- What is Backordering?
- Physical Stock Verification and Its Advantages
- Ways to Improve the Procurement Process
Before You Create the Next SKU
SKUs can look like an admin detail, but they set the limit on how accurate your stock, purchasing and margin reports can be. Design the format once, write it down, and hold every new item to it.
A SKU structure is only as good as the system that enforces it. In Tranquil ERP’s inventory management, each item is defined once, with its codes, barcodes, units of measure and VAT category, and every branch, warehouse, purchase and sale uses that same record. Tranquil has served businesses in Saudi Arabia since 2014. Schedule a demo and bring a sample of your item list.
Frequently Asked Questions
What does SKU stand for?
Stock keeping unit. It is an internal code a business gives each distinct item it stocks, including every size, colour or pack variant it tracks separately. Stock levels, purchase orders, prices, and sales and margin reports are all handled per SKU, item by item, across every branch and warehouse.
Is a SKU the same as a barcode?
No. A SKU is your own internal code, structured so that it means something to your team. A barcode usually carries a GTIN (EAN or UPC), which the brand owner obtains through GS1 and which is the same in every shop. Most businesses store both on the item record, so scanning the barcode finds the right SKU.
Should every product variant have its own SKU?
Yes, if you stock, price or reorder that variant separately. A shirt in three sizes and two colours needs six SKUs if all six are stocked. A product bought in cartons and sold in pieces normally keeps one SKU, with the carton handled as a unit-of-measure conversion rather than as a separate item.
How do I create a SKU number?
Pick the attributes that matter for stocking, usually category, brand, model and a variant such as size or colour. Give each one a short fixed code, order them from broad to specific, and join them with hyphens. Test the format on bundles and multipack items before rolling it out, and write the code list down.
Can I reuse the SKU of a discontinued product?
No. Reusing a SKU mixes the old item’s sales, cost and stock history into the new one, and past reports and audits stop being reliable. Mark the old SKU inactive instead, so it stays in the history but cannot be bought or sold, and give the new product a code of its own.
How many SKUs should a business have?
There isn’t a right number. It depends on your range and how you sell. What matters is that each SKU earns its place. At least once a year, review sales velocity, stock age and margin by SKU, and retire the items that tie up cash and space without adding to sales or profit.
