Trace any lot, from the dock to the customer’s door
Every case is received by lot, put away to a location, and recorded on the orders it ships on. When a supplier recalls a product, you can see where every case went.
Book a demoMeridian Foods inventory
Stock across every temperature zone
Down to the lot and its date, at landed cost, as each delivery lands.
Stock by product All zonesCoolerDry
| SKU | Product | On hand | Committed | Available | Days of cover | Status |
|---|---|---|---|---|---|---|
| OL-112 | Olivar EVOO 1L | 216 | 120 | 96 | 3.7 d | Critical |
| GY-032 | Greek Yogurt 32oz | 640 | 410 | 230 | 1.6 d | Review |
| SM-028 | San Marzano Tomatoes 28oz | 1,480 | 300 | 1,180 | 9.4 d | OK |
| SW-012 | Sparkling Water 12pk | 2,200 | 1,460 | 740 | 2.1 d | Review |
| CH-005 | Aged Cheddar 5lb | 380 | 90 | 290 | 6.8 d | OK |
| OL-114 | Sierra EVOO 1L | 1,340 | 0 | 1,340 | 48.0 d | Overstock |
| PS-208 | Penne Rigate 16oz | 2,900 | 640 | 2,260 | 11.2 d | OK |
Lots close to their date 3 lots
- Greek Yogurt 32ozGY-0927 · 140 cases · Cooler · B-0486% of shelf life
- Fresh Mozzarella 1lbFM-0921 · 64 cases · Cooler · B-1182% of shelf life
- Oat Milk 64ozOM-0830 · 210 cases · Dry · D-0774% of shelf life
What a recall usually looks like
- A supplier’s call, then a day of paper and spreadsheets.
- Lot numbers written on delivery notes, not on the record.
- No quick way to say which customers got which lot.
How it works in Stockwell
- 01Receive by lot
Each delivery is received with its lot, date and supplier.
- 02Store by location
Lots are put away to a location, and every move is recorded.
- 03Ship by lot
Each order records the lots it was picked from.
- 04Trace it back
Look up a lot to see where it came from, where it is, and every order it shipped on.
One record behind every lot
Each product carries its supplier, pack and IDs in every connected system, so a lot always traces back to the same record.
Product · CH-005
Aged Cheddar 5lb
One record, used by every module and every connected system.
IDs in every system
- Warehouse appWH-5521
- Order desk8105
- XeroCHED-AGED-5
- PurchasingCC-205
Price lists
- Fairway Grocers$5.60 / lb
- Greenleaf Markets$5.75 / lb
- Restaurants & hotels$6.10 / lb
- Independents$6.25 / lb
Change history
- Landed cost $4.06 → $4.18 / lb · freight bill postedSep 29
- Greenleaf price $5.60 → $5.75 / lb · approved by Daniel OrtizSep 22
- Average weight updated to 5.2 lb · last 40 wheels receivedSep 14
Every order knows its lots
Orders are picked by lot, so the record shows which customer received which lot and on which run.
Sales order queue
Every order from every channel, in one format
| Order | Channel | Customer | Status | Run |
|---|---|---|---|---|
| SO 52318 | EDI | Fairway Grocers | Short | Run 2 |
| SO 52317 | Rosa’s Trattoria | Open | Run 1 | |
| SO 52316 | EDI | Greenleaf Markets | Open | Run 3 |
| SO 52315 | Phone | Union Street Deli | Confirmed | Run 1 |
| SO 52314 | Portal | Bayside Co-op | Confirmed | Run 2 |
| SO 52313 | EDI | Fairway Grocers | Confirmed | Run 2 |
| SO 52312 | Marlow Hotel | Confirmed | Run 1 | |
| SO 52311 | EDI | Greenleaf Markets | Confirmed | Run 3 |
| SO 52310 | Phone | Rosa’s Trattoria | Invoiced | Run 1 |
| SO 52309 | Portal | Hillside Market | Invoiced | Run 3 |
| SO 52308 | EDI | Fairway Grocers | Invoiced | Run 2 |
| SO 52307 | Bayside Co-op | Invoiced | Run 2 | |
| SO 52306 | Phone | Union Street Deli | Invoiced | Run 1 |
| SO 52305 | EDI | Greenleaf Markets | Invoiced | Run 3 |
| SO 52304 | Marlow Hotel | Invoiced | Run 1 |
Ask in plain words
Ask Stockwell works on the same live record, looks up what you ask across every module, and shows each step it took.
- Found Monday’s promopromo-calendar.md · Oct 6 to 26
- Checked stock and open POsInventory · Purchasing · 740 free, nothing on order
- Checked the supplier’s cutoffsupplier-lead-times.md · order by Wednesday noon
- Modelled the three promo weeksSales history · last promo lifted 60%, 45%, 30%
No, you’ll run short in the first week. You have 740 cases free and nothing on order.
| Promo week | Need | Have | Short |
|---|---|---|---|
| Oct 6 – 12 | 1,520 | 740 | 780 |
| Oct 13 – 19 | 1,380 | 0 | 1,380 |
| Oct 20 – 26 | 1,240 | 0 | 1,240 |
Order 2,700 cases by Wednesday noon and weeks two and three are covered. Want me to draft the PO?
The modules behind it
Frequently asked questions.
Something else on your mind? Ask our team.
Does Stockwell help with traceability rules?
Stockwell keeps the lot-level records food-safety and product-recall rules depend on: what came in, where it was stored and where it shipped. Confirm your specific requirements with your regulatory advisor.
Can we trace a lot to the customer?
Yes. Each order records the lots it was picked from.
Do our people have to scan everything?
Lots are captured at receiving and picking. We set this up around how your floor already works.
Could you trace a lot today?
Bring a recent delivery. We’ll show you how its lot would trace in Stockwell.