Item Codes and Names: Why One Product Appears Three Times

One product in one warehouse can carry three names: "Sunflower oil 5 L" in the accounting program, a Russian phrase printed on the carton label, and an Uzbek form on the supplier's invoice. If the count is recorded under one name while the books stay under another, the report shows one line with a surplus and another with a shortage, and both are false. Then a great deal of time goes into hunting for goods that were never missing, and the reader loses trust in the whole report. The cheapest cure is a mapping table built before the count begins.

Where the duplication comes from

• Spelling and transliteration: the same name is written in Latin or Cyrillic letters, in Uzbek, Russian or English, and spelling can differ even within one language from one employee to the next.
• Several codes: an item has a code in the accounting system, a supplier code, a code the storekeeper uses and a barcode on the pack, and these may not agree with one another.
• Different units: the item is bought by the carton, sold by the piece and sometimes recorded by the kilogram.
• Pack sizes: a 0.5 L bottle and a 1 L bottle may carry almost the same name and differ in price and in balance.
• Names that changed over time: an item renamed two years ago may keep its old code in some ledgers and documents.

The mapping table before the count

An ordinary spreadsheet is enough. Its columns are: the master code you adopt, the name in the books, the name as it appears on the shelf or label, the supplier code, the barcode, the base unit, the number of units in a pack, and a notes column. To build it:

1. Export the item list from the accounting system or your spreadsheet exactly as it is, without changing any name.
2. Walk the warehouse with the list in hand and photograph sample labels from each group of items.
3. Match each name on the shelf to a line in the list and write the master code beside it.
4. Ask the warehouse staff for the everyday names; they know the nickname everybody uses for an item written differently on paper.
5. Put items with no match on an "unmatched" list, with a photograph of each.
6. Show the table to the warehouse manager and the accountant, then freeze a dated copy before count day.

Give each item exactly one master code, even if five names gather under it. The aim is for the ledger and the shelf to meet at a single key, not for people to agree on the prettiest name.

An example (conditional figures)

The books show 400 pieces under the name "Oil 5 L" and 120 pieces under a Russian name for the same product. The counting team finds 515 pieces, all recorded under the first name. Without a mapping table the first line shows a surplus of 115 pieces and the second a shortage of 120, so it looks as if goods "moved" from one line to the other, and an investigation into a theft that never happened may begin. With the table the two lines merge under one code: expected 520, counted 515, leaving a real difference of just 5 pieces, small enough to trace without much effort.

Rules for the count sheet

• Write the item name as it appears on the label; do not translate or abbreviate it during the count.
• Add the master code after the count, not during it, so the counter is not led by guesswork.
• Write the unit beside every number.
• Never merge an unknown item by guessing; photograph it, list it separately and ask about it.

After the count: keep the table alive

The table is useful beyond count day. Every new item entering the warehouse needs a line in it before it is received, and every renamed item gets its new name added without deleting the old one. If one person is made responsible for the table, and the latest copy is kept by you and not only by the operator, each later count becomes faster and less argumentative.

In short

An item name is not a cosmetic detail; it is the bridge between what is on the shelf and what is in the ledger. WarehouseDepo helps you build this mapping table, then matches balances to the books and explains each difference by item and batch.