← /work— / —
$ cat /work/asset-inventory-system.md
industry
Specialty furniture retail
region
Asia-Pacific
year
2025
status
●Delivered
# at a glance
Replaced spreadsheets, photos, and group chats with a typed inventory system. Pieces stopped going missing in the system before they went missing in the warehouse.
# problem
A specialty retailer was tracking inventory across spreadsheets, photos, and group chats. Pieces went missing in the system before they went missing in the warehouse.
Floor staff needed something simple enough to use, but structured enough to support sourcing decisions.
# approach
Designed the data model around how pieces move: sourced, restored, listed, sold, delivered.
Kept free-text fields to a minimum, used typed states, and made every status change auditable.
Shipped a handoff package — schema notes, deploy instructions, common queries — so the client could maintain the system end-to-end.
# outcome
Delivered with full handoff documentation. Inventory state reflects warehouse reality.
# stack