Warehouse automation: from the ledger to real time

There is one question people ask about a warehouse more than any other: "how much do we have left?"

And there is one answer they hear more than any other: "let me check."

That check takes anything from a few minutes to a few hours. During it your salesperson is holding a client on the line, and the client is calling a competitor.

Why stock figures never match

The cause is almost always the same: data is entered later, not at the moment of movement.

Goods arrive, the storekeeper writes it in a book. That evening or the next day the records go to accounting, and someone enters them into the system. Throughout that window the balance is wrong.

Four things compound it:

Double entry. The same figure is written in a book and again in the system. Every extra point of entry raises the chance of an error.

Catalogue confusion. One item is held under two names. Two records exist, and the balance is split between them.

Units of measure. Received in tonnes, issued in kilograms. The conversion is done by hand and is not always right.

Returns and damage. These are often not recorded at all, and reappear at stocktake as a shortfall.

What automation changes

The core change is one thing: data is entered at source.

The storekeeper records it themselves as goods are received, through a phone or terminal. The accounting step disappears and the balance updates the same minute.

Everything else follows from that:

The last two are often overlooked, and they are the parts that save money.

Are barcodes necessary

The most common technical question, and the answer is not the same for everyone.

Yes: if the catalogue exceeds five hundred lines, if items look alike, or if batch and expiry control is required.

No: if you hold under a hundred lines and items are visually distinct. Selecting from a list will be faster.

The middle option: barcodes on the fifty fastest-moving lines, a list for the rest. Practical and inexpensive.

How the rollout runs

The first step is the one most often skipped, and it is the one that breaks projects. Put a confused catalogue into a system and you get a digitised version of the confusion.

Will the storekeeper resist

Yes, and it is natural. The reason is not technical.

Previously only they knew the true balance, and that gave them a certain standing. Now every movement is visible, and it feels like surveillance.

What works:

Start by making their job easier. Fast search, the system shows the storage location, documents generate themselves, no report to assemble at month end.

Test the terminal with them. Warehouse conditions differ from an office: gloves, dust, poor lighting. Large buttons and few fields are required.

Run in parallel for a month. The book is not removed on day one. That builds confidence and surfaces errors.

What to measure

Record these figures at the start of the project. Measure them again after three months.

• Stocktake variance, as a percentage and as a value
• Time spent establishing a stock figure
• How often per month you promise stock you do not actually have
• Value of goods written off for expiry
• Time to prepare the monthly warehouse report

The first metric matters most. Stocktake variance is money, and it is usually the number nobody calculates.

What it costs

For most companies the first option is enough — warehouse processes are broadly similar everywhere. A custom build is justified only for particular requirements: complex batch control, or integration with automated storage equipment.

Cleaning the catalogue is normally not in the price and stays on your side. Plan for it — it is several days of work.

In summary

Warehouse automation starts at the point of data entry, not at reporting. If the storekeeper enters it, the balance reconciles.

Practical steps:

1. Find the variance from your last stocktake — that is your baseline
2. Clean the catalogue; that is work before the system
3. Choose the terminal with the storekeeper, not in an office
4. Decide on barcodes by catalogue size, not by fashion
5. Run in parallel with the book for a month