Sell it before it expires or stops selling

Every lot carries its date and every product its days of cover. Stockwell flags stock close to its limit or sitting too long, picks the oldest first, and buys to cover rather than to habit, so less ends up written off.

Book a demo

Inventory

TransferReceive

Harbor Fresh inventory

Stock across every cooler

Down to the lot, at landed cost, as each delivery lands.

On hand4,170cases · all coolers

Available2,855after today’s orders

Inbound7,065on 10 open POs

Expiring in 2 days38picked first today

Stock by product All coolersCooler 2Dry store

SKU	Product	On hand	Committed	Available	Days of cover	Status
BC-001	Shanghai Bok Choy	780	520	260	1.0 d	Review
GA-003	Garlic A	110	0	110	1.8 d	Critical
MG-002	Mango	420	95	325	1.8 d	At risk
SP-006	Spinach	300	120	180	2.0 d	Review
AG-007	Asian Greens Mix	520	180	340	2.6 d	OK
GB-004	Garlic B	800	0	800	25.5 d	Overstock
SM-005	Shine Muscat Grapes	1,240	400	840	2.8 d	Critical

Lots close to their limit 3 lots

Shanghai Bok ChoyBC-0921 · 310 crates · Cooler 2 · A-14
90% of shelf life
MangoMG-0914 · 180 trays · Cooler 3 · C-02
89% of shelf life
Garlic BGB-0829 · 420 cartons · Dry store · D-11
71% of shelf life

What write-offs usually look like

Stock found past its date, or untouched for months, on a walk through the warehouse.
Ordering by habit, so the slow weeks overflow.
Write-offs that only show up at month-end.

How it works in Stockwell

01Receive by lot
Every delivery is received by lot, with its date, location and landed cost.
02Watch dates and cover
Each lot is tracked against its date, and each product against its days of cover.
03Pick oldest first
Orders are allocated oldest lot first, so short-dated stock ships before fresh.
04Buy to cover
The purchase plan works from available stock and real sales, and never orders past a product’s shelf life.

Shelf-life and cover rules, written down once

Rules like never ordering past a product’s shelf life, or when stock counts as overstock, are written down once, and purchasing and Ask Stockwell follow them.

Business rules

Ask about a ruleNew rule

cover-policy.md41 reads
supplier-lead-times.md33 reads
gp-targets.md18 reads
promo-calendar.md12 reads
substitutions.md9 reads
receiving-rules.md27 reads

Policy · updated by Maya Chen

Stock cover policy

Cover is worked out on available stock: on hand, less what sales have already allocated.

Review when available stock is under 2 days of cover.
Critical when cover with everything inbound falls short of the supplier’s lead time.
Overstock when cover with incoming supply goes past 14 days.

Order enough for the lead time plus one week of demand, rounded to the pack. Stockwell recommends; a buyer approves.

Order size

Give a range up to 20% above the base quantity so the buyer can choose within it. Never order past a product’s shelf life at expected sales.

Who decides

Stockwell recommends. A buyer approves every purchase, and any order over $10,000 needs a second approval.

Applied inPurchasingInventoryAsk Stockwell

Allocated oldest lot first

The order intake workflow allocates the oldest lot that will still arrive in date, on every order, without anyone choosing.

Workflows · Order intake

Test runNew workflow

TriggerA customer order arrives

42 today

AI stepRead the order, match every line

automatic

BranchEnough stock for every line?

Yes · 41No · 1

ActionAllocate, oldest lot first

ApprovalSales approves the change

1 waiting

ActionConfirm to the customer

automatic

ActionAdd to the delivery run

automatic

Ready to pick

Purchasing that knows what’s ageing

Recommendations work from available stock and days of cover, and say when to cut the next order because stock is already sitting.

Purchase plan

Approve 2 POsNew PO

This week’s purchase plan

Drafted by Stockwell at 5:58 am · a buyer approves every order

Product	Supplier	Cover	Recommendation
Garlic A	China Import Supplier	1.8 d	1,170 cartons
Shine Muscat Grapes	China Import Supplier	2.8 d	6,300 lb
Mango	Baja Produce Supplier	1.8 d	Expedite PO-3025
Shanghai Bok Choy	Local Grower A	1.0 d	Reduce import
Spinach	Local Grower C	2.0 d	Covered by PO-3028
Garlic B	China Import Supplier	25.5 d	Cut the next order
Asian Greens Mix	Local Grower B	2.6 d	No action this week
Romaine 24ct	Salinas Growers	2.2 d	Order 160 cases
Lemons 115ct	Coastal Citrus	4.1 d	No action this week
Cilantro 30ct	Ruiz Farms	1.9 d	Order 90 cases

The modules behind it

Frequently asked questions.

Something else on your mind? Ask our team.

How does Stockwell know what’s about to expire?

Every lot is received with its date, and Stockwell tracks how much of its life is left.

What about stock that doesn’t expire?

Days of cover flags overstock on any product, and purchasing recommends cutting the next order before more arrives.

Does it change how we buy?

It recommends quantities from cover and lead time. A buyer still approves every purchase order.

Writing off more than you’d like?

Bring a week of stock and sales. We’ll show you what Stockwell would have flagged.

Book a demo team@stockwellagents.com

Sell it before it expires or stops selling

What write-offs usually look like

How it works in Stockwell

Shelf-life and cover rules, written down once

Allocated oldest lot first

Purchasing that knows what’s ageing

The modules behind it

Related

Frequently asked questions.

Writing off more than you’d like?