Blixwerk

The Order You Had to Cancel: Running Out of Stock Unnoticed

2026-10-12

The notification arrives at 8:12 on a Saturday morning, while you are standing in the queue at the bakery.

New order: 3 × Lavender & Oat Soap.

You smile. Then you stop smiling.

You open the shelf in your head. The box in the spare room. The gap you noticed on Wednesday and decided to deal with "later." You are fairly sure there are two left. Maybe one. Possibly none, because you sold a few at the market last weekend and you cannot quite remember writing that down.

The woman in front of you orders two rye loaves. You don't hear a word of it.

The arithmetic you do with your thumb

You stand there doing sums with your thumb on the phone screen. Three ordered. Two, maybe, at home. The supplier takes nine days to deliver, and that is when they answer emails at all.

It is a small thing. It is one order, about the price of a decent lunch. But it never feels small in the moment, because it isn't really about the soap.

It is the message you now have to write. So sorry, there's been a mix-up with our stock. The polite wording you will rewrite three times. The refund. The quiet hope that the customer is the understanding kind and not the kind who leaves a review.

And under that, the thought that follows you home with your bread: a real business would have known.

The cost that never shows up in a list

Nobody talks about this part of running something small. The money lost is rarely dramatic. It is the sale you couldn't make, the repeat customer who quietly went elsewhere, the rush order to a supplier at a worse price because you left it too late.

But the larger cost is the low hum of not knowing.

You check the spare room "just to be sure" on a Sunday. You count candles while a film plays. You wake at 5 a.m. with the sudden clear thought that you are down to your last box of mailers. Your stock lives partly in a notebook, partly in a spreadsheet you last updated in August, and partly in the part of your memory that is also trying to remember a dentist appointment.

It works, until the one morning it doesn't.

The part where you go home and look

Back in the kitchen, with the bread still in its paper bag, you go to the spare room and count properly.

One bar of lavender soap. One.

You write the message. It is kind and honest and slightly too long. You offer a refund and a date. The customer replies within the hour: No problem, I'll wait! You exhale. It turns out fine, and that is almost the annoying part. It turned out fine through luck, not through anything you did.

You sit on the edge of the box and think: the problem was never the soap. The problem was that you found out from the customer.

You were the last person to know about your own shelf.

What if the shelf told you first?

Here is a thought that doesn't feel dramatic, just quietly obvious.

What if you had one calm place where every product lived, with what you have, what you've sold, and the point at which you ought to order more? And what if that place simply said so when something was getting low, a week before it mattered rather than a day after?

Not a warehouse system. Not another subscription with a login you forget. Just a tidy file that keeps the count for you, so your head doesn't have to.

A different Saturday

Picture the same bakery queue, a few weeks on.

The notification comes in: 3 × Lavender & Oat Soap. You glance at it, pleased, and put the phone back in your pocket. You already know there are plenty. You already know the next batch of supplies is on its way, because you reordered it on Tuesday when the sheet nudged you, in about the time it takes to drink a coffee.

You order your rye loaf and actually hear yourself say it.

On Monday morning, there is no secret tour of the spare room. You open one file, see what is healthy and what is running down, and send two short emails before nine. Then you get on with the part of the business you actually like: making things, talking to customers, thinking about what to launch next.

The low hum has gone quiet. It turns out you hadn't realised how loud it was until it stopped.

If you recognised yourself in that queue

If any of this sounded familiar, the bakery, the thumb arithmetic, the message you rewrote three times, there is a simple next step that doesn't involve rebuilding how you work.

The Small Business Inventory & Reorder Tracker is an Excel template with automatic reorder alerts, stock value and a simple dashboard. It comes as a filled-in sample, so you can see how it behaves, and as a blank version for your own products, plus a short PDF guide. There is no subscription; it is a file that is yours.

It won't make suppliers faster. But it can make sure you hear about a low shelf from your own spreadsheet, and not from a customer.

An illustrative story, written with AI assistance.

Sounds familiar? Never Sold Out by Surprise – Inventory & Reorder Tracker (Excel) – Excel inventory tracker with automatic reorder alerts, stock value and dashboard. Sample + blank template, PDF guide. No subscription.

Take a look