Dashboard · Shop Floor
Procurement
Track materials and hardware from order to job site.
How this page works (click to expand)

Procurement is the bridge between a designed job and a build-ready job. Every part needed for a project gets tracked from "we need it" through "it's in the bin and ready to pull." This page is the live view of where every part stands across every active project.

How to use this page

1
Start at the top -- KPIs and Recent Activity. Needs Purchase Request flags Pre-Production jobs that don't have a PR drafted yet. Pending Items shows what still needs attention (Not Started, Needs Ordering, Ordered). Other Items is the healthy stuff (Total, Pulled, Received). The right sidebar logs the most recent status changes and tracking updates.
2
Pick a view: By Project, By Vendor, or Unassigned Ordered. By Project is the default -- expand a job card to see every item grouped by vendor. By Vendor rolls everything up across projects so you can place a single order with a vendor (use "Mark All Ordered" to bulk-update). Unassigned Ordered is for items the email parser picked up that couldn't be auto-matched to a project.
3
Move items through the status flow. Standard purchased items move Needed -> Ordered -> Received -> Allocated -> Pulled -> In Bin. Shop-made items move Needed -> In Production -> Pulled -> Shipped. Use the dropdown on each row to update one at a time, or the bulk button on the vendor view.
4
Resolve unassigned shipments. On the Unassigned Ordered tab, each item has two buttons. Assign to Project sends the full quantity to a single active project. Split opens a quantity picker so you can divide the shipment across multiple projects (e.g. one box of hinges shared across three jobs). Once assigned, the item's tracking number flows through to the project view.
5
Filter and toggle. Use the status dropdown to focus on one stage (e.g. just "Ordered" to see what's in transit). Toggle Show completed to bring closed jobs back into view. Project cards collapse by default -- click the header to expand.

Where the data comes from

Items and SKUs come from Airtable (Purchase Requests + Master SKU List). Project status and PR flagging come from JobTread. Tracking numbers and shipment ETAs come from parsed vendor shipping emails. Status changes you make here are saved to tools/maestro-dashboard/data/procurement_status.json and reflected back into the activity log.

Needs Purchase Request
All Pre-Production jobs have a Purchase Request marked ready.
Pending Items
Not Started
73
Awaiting review
Needs Ordering
35
Confirmed not in shop
Ordered
7
Waiting on delivery
Other Items
Total Items
540
Pulled
156
In project totes
Received
51
At the shop
Recent Activity
Closet Door - Slab marked Pulled
2659 - Gowans -- 2026-10-21
Drawer-Lamello Cabineo-EVO828-5/8 Material marked Pulled
2659 - Gowans -- 2026-10-21
Closet Drawer - Slab marked Pulled
2659 - Gowans -- 2026-10-21
5mm Shelf Pin - L-Shaped marked Loaded
2646 - Gilbert -- 2026-10-16
9 mm Screw-in Dowel marked Loaded
2646 - Gilbert -- 2026-10-16
Oval Rod - Aluminum - Matte Black marked Shipped
2646 - Gilbert -- 2026-10-16
3/4 Tru North - Black marked Shipped
2646 - Gilbert -- 2026-10-16
1mm Tru North - Black marked Shipped
2646 - Gilbert -- 2026-10-16
Titus Wedgefix - White marked Shipped
2646 - Gilbert -- 2026-10-16
Oval Rod Support - Matte Black marked Shipped
2646 - Gilbert -- 2026-10-16
Titus Knock-in Housing - Black marked Shipped
2646 - Gilbert -- 2026-10-16
5/8 Tru North - Hardrock Maple marked Pulled
2659 - Gowans -- 2026-10-13
Locking Device - EVO828 - RIGHT marked Needed
2659 - Gowans -- 2026-10-13
Locking Device - EVO828 - LEFT marked Needed
2659 - Gowans -- 2026-10-13
Titus Knock-in Housing - White marked Needed
2659 - Gowans -- 2026-10-13
Tracking #11255179 delivered
2607 - Martin -- 2026-03-20
Tracking #11260341 delivered
2607 - Martin -- 2026-03-20
Tracking #11255179 delivered
2638 - Martin -- 2026-03-20
Tracking #11260341 delivered
2638 - Martin -- 2026-03-20
Tracking #67133824 delivered
2609 - Voth -- 2026-03-27
Tracking #10447106 delivered
2609 - Voth -- 2026-03-27
Tracking #10447115 delivered
2609 - Voth -- 2026-03-27
Tracking #10074868 delivered
2609 - Voth -- 2026-03-27
2659 - Gowans Pre-Production 15 to order
6/27 ready
2648 - Arai Pre-Production
0/23 ready
2654 - Koniniec Service 3 ordered
36/44 ready
Data from Airtable as of 9:06 PM