Shop and website stock out of sync: why it happens

A customer orders the last one, you walk to the shelf and it is not there. It sold in the shop yesterday. Now you are ringing to apologise and cancelling an order that has already been paid for.

This happens to firms whose stock is supposedly linked. The reason is annoyingly simple: the gap does not come from the transfer of data, it appears before that.

Two systems, two opinions about one item

The till knows what went through it. The website knows what customers ordered. Each keeps its own number, and syncing just passes messages back and forth. While everything happens slowly and in order, the numbers agree. As soon as two movements land in the same minute, one of them overwrites the other.

That is why reliability does not come from syncing more often. It comes from one place holding the real number.

Where the gap is born

Nearly always in one of these places:

• A shop sale nobody took off stock. Handed over without a receipt, sold to a regular, taken into a fitting job.
• A reserved item on an unfinished order. The website holds it, the till knows nothing about it.
• Returns. The goods come back physically before the number moves.
• Goods in transit. Booked in before they arrive, or the other way round.
• Servicing and installation. A part goes off the shelf into a job and nobody writes it off.
• A manual fix after a stock count. Somebody types a new number because "it was wrong", which also hides the cause.

It is worth logging for a week where each gap came from. It is almost always two or three places, not ten.

What it costs

A cancelled order costs more than the margin. It costs the time spent explaining, it costs a review, and it costs a customer who tries somebody else next time. On higher value goods, a handful of those a month outweighs the cost of doing stock properly.

What you can do straight away

Even without new software:

• One place decides the number. Pick it, even if it is the till, and have everything else read from it.
• Every movement is recorded when it happens, including parts taken into a job.
• A reservation counts as a movement, not just a dispatch.
• A small weekly count on your fastest moving lines, not the whole warehouse.

That takes minutes a day and shrinks the gaps. It does not remove the cause, but it shows you exactly where the cause is.

When one database is the answer

If you sell in a shop and online, and you also service or install, the safest route is not to have two stock figures at all. One database that both the website and the till read from has nothing to drift. An item is free, reserved or gone, and staff and customers see the same number.

That is how a bike shop we built a site and a panel for runs it: one stock figure for the shelf, the online shop and the workshop jobs. When a part goes into a repair, it leaves the shop on its own. You can click through the panel demo.

How we approach it

Stock makes a good first stage, because it shows results immediately and gets used from day one. It carries a fixed price you know before we begin, and after it you decide whether we continue.

Prices and scope are public. If you want to know whether it pays off in your case, book a free call.