← All work

Spirits & ready-to-drink beverages

Automated shelf-life status in the warehouse

A daily job that reclassifies near-expiry Stateside inventory in the WMS, so short-dated stock is never allocated to normal orders.

  1. Daily schedule
  2. Expiry rules
  3. WMS status update
Client
Stateside Brands ↗
Spirits & ready-to-drink beverages
Stack
AWS Lambda, EventBridge Scheduler, Python, SQL, SCALE WMS API

Results

  • Runs daily at 5:00 AM ET with dry-run and apply modes

What I built

  • Expiry rules: pallets with 30 days or less to expiry move to Restricted, and those with 31–90 days move to a 30-day status. Held, in-transit and allocated stock is skipped.
  • A scheduled Lambda with dry-run and apply-all modes.
  • A bulk-adjustment tool that applies CSV-driven status changes and keeps a run log.