Signs your webshop has outgrown spreadsheets

You have outgrown spreadsheets when the same mistakes keep coming back: wrong items in parcels, products sold that are not on the shelf, and hours each day spent copying orders between screens. Each one is a sign that the warehouse needs a system that checks the work, not more care from the people doing it.

Customers find your packing mistakes

If the wrong colour, the wrong size or one item too few reaches the customer more than now and then, your packing relies on people reading labels by eye. People are good at many things, but telling two similar product codes apart at the end of a long shift is not one of them.

Every one of these mistakes costs twice: the return shipping and the replacement, plus the time to answer the customer. A scan at picking and another at packing stops most of them before the parcel is closed.

You sell what you do not have

Overselling happens when stock is updated by hand or in batches. You sell the last unit on your shop, and before anyone changes the figure on the marketplace, someone buys it there too. Then you cancel an order and apologise, and on a marketplace a cancellation can count against you as a seller.

The fix is not more vigilance. It is one stock figure that every channel reads from, reduced the moment an order arrives.

Nobody trusts the stock figure

Watch what people do when a customer asks whether an item is in stock. If they walk to the shelf to look, the number on the screen has stopped meaning anything.

Stock drifts for ordinary reasons: a delivery booked in without counting, a damaged item thrown away without a note, a return put back on the wrong shelf. Without a record of each change and who made it, nobody can find where the drift came from, so it keeps happening.

Hours go into copying, not shipping

Add up the time spent each day exporting orders, printing lists, typing addresses into courier websites and copying tracking numbers back. Say it is an hour and a half a day for one person. That is the best part of a working day each week spent moving data, not parcels, and every copy is a chance to mistype.

The same goes for purchasing. If reordering means opening last month's sales in one file and the supplier's price list in another, it gets done late, or by feel, and the best seller runs out again.

Why more care does not fix it

The usual first answer is a stricter routine: double-check every parcel, update stock twice a day, colour-code the spreadsheet. It helps for a few weeks. Then volume grows, someone is on holiday, and the old mistakes return, because the routine depends on people remembering every step.

A system does not remember better than people; it simply refuses to let a step be skipped. The scanner will not accept the wrong product, and the stock figure changes because the order arrived, not because someone remembered to type it.

A short checklist

If three or more of these are true, it is worth looking at a warehouse system:

  • Only one or two people know where things are kept.
  • A new starter needs weeks before they can pick without help.
  • You sell on more than one shop or marketplace from the same shelves.
  • You count stock once a year, and the count never matches.
  • Reordering is done from memory or a spreadsheet nobody else understands.
  • You cannot say which person packed a parcel that went wrong.

Related guides

Glossary
What is a WMS? One stock, many channels Reduce picking errors

See it with your own orders.

In the demo we connect your channels and walk you through these steps on the real screens, with your own products.

Book a demo Try it free