Stock Levels You Cannot Keep Accurate

Why the numbers drift

One shelf, two ways to sell from it, and no instant connection between them.

Somebody buys the last one in the shop at ten past two. The website still shows it as available until whoever is serving gets to the till, or until the end of the day, or until somebody notices.

In between, it can be sold again online. That is not a system failure; it is the ordinary consequence of two channels drawing on one stock.

The businesses that suffer most are the ones who believed the number was authoritative.

The two ways to be wrong

You are choosing between them whether or not you decide deliberately.

Overselling. Showing stock you do not have. Costs you an apology, a refund, and a customer who may not return.

Underselling. Holding a buffer so the website shows fewer than you have. Costs you the sales you refused.

Most small businesses drift into overselling because it is the default when nothing is configured, and it is the more damaging of the two.

A deliberate buffer on your fastest-moving lines costs a small number of sales and prevents nearly all of the apologies.

A worked example

A shop selling secondhand books both online and over the counter, each item unique.

That is the worst version of this problem: every oversell means the customer cannot be offered an alternative, because there is only one.

They were cancelling perhaps four orders a week, each requiring an apologetic email and a refund.

The fix was procedural rather than technical. Anything listed online was moved to a separate shelf behind the counter, not available to browse. Shop customers could ask for it, and staff checked the website before selling it.

Cancellations went to roughly one a month, and those were genuine timing collisions rather than routine.

They sold slightly less in the shop as a result. The trade was worth it, because an online cancellation cost far more goodwill than an unbrowsable shelf cost sales.

Making the failure graceful

Since some collisions are unavoidable, how you handle them matters more than preventing every one.

Contact the customer quickly, before they would otherwise expect dispatch. A cancellation on the same day is an inconvenience; one discovered on day five after they chased is a complaint.

Apologise plainly, refund immediately rather than after a process, and offer an alternative if there is one.

And where the item will be back in stock soon, say when, and offer to hold one. A reasonable proportion will wait if asked properly.

Showing stock at all

A decision worth making rather than accepting the default.

Showing an exact number invites the customer to treat it as a fact, which it is not.

Showing in stock or out of stock is looser and harder to be wrong about in a way that matters.

Showing low stock warnings creates urgency and is worth using only when true, because a permanent low stock label is quickly recognised as decoration.

For most small shops, a simple in or out is the honest option and produces fewest disputes.

The counter-case

Where exact numbers help.

Trade customers ordering quantities need to know whether you have forty or four, and a vague indicator forces a phone call every time.

Businesses with genuinely connected systems, where the number is accurate to the minute, should show it because it is useful and true.

And anything where scarcity is a real part of the purchase, such as limited runs, where the count is information the customer wants.

The test is whether the number is accurate enough to be relied on. If it is, show it. If it is a daily estimate, do not present it as a live figure.

Out of stock pages

The page that most shops handle badly.

Deleting the page loses whatever visibility it had and gives an arriving customer an error.

Leaving it with a greyed-out button and no explanation tells them nothing.

The useful version keeps the page, says it is unavailable, says when it is expected if you know, and offers either a notification when it returns or a suggested alternative.

A notify-me option costs little and produces a list of people who wanted to buy something, which is a better asset than a deleted page.

Discontinued against out of stock

Worth distinguishing, because they need different handling.

Something temporarily unavailable keeps its page and its notification option.

Something permanently gone should redirect to the nearest equivalent or a category page, rather than sitting there indefinitely disappointing people.

A shop that has run for a few years usually has a growing tail of pages for things it no longer sells, and that tail is worth reviewing annually rather than letting it accumulate indefinitely.

Reserving stock in the basket

A setting worth understanding because it changes where the collision happens.

Some platforms hold stock as soon as it is added to a basket, releasing it after a period. Others only decrement it when payment completes.

Holding at basket stage prevents two people buying the last one simultaneously, and it means abandoned baskets lock up stock for the hold period.

Decrementing at payment maximises availability and allows the simultaneous purchase problem, which is rare at small volumes.

For most small shops, decrementing at payment is the right default. The basket-hold arrangement matters at volumes where two people genuinely are checking out at once, which is not most of us.

Practical arrangements

1. Decide your buffer for fast-moving lines, even if it is one.
2. Separate online stock physically where items are unique.
3. Check orders before the shop opens, so overnight sales are accounted for.
4. Have a cancellation email ready, so it goes out fast.
5. Track how often it happens, because the rate tells you whether the arrangement is working.

The fifth is the one that turns this from a recurring annoyance into a solved problem, because it shows whether what you changed made any difference. Four a week falling to one a month is a result; a vague sense of improvement is not.

How to tell the customer when something goes wrong is the same problem as in what your delivery estimate is promising.

Frequently asked questions

West Coast Media Solutions Inc. provides web design, web development, hosting, digital marketing, and business consulting to organisations across Canada, drawing on more than twenty-five years in the field.