Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can a Wine Merchant Share Out a Small Allocation Without Upsetting Loyal Customers?
Problems We Solve

How Can a Wine Merchant Share Out a Small Allocation Without Upsetting Loyal Customers?

When a domaine gives a wine merchant six cases and forty customers want them, allocation becomes guesswork. We build rules-based allocation you can defend.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Small allocations from sought-after producers attract far more requests than cases, and deciding who gets what by memory upsets people and leaves no record. We build an allocation tool that applies your own rules, such as purchase history, past allocations and request order, proposes a split, and lets you adjust it before anyone is told.

Six cases, forty requests

The domaine's letter arrives: your allocation this year is six cases of the village wine and three bottles of the grand cru. You already have forty customers who asked for it, some in writing, some in passing at a tasting, one who has bought from you for twenty years and assumes he is first in line.

The owner sits down with a printout, a pen and a vague recollection of who got it last year. Two hours later there is a list. Nobody else can see why it came out that way, and the following week a customer who missed out asks, reasonably, what he needs to do to be considered.

Why fairness keeps slipping

Most merchants do have rules. They are just not written down. 'People who buy across the range, not only the trophy wines.' 'Nobody gets the grand cru two years running.' 'Trade accounts come first for the village wine.' Applied by one person from memory, those rules drift year to year, and they vanish when that person is on holiday.

The information needed to apply them fairly is scattered: purchase history in the EPOS or the web shop, last year's allocation in an old spreadsheet, requests in an inbox.

  • Past allocations are not recorded against the customer.
  • Spend history sits in a separate system from requests.
  • Some customers ask every year and are never lucky; nobody notices.
  • Allocations to staff, trade and private customers come from the same pot without a plan.

The cost of doing it by hand

The direct cost is the owner's time, at the moment when time is shortest. The larger cost is goodwill. A loyal customer who sees a newcomer post a photo of the wine he was refused is unlikely to say anything; he just buys a little less. And because nothing is recorded, you cannot answer the question 'why not me?' with anything but an apology.

There is also a commercial cost. Allocations are one of the best reasons for a good customer to keep buying from you. Handed out without a pattern, they stop rewarding the behaviour you want.

An allocation tool that follows your rules

  1. Requests are gathered in one place against each allocated wine, whether they came by email, form or a note from the shop floor.
  2. Each request is linked to the customer's record, pulling in their purchase history from your EPOS and web shop, and any allocations they received in previous years.
  3. You write down your rules once, in plain terms: weight for total spend, weight for breadth of buying, a limit on consecutive years, a share reserved for trade accounts.
  4. The tool proposes an allocation, with the reason shown against every line: 'bought across six regions this year, missed out last year'.
  5. You adjust it by hand where judgement says otherwise; the change and your note are saved.
  6. Confirmed allocations produce offer emails with a reply deadline, and anything declined rolls to the next person on the proposed list.
Rule you might setWhat it looks atWhy merchants use it
Breadth of purchasesNumber of different wines or regions boughtRewards customers who buy more than trophies
Recent allocationWhether they received this wine last yearSpreads rare bottles around
Request dateWhen the request was loggedSettles ties
Trade shareAccount typeKeeps restaurant lists supplied
Owner discretionManual override with a noteJudgement still has the last word

The rules are yours. We do not decide who deserves the wine; we make sure the rules you already use are applied the same way every time, and that the reasons are written down.

What changes when allocations are recorded

The owner spends minutes reviewing a proposal instead of hours building one. When a customer asks why they missed out, staff can see the reasons and give a straight answer, and you can tell them what would help next year. Over time, the record of who received what becomes a picture of who your best customers really are.

It also makes handing the job to someone else possible, which matters more than people admit.

Does this sound like allocation season?

  • The allocation list lives in one person's head.
  • You have given the same rare wine to the same customer several years running without meaning to.
  • Customers who missed out get an apology rather than a reason.
  • Requests for allocated wines come in through several channels.
  • Last year's allocations are hard to find.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Can we keep the final say on every allocation?

Yes. The tool proposes, you decide, and any change you make is kept with your note.

Does it need our full sales history?

It works best with it. We connect to your EPOS and web shop where possible, and older history can be imported from exports if you have them.

Could customers see the rules?

Only if you choose to publish them. Some merchants share the general principles, others keep them private.

What about allocations for trade customers?

Trade accounts can have their own share or their own rules, set by you.

What does it cost to build?

It depends mainly on where your sales history lives and how many channels requests arrive through. We will explain the options after hearing how you work.

Keep reading

More on Problems We Solve

Start here

Tell us where the admin piles up in your wine business

Describe how orders, stock and customers move through your shop today: the EPOS, the website platform, the spreadsheets and the inboxes. We will tell you what we would build and what we would leave alone, and if a setting in a system you already pay for would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →