Write Down the No: How a Missed-Sale Log Sharpens Your Range

Every trade counter has a version of this exchange. A customer leans in and asks for something specific - a particular thread, a pack size, a fitting they saw on site - and gets the same answer: sorry, we don't stock that. It is easy to treat that as a dead end. It is actually a free sample of demand, provided you write it down.

The instinct is to rely on memory. Someone says they will mention it to the buyer; the buyer nods; the rep calls a fortnight later and the conversation restarts from nothing. By then the detail has gone. Was it stainless or zinc? A hundred pack or a box of twenty-five? Was it for a one-off repair or a job the customer does every week? Without a record, the range gets built on the loudest voice in the room rather than the strongest pattern at the counter.

A missed-sale log is the cheapest bit of range research a UK trade counter can do. It does not need software, a consultant or a new process. It needs one page, a pen and the discipline to use it while the customer is still in front of you.

Why the counter forgets faster than you think

Trade counters are built for speed. You serve, you solve, you move on. That is the job. But speed is exactly why memory is a poor buying tool. A busy Saturday can produce half a dozen near-identical requests and by Monday they have blurred into one vague feeling that people keep asking for those things.

The problem with that feeling is that it is not evidence. It cannot tell you whether the request came from one customer with an unusual job or ten customers with the same recurring problem. It cannot tell you whether your alternative was accepted, refused or taken with a grumble. It cannot tell you whether the customer came back. Those are the details that decide whether a new line earns its shelf space or becomes dead stock with a layer of dust on it.

The loudest rep is not evidence either. Reps are useful. They know their ranges and they can point out gaps. But a rep's job is to sell their lines, and your job is to buy what your counter actually turns over. A log keeps the conversation honest. When a rep says a line is flying, you can check whether your customers have been asking for it or whether it just sounds plausible.

The five columns that earn their keep

Keep the page simple. If the log takes more than twenty seconds to fill in, it will stop being filled in. Five columns are enough:

1. Date and initials. Not for blame. For pattern. If one member of staff logs most of the requests, they may simply be best at capturing them. If nobody logs anything for a week, the habit has slipped.
2. What was asked for. Be specific. Size, thread, material, pack size, brand if it matters. Some screws is not a data point. M8 x 100 stainless coach screws, box of 50 is.
3. The job it was for. This is the column people skip and it is the most useful one. The same product can be asked for by a roofer, a kitchen fitter and a farmer for completely different reasons. The job tells you whether the demand is repeatable or a one-off.
4. What you offered instead. Did they take the alternative? Did they say it would not do? Did they walk? This tells you whether you have a stock gap or a pack-size gap or simply a customer who needed a different solution.
5. Did they come back? A simple yes, no or unknown. If they came back for the same thing, that is a strong signal. If they came back and bought something else, that is useful too.

Add a notes column if you must, but keep it short. Said he would try online is enough. You are not writing a novel. You are collecting patterns.

Put it where the refusal happens

The log has to live where the conversation happens. A clipboard by the till. A tab on the counter PC. A shared note on the phone that stays on the counter, not in someone's pocket. The important thing is that it is visible and easy to reach before the next customer steps up.

The rule is simple: if you say we don't stock that, you write it down. Not later. Not at the end of the shift. Then. The customer is still there, the detail is fresh and the job is obvious. Twenty seconds now saves a month of guessing.

Make it okay to write untidy entries. A log full of shorthand is better than a blank page with neat handwriting. Sat am - M10 wedge anchors, 50 pack, handrail job, offered zinc, refused, coming back Fri tells you more than a perfect sentence written a week later from memory.

Review it monthly, not when the rep calls

A log that is never reviewed is just clutter. Set a monthly slot - half an hour, first week of the month, same time - and read it properly. Not to count every request, but to look for clusters.

Ask four questions. What came up more than once? What did we offer instead, and did it work? What did we not have that we could have reasonably stocked? What was a one-off that we should ignore?

Sort the answers into types of gap. A true gap is something customers ask for and refuse the alternative. A pack-size gap is when you stock the item but only in a size that does not suit the job. A brand gap is when the request is specific and the alternative will not do. An education gap is when the customer did not know the alternative would work. A price gap is when they took one look and went elsewhere. Only the first three are buying decisions. The last two are counter conversations.

That sorting stops the log turning into a wish list. It also stops you buying a new line every time someone asks for something unusual. You are looking for repeatable demand, not every request that ever passed the till.

Turning the log into a short trial list

The output of the review should be short. Three to five lines for the season ahead is plenty. For each one, write down what you are testing and how you will know if it has worked. Trial a box of stainless coach screws in the two most-requested sizes. Review after six weeks. Success if we sell through half the box and get a repeat request.

Buy the smallest sensible pack. Put it near the related line, not in a forgotten corner. Tell the staff it is there and why. Then leave it alone long enough to prove something. A trial that gets moved, hidden or forgotten is not a trial; it is just stock you bought to feel better about a lost sale.

This is where the log pays for itself. It keeps the range tight. You are not adding lines because a rep was persuasive or because a competitor has a bigger wall. You are adding lines because your own counter produced the evidence. That is how you keep shelf clutter down and dead stock low while still filling the gaps that matter.

Close the loop with the customer

If you do stock the line, tell the customer. A quick that's in now when they next come in is worth more than a loyalty card. It shows the counter listens. If you decide not to stock it, the log still helps. You can offer a special order with a clear lead time, or point them to the right alternative without guessing.

A missed-sale log is not a complaint book and it is not a stick to beat the team with. It is a simple record of what the market asked for and what you could not supply. Used properly, it turns a month of polite refusals into a short, evidence-backed list of lines worth trialling for winter and spring. That is cheaper than guessing, and a lot more useful than relying on the loudest voice in the room.

At J&S Products, we like stock that earns its place. A page of no is often the best place to start.