Bin Location Directory & Capacity Tracker
Build a searchable directory of every storage location - size, zone, contents, and fill level - so anyone can answer "where is it / is there room?" without walking the floor.
A logged-in, searchable bin directory with live fill-level indicators, a propose-and-approve workflow for bin changes, and a clean CSV master export.
Before you start
- A location master list (CSV or Google Sheet) with bin id, type, dimensions, and zone
- Current on-hand quantity by location (CSV or sheet)
- Free Vercel, Supabase, and Resend accounts
The problem this kills
Someone walks up holding a pallet and asks the only question that matters: "Where does this go, and is there room?" Today the answer lives in three places that disagree - a dusty rack-label printout, a spreadsheet a supervisor updated last quarter, and the memory of whoever has worked here longest. So people walk the floor, guess, double-stack a full bin, or stash overflow in an aisle and forget it. New associates are lost for weeks. Inventory control burns hours reconciling "where it should be" against "where it actually is."
The real cost is not the spreadsheet being stale. It is that nobody trusts it, so the warehouse runs on tribal knowledge - and tribal knowledge walks out the door when people do.
What you'll build
A single, searchable directory of every storage location in your building. Type a bin id, a zone, or a SKU and instantly see what is stored there, how full it is, and whether there is space. Fill-level indicators turn red when a bin is overfilled and flag bins that are "orphaned" (holding stock no system expects). When the layout changes - a bin is added, resized, or retired - anyone can propose the change, but an inventory control lead reviews and approves it before the master directory is updated. Export a clean CSV master any time, in the exact columns your WMS or ERP expects.
What's inside the Implementation Plan
- It starts by interviewing you about your warehouse. Before a single screen is built, the plan has the AI agent ask you about your bin-naming scheme, your zones, your dimensions and units, your volumes, and your messy edge cases - then it tailors the data model and validations to your building, not a generic template.
- A step-by-step build you paste into Claude Code one prompt at a time.
- Importing your location master and on-hand from CSV or Google Sheet.
- Validating every bin id against your real naming convention and deduping on bin id.
- A fast search-and-filter view with color-coded fill levels.
- Automatic flags for overfilled and orphaned bins.
- A propose -> review -> approve workflow with email notifications.
- The clean CSV master export, plus a full "No API yet?" fallback so it is buildable today.
The governance it includes (this is the point)
This is not a throwaway spreadsheet replacement - it is a controlled system of record:
- Login so only your team can open it.
- Row-level security so each organization only ever sees its own locations.
- A complete audit trail - who proposed, who approved, and exactly when.
- A human-in-the-loop approval gate: the tool drafts a bin change, your inventory control lead reviews it, and only an approval writes it to the master directory.
- Duplicate guards so the same bin id can't sneak in twice.
Who it's for
Inventory control teams, warehouse supervisors, and the new associates who need to find a location without a ten-minute walk. If you manage storage and you are tired of the directory nobody trusts, this is for you. No coding background required.
You've got this - paste the first prompt and let the agent interview you.