Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Stop Finding Cases of Beer Near Their Best Before Date at the Back of the Cold Store?
Problems We Solve

How Do We Stop Finding Cases of Beer Near Their Best Before Date at the Back of the Cold Store?

Breweries find short-dated beer too late because stock is not tracked by date. We build dated stock views and alerts that push older batches out first.

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

Short-dated beer builds up because stock is counted by product, not by best before date, and pickers grab the nearest pallet. We track packaged stock by batch and date, tell pickers which batch to take, and alert whoever sells when a batch is getting close to its date, while there is still time to move it at a sensible price.

A pallet behind a pallet

At stocktake someone moves a pallet of the new batch and finds cases of the same beer from months earlier behind it. The hop aroma has faded and the date is close. It goes to the taproom at a discount, to staff, or down the drain. Meanwhile trade customers had the fresh batch, which is what they want, and the older stock sat there.

For hop-forward beers the window is short, and freshness is part of why people buy from you rather than from a supermarket shelf.

Why old stock hides

Stock figures are by product: so many cases of the pale. Nobody records which batch is where. Pickers take whatever is easiest to reach, which is usually the newest pallet in front. Webshop and trade sell from the same figure without regard to date. Nobody looks at dates until a stocktake.

  • Stock is counted by product, not by batch and date.
  • Picking is by convenience, not first in first out.
  • Cold store space means new pallets go in front.
  • No alert when a batch approaches its date.
  • Sales do not know there is older stock to move.

What finding it late costs

Beer poured away or sold at a heavy discount. Cold store space taken by stock that should have gone. Customers who get tired beer and do not reorder. And the quiet cost: the team loses trust in the stock figures and starts over-ordering packaging runs just in case.

Your approach to dates and what you sell is your own decision. What we fix is knowing what you have and when it needs to go.

It also clouds the brewing plan. If the stock figure includes cases that will never sell at full price, the plan thinks you have more of a beer than you do, and the next brew of it is scheduled later than it should be. The fresh beer then arrives just as trade customers have gone elsewhere for it.

Stock by batch and date

  1. Each packaging run creates stock by beer, pack format, batch and best before date.
  2. Cold store locations are simple: bays or pallet spots, labelled.
  3. Picking lists and the webshop packing screen tell staff which batch and location to take, oldest first, unless an order asks otherwise.
  4. A dated stock view shows, per beer, how much is in each batch and how long until its date.
  5. Alerts go to sales when a batch reaches a threshold you choose, with a suggestion: push to trade, taproom, a web bundle or a mixed case.
  6. Web bundles and mixed cases can be set to draw from the oldest batch.
  7. Monthly counts are done by batch, which keeps the figures honest.
ViewWho uses itWhat they do with it
Picking list by batchWarehouseTake oldest first
Dated stockProduction and salesSee what needs moving
Approaching date alertSalesPush to trade or taproom
Bundle rulesWebshopUse older stock in mixed cases
Batch countWarehouseCorrect the figures

A cold store with no surprises

Older stock goes out first without anyone thinking about it. Sales hear about an ageing batch while it still tastes right. Stocktakes stop producing discoveries. Packaging runs are sized from real stock, not a feeling, so less is made that cannot be sold in time.

Is this your cold store?

  • Stocktakes find older batches behind new ones.
  • Stock is counted by product, not batch.
  • Pickers take the nearest pallet.
  • Short-dated beer gets poured or heavily discounted.
  • Sales do not know when a batch needs moving.

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 need a warehouse system?

Not a big one. A simple bay layout and batch tracking in the tool we build, or in your brewery system if it supports batches, is enough.

Does this work for kegs and casks too?

Yes. Kegs and casks are tracked by batch the same way, and cask ale's shorter life makes the alerts more useful.

Can the webshop show the best before date?

Yes, if you want. Some breweries show it on limited releases; it is a setting.

What if trade customers ask for a specific batch?

The picking screen allows an override with a reason, so exceptions are recorded.

Keep reading

More on Problems We Solve

Start here

Tell us where the brewery loses track

Describe the problem, the brewery software and spreadsheets you use, and roughly how many trade accounts and vessels you run. We will tell you what we would build and what we would leave alone, and if a setting in the 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 →