Reorder-Point & Vendor PO Drafter

The problem this kills

Your parts are scattered. Some live on Van 7, some on Van 12, some in the warehouse bin, and the reorder points live in a spreadsheet that one person updates "when they get a chance." So every week the same thing happens: a tech runs out of a $4 fitting on a job, the truck rolls back empty, and the buyer finds out only after the customer complains.

When someone finally sits down to order, it's a manual slog: scroll the stock sheet, eyeball what looks low, remember which vendor sells it, remember that this vendor needs a $250 minimum and that part only comes in packs of 25, and then retype it all into the ERP. The same need gets ordered twice because two runs overlapped. Preferred vendors get skipped because nobody had the price and lead-time table handy.

This tool does the boring, error-prone part for you and then gets out of the way so a human can decide. It compares stock to reorder points, groups the shortfalls into clean per-vendor purchase orders that already respect minimum order quantities and pack sizes, and hands the buyer a tidy draft to approve.

What you'll build

A private internal web app for your purchasing/parts team:

• One stock picture across every van and the warehouse, imported from your sheet or ERP.
• An automatic shortfall roll-up: every part at or below its reorder point, with the suggested order quantity already rounded up to the vendor's pack size and minimum.
• Vendor grouping: shortfalls bundled into one draft PO per vendor, with the preferred vendor chosen by your rule (lowest price, or shortest lead time).
• A buyer approval gate: nothing is "sent" until a buyer opens the draft, edits quantities if needed, and clicks Approve.
• A duplicate guard so a part you already ordered this week isn't ordered again on the next run.
• A clean CSV export in exactly the columns your ERP's PO import expects.

What's inside the Implementation Plan

• It starts by interviewing you. Before it writes a single line of code, the plan makes the AI agent ask about your parts, your vendors, your van/warehouse layout, and your approval rules - then it reflects a short spec back and waits for your thumbs-up. You get a tool tailored to your business, not a generic template you have to bend yourself into.
• A step-by-step build, each step ending in a ready-to-paste prompt - no coding knowledge needed.
• The exact data model for parts, stock-by-location, vendors, vendor-catalog entries, and POs.
• The reorder math (shortfall, round up to pack size, enforce minimum order quantity) spelled out.
• The vendor-selection rule (preferred by price or lead time) wired in.
• A "No API yet?" fallback so you can build the whole thing today from spreadsheets.

The governance it includes (this is the point)

• Login so only your team can open the tool.
• Row-level security so each company only ever sees its own parts, vendors, and POs.
• A full audit trail - who drafted, who edited, who approved, and exactly when.
• A hard human-in-the-loop approval gate: the AI drafts the PO, a buyer reviews and approves, and only an approved PO can be sent or exported. Nothing reaches your system of record un-reviewed.
• Duplicate guards so the same shortfall can't be turned into two orders across overlapping runs.

Who it's for

Purchasing and parts coordinators, and the operations managers who own truck stock and warehouse inventory in field-service businesses (HVAC, plumbing, electrical, appliance repair, low-voltage). If you're the person who keeps the vans stocked and dreads PO day, this is for you.

You've got this - paste the first prompt and let the agent interview you.