Stock tracked batch by batch up to its expiry date, and synced with the shop
In Normandy, Harmonie Nutrition Équine, an equine nutrition online retailer, kept its stock in a home-made spreadsheet. The application we built tracks each batch from delivery to its expiry date, and deducts each online order from stock. In service since October 2026.
Jeudi 15 octobre · dernière commande de la boutique reçue à 10 h 42
- Électrolytes 3 kgPF-ELE-3K · ProduitRupture de stock0 sacMinéraux du Val Fleuri
- Sacs kraft 5 kgMP-SAC-005 · stock 180 unité26 j / 45suggéré300 unité
- Prémix vitaminesMP-VIT-001 · stock 18 kg12 j / 30suggéré30 kg
- Carbonate de calciumMP-CAL-001 · stock 120 kg18,5 j / 30suggéré90 kg
- Huile de lin 5 LPF-HLI-5L · stock 14 bidon9,3 j / 21suggéré24 bidon
- Granulés fibres 20 kgPF-GRF-20K · stock 46 sac15,3 j / 21suggéré40 sac
- Orge floconnéeMP-ORG-001 · stock 410 kg20,5 j / 30suggéré260 kg
DLUO dépassée · à vérifier ou retirer du stock
À utiliser en premier en production (ordre FEFO)
Jeudi 15 octobre
The application informs, the team decides.
Alert threshold set in the application. Acceptance testing of every user journey, and tests counted on 27 September 2026.
Stock kept in a spreadsheet, next to the shop
The company sells equine nutrition products online. Most of what it sells is bought in for resale, and some is made on site. The business software is not built for detailed stock tracking, so the team kept stock in a home-made spreadsheet.
The audit of the whole organisation, carried out from April to June 2026, had described these tools and put stock at the top of the roadmap.
Read the audit case study
Harmonie Nutrition Équine
Every day, the team has to
- 01ship around forty orders
- 02receive deliveries from suppliers
- 03make some of the products on site
- 04keep track of every batch and its expiry date
What the application does
Stock lives in the application. The shop, deliveries, production and counts feed it. The team gets what it needs to decide, on a computer or a phone.
What feeds the stock
InEach order is deducted from stock, packaging included, with nothing to type. A recheck runs every night.
On the phone: the item, the quantity, the batch number, the expiry date, and a photo of the delivery note.
The recipe says which materials to take out. One batch per bag size, numbered automatically.
Items to recount without seeing the expected stock. The difference is posted to the right batch.
Semaine 42 · comptage à l'aveugle
MP-LIN-001
Graines de lin extrudées
Tous lots confondus
Quantité comptée (kg)Le stock attendu s'affiche après l'enregistrement.
Minéraux du Val Fleuri · saisie sur téléphone
Vérifiez chaque ligne (article, lot, DLUO, quantité) avant de confirmer : tout reste modifiable à la main.
The batch whose expiry date comes first goes out first, for sales and production alike.
What the team receives
OutAn expiry date less than 60 days away, a stock-out coming, based on the last 30 days of use.
Suggested quantities, supplier by supplier. The team places the orders itself.
Filled in from production, on the laboratory's template, with the supplier and batch of each material.
What it went into, the customers to warn, then blocking the batch and everything made from it.
Built with the team, then put into service
A first version was running two days after signing. The next two months went into fitting it to the trade, with the team, then testing every user journey.
- 22 July 2026
A first version on staging
Two days after signing, to test it and adjust it.
- August – September 2026
Fitted to the trade
The traceability sheet on the laboratory's template, one item per bag size, the warehouse tasks on a phone.
- 23 September 2026
Demonstration to the team
The application shown to the team, on staging.
- 27 September 2026
Acceptance testing of every user journey
32 issues raised, all fixed and checked, then a second pass with no blocking defect.
- 1 October 2026
The application presented
The complete version, before the data was brought across.
Going live, step by step
October 2026- The dress rehearsal
38 steps, about two hours, on a computer and on a phone.
- Bringing the data across
We provide the file template, the team fills it in, then we import it.
- The opening stock
A stock check on a date set with the team, so that no order is counted twice.
- In service
Orders from the shop feed the stock, and the team works in the application.
It runs on our servers, and it keeps improving
Hosted by WebWize, on its infrastructure.
- A request from the team
A gap or an idea, raised by the company.
- The fix
Written by WebWize, separately, then reviewed before being merged.
- The check
On a test copy kept separate from production, with the automated tests.
- In production
A backup is taken just before, then the team gets the new version.
Kept for seven days, four weeks and three months.
Costed during the audit, they are still to be decided with the company.
More case studies
Hacot & Co, water softener servicing
A custom scheduling application, in service since July 2026.
335 Google clicks over 28 days, up from 183 before the agents arrivedNuances, caterer in Bordeaux
Online shop, cost calculation and SEO agents.
12 mailing lists created and in serviceMedical biologists' union
Its lists moved from Ezmlm, which Gmail and Outlook blocked more and more, to Mailman 3 on a dedicated server.
Is your stock still living in a spreadsheet?
Thirty minutes to look at how you track your batches and expiry dates today. Free.