Enter a lot code. Get its history back.
Any code off a label, an invoice, or a barrel lid resolves to the records behind it: the run that bottled it, the barrels that filled it, the batch that boiled it, and the collections behind that. It runs the other way too: pick a drum and see every lot, sale, and buyer it reached.
fig. 1 · the trace register · illustrative season data
Collection
Mar 7–8 · North Bush · 3,860 gal sap
Boil batch
Mar 8 · drawn off at 66.9 Brix
barrel 07 → retail
Barrel 07
31.5 gal · Grade A · Amber Rich
Bottling run
Mar 12 · 31.5 gal drawn · 30.9 gal packaged
Retail lot 260312-01
468 units · 250 ml
Sale
Oct 3 · farm stand · 24 × 250 ml
barrel 09 → bulk
Barrel 09
30.2 gal · Grade A · Amber Rich
Bulk sale
Apr 2 · 333 lb · loaned drum, returned May 6
Buyer
wholesale account · payment: paid
Five stages, one chain
Barrels, bottling runs, lots and labels, sales, and the trace that reads the whole chain back.
Caught at entry, not at audit
Bad records are usually honest mistakes at busy moments. Sapline checks at the moment of entry, and blocks the ones that can't be right.
Packing temperature
glass under 190 °F or plastic under 180 °F blocks the commit
Grade mixing
filling over a different grade takes explicit consent; the container reads Mixed until re-checked
Volume loss
more than 5% between barrels and bottles is flagged for review
Overselling
simultaneous sales can't take a lot below zero
Shrink, categorized
evaporation, sampling, spillage, breakage: named, not buried in notes
Backdated entries
allowed, but the history says so
Manage the commercial side without breaking traceability
When syrup leaves the barrel room, Sapline keeps buyers, shipments, pricing, and payment follow-up tied to the same inventory and lot records you already trust.
- Record each sale by buyer, grade, source containers, and custody type
- See season totals for pounds shipped, average price, and buyer activity
- Keep delivery method, payment terms, and notes attached to every shipment
- Let bulk sales update inventory while preserving the audit trail back to storage
- Drums leave as transferred or loaned, and loaned ones come back with one click
- Buyer profiles carry posted prices and payment terms, auto-filled on the next sale
- Payment tracked from pending to paid
- PPAQ buyer numbers and organic flags for Quebec and certified sales
The numbers should add up — now you can prove it
Track sales by retail lot and generate mass balance reports to verify what you sold matches what you produced. One report covers production, packaging, sales, and remaining inventory.
Three reconciliations run the length of the chain: production to storage, storage to packing, and packing to sales. Each checks expected against actual and returns a verdict of balanced, within tolerance, or imbalanced. The same verdict feeds program readiness and the inspection pack.
- Record units sold, buyer, channel, and price by retail lot
- Generate mass balance reports comparing production and sales
- Review any season's production-to-sales flow
- Drill into any number to view underlying records
If the call ever comes
Quarantine a barrel and every retail lot downstream is flagged the same minute. The trace answers both questions, what went into this lot and where that drum went, while you're still on the phone.
Trace any retail lot back to its source barrels, production batches, and collection dates in seconds.