Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. Why Does Our Mixed Case Discount Work in the Shop but Not Online, or the Other Way Round?
Problems We Solve

Why Does Our Mixed Case Discount Work in the Shop but Not Online, or the Other Way Round?

A wine merchant's any-twelve-bottles discount behaves differently on the till and the website. We build one discount rule set that both channels apply.

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

Mixed case discounts sound simple, but exclusions for fine wine, sale items, trade customers and club members mean the till and the web shop end up with different rules. We build a single set of discount rules that both apply, with clear exclusions, so customers get the same price wherever they buy.

'Online it said I'd get ten per cent'

Your offer is simple: any twelve bottles, ten per cent off. A regular builds a mixed dozen online, including two bottles of Champagne, and gets the discount. The next week he does the same in the shop and the till gives a smaller discount, because the till excludes Champagne and the website does not. He asks, fairly, which is right.

Then there are club members, who get their own discount, and the question of whether the two stack. The shop staff say no. The website says yes.

Two systems, two rulebooks

Your EPOS and your web shop each have their own discount engine, set up at different times by different people, often using different features. Any change, such as a new exclusion for fine wine, has to be made twice, in two different ways, and one of them is usually forgotten.

  • Exclusions (fine wine, sale items, spirits) are defined differently in each system.
  • Club member and trade discounts interact with case discounts in different ways.
  • Some systems count bottles, others count products, so magnums confuse them.
  • Temporary promotions are added in one place only.
  • Nobody has the full set of rules written in one document.

What inconsistency costs

The obvious cost is margin given away where the rule was too generous. The less obvious one is trust: a regular who gets a different price in the shop than online wonders what else is inconsistent. And staff overriding the till by hand to match the website introduces its own errors.

One rule set for both channels

  1. We write your discount rules down with you, in plain terms, including every exclusion and how discounts combine.
  2. Products carry the tags those rules need: fine wine, sale, spirits, format, so exclusions are based on data rather than lists typed into each system.
  3. The rules are applied in both channels, either by configuring each system identically from the same source, or through a single pricing service both call, depending on what your EPOS and web shop allow.
  4. Magnums and half bottles count by your chosen measure, for example a magnum as two bottles.
  5. Club and trade customers are recognised at the till and online, and their discounts combine only as you decide.
  6. A test basket screen lets staff check what a basket should cost before a promotion goes live.
Rule questionDecided once, applied everywhere
Is Champagne included?Tag-based exclusion, same in shop and online
Does a magnum count as two?Format rule, same in both
Do club and case discounts stack?Combination rule, same in both
Are sale items excluded?Sale tag, same in both
Trade customers?Account-based pricing, never the retail case offer

What the discounts are and which wines they cover is entirely your commercial decision.

The same price wherever they buy

A regular building a mixed dozen gets the same total on the website and at the till. When you exclude a new category, the change is made once. Staff stop overriding the till. And the promotions you run for Christmas or the summer are set up once and checked with a test basket before they start.

Take a normal Christmas promotion. You decide that any twelve bottles earn fifteen per cent in December, except fine wine over a price you choose, and that club members get the better of their own discount or the case discount but not both. That is written once as a rule. Before the first of December, the manager builds three test baskets: a mixed dozen with two magnums, a club member's basket, and one with a bottle of Champagne. The totals match in the shop and online. On the first of the month the rule starts in both places at once, and on the first of January it stops in both places at once.

Does this sound familiar?

  • Customers have noticed different discounts in the shop and online.
  • Exclusions are set up separately in two systems.
  • Staff override the till to match the website.
  • Nobody is sure whether club and case discounts stack.
  • Magnums and half bottles break the case count.

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

Do we have to replace our EPOS or web shop?

Usually not. Often the rules can be set identically in both from a single source; we only suggest a shared pricing service if your systems cannot do that.

Can we run a short promotion quickly?

Yes. A promotion is a rule with dates, set once and applied in both channels.

What about discounts at tastings and events?

They can be a separate rule that applies only to orders taken at that event.

How do we know the rules are right?

The test basket screen lets you try combinations before anything goes live.

What affects the cost?

Your EPOS and web shop platforms, and how many different discount types you run.

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 →