Stock Control Without Software: A Simple Weekly Count

Most small shops do not have a stock system, and most of them do not need one. What they need is to stop discovering on a Saturday morning that they are out of the one thing everyone wants, and to stop finding six boxes of something nobody has asked for since spring. Both problems are solved by the same fifteen minutes: a short, honest count on the same day every week. Not a full inventory. Not everything you own. A deliberately small list, counted often enough that the numbers start telling you something.

Why weekly is the right frequency

Monthly counting is too slow to act on. If you run out of a fast mover on the 8th, a count on the 30th tells you nothing you can use. Daily counting is too much work and people start writing down yesterday's number without looking. Weekly sits in the useful middle: it matches how most suppliers deliver, it matches how customers shop, and it is short enough that you can do it without closing. It also gives you four data points a month, which is enough to see a trend without being enough to drown in.

Build your count list: the twenty items that matter

• Anything you sell nearly every day. These are the items where running out costs you a sale on the spot.
• Anything expensive per unit. A 40 euro item that quietly disappears hurts as much as forty 1 euro items.
• Anything that spoils. Fresh stock decides your margin more than anything else on the shelf.
• Anything you have run out of at least twice this year. Your own frustration is a good data source.
• Anything a supplier makes you order in large minimums, so you can see when a full case is genuinely needed.
• Nothing else. Slow-moving, cheap, shelf-stable items can be checked once a quarter by eye.

The count itself: same day, same time, same order

Pick a quiet slot, for example Tuesday morning before opening or after the lunch rush, and never move it. Walk the shop in a fixed physical route so you always count the same shelves in the same sequence. Count the sellable units, including what is in the back, and write the number next to the item name. Do not tidy, do not price-check, do not do anything else while counting, because interruptions are where errors enter. Fifteen minutes for twenty items is normal. If it takes forty, your list is too long.

The number that makes it worth doing: weekly usage

A count on its own is a photograph. Two counts plus your deliveries give you usage, which is the number that changes decisions. The arithmetic is simple: last week's count, plus anything you received, minus this week's count, equals what left the shelf. If you had 24 units, took in 36, and now have 19, then 41 units left the shelf in seven days. That single figure tells you how much to order, when to reorder, and whether an item is speeding up or dying, and you got it without a barcode scanner.

What the numbers start telling you after a month

• Which items to reorder every week without thinking, because usage is flat and predictable.
• Which items you are consistently over-ordering, so your money is sitting on a shelf instead of in the bank.
• Which items are dying quietly, dropping ten to fifteen percent a week, long before you would have noticed by feel.
• How many days of cover you hold: if you use 41 a week and hold 60, you have about ten days, which tells you whether a supplier delay will hurt.
• Where the gap between what should have sold and what did sell is too wide to explain by sales alone.

Shrinkage: measure it instead of arguing about it

Every shop loses stock. Breakage, waste, staff consumption, giveaways to regulars, theft, miscounts at delivery. What separates a controlled shop from an anxious one is that the controlled one knows the size of the number. Compare units that left the shelf against units you actually sold. If 41 left and 37 were sold, four are unaccounted for. At 3.50 euros each that is 14 euros a week, roughly 700 euros a year, on one product line. Now it is a problem with a price tag, which means you can decide whether it is worth fixing. Track it, do not accuse anyone on the strength of one week.

Order from the count, not from the shelf gap

The instinctive method is to look at the shelf, see a hole, and order. That reorders whatever is visibly empty and ignores whatever is about to be. Instead, order from usage and cover. Set a simple rule per item: hold two weeks of usage, order back up to that level every week. For the example above, 41 a week means a target of 82; with 19 on hand you order 63, rounded to whatever case size your supplier insists on. It takes ten minutes with the count sheet in front of you and it removes almost all of the guessing.

The four mistakes that kill the habit

First, counting everything: the list grows, the count takes an hour, and by week three nobody does it. Second, moving the day: a count on Tuesday one week and Friday the next produces usage figures that are not comparable. Third, counting but never acting, which turns a useful routine into a chore with no payoff. Fourth, letting one person own it entirely, so the whole system stops when they take holiday. Keep the list short, the day fixed, the ordering rule written down, and make sure two people know how to do it.