← All case studies
Specialty retail6 weeks · focused build

Inventory intelligence across 6 stores

Regional liquor retailer · 6 stores

01 / PROBLEM

Every Monday the owner rebuilt reorder spreadsheets by hand. Stockouts on high-velocity SKUs were happening weekly in three locations, and surplus on slow movers was absorbing ~$40k of working capital at any given moment. No shared view between store managers and the back office.

02 / APPROACH

Built a single operations console on top of their existing POS (Square) and two supplier portals. The dashboard forecasts reorder quantities per SKU per location using trailing velocity, auto-drafts purchase orders, and routes them to managers for single-tap approval. Stockout alerts fire in Slack before shelves empty.

03 / OUTCOMES
  • 01Stockouts down 72% in 90 days
  • 02Working capital tied in surplus inventory reduced by $31k
  • 03Owner reclaimed ~6 hours/week previously spent on manual reorders
  • 04Single source of truth across 6 stores — no more Monday spreadsheet ritual
04 / SYSTEMS
Square POSSupplier APIsSlack alertsCustom dashboard
· SAME SHAPE AS YOURS?

Run our generator for a branded mockup + 3 scoped proposals.