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
2 Pre-Production jobs without a Purchase Request marked ready:
2638 - Martin 2654 - Koniniec
Pending Items
Not Started
51
Awaiting review
Needs Ordering
20
Confirmed not in shop
Ordered
0
Waiting on delivery
Other Items
Total Items
388
Pulled
151
In project totes
Received
49
At the shop
Recent Activity
Hafele Axilo Adjustment Foot - 4" Toe marked Received
2647 - Quill -- 2026-07-21
Outlet Grommet - SIngle - White marked Received
2647 - Quill -- 2026-07-21
Proslat - 12-Piece Sports Hook Kit marked Received
2647 - Quill -- 2026-07-21
Proslat - Stealth Slatwall Gardener Kit marked Received
2647 - Quill -- 2026-07-21
Proslat - Stealth Slatwall Ultimate Bundle Kit marked Received
2647 - Quill -- 2026-07-21
Proslat - 4' x 4' PVC Wall Panels and Trims (White) marked Received
2647 - Quill -- 2026-07-21
3/4 Tru North - Polar White marked Received
2647 - Quill -- 2026-07-21
Outlet Grommet - Double - White marked Received
2647 - Quill -- 2026-07-21
Proslat - 8' x 4' PVC Wall Panels and Trims (4-Pack White) marked Received
2647 - Quill -- 2026-07-21
Hafele Axilo Square Mounting Plate (Press Fit) marked Received
2647 - Quill -- 2026-07-21
1mm Tru North - Polar White marked Received
2647 - Quill -- 2026-07-21
Proslat - 2 x 96" PVC Slatwall H Trim (White) marked Received
2647 - Quill -- 2026-07-21
3/4 Tru North - Polar White marked Shipped
2652 - Thomas -- 2026-07-14
Wall hook - Double - Chrome marked Shipped
2652 - Thomas -- 2026-07-14
Titus Wedgefix - White marked Shipped
2652 - Thomas -- 2026-07-14
Tracking #11255179 delivered
2607 - Martin -- 2026-03-20
Tracking #11260341 delivered
2607 - 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
2655 - Loewen Pre-Production
0/19 ready
Data from Airtable as of 10:07 PM