PO Builder from Reorder Suggestions

The problem this kills

You have a reorder report. It tells you what's running low and roughly how much to buy. But turning that list into actual purchase orders is the slow, error-prone part: you sort by supplier, bump quantities up to each vendor's minimum order, round to full case packs, check whether one more case tips you into a better price break, confirm you're buying from the preferred vendor for that item, and then build a separate PO for each supplier - by hand, in a spreadsheet, every cycle.

Get it wrong and you under-order (another stockout), over-order (cash tied up in dead stock), miss a price break you'd already earned, or - worst of all - issue a duplicate PO for something you already ordered last week. This plan kills all of that. It takes your approved reorder list and does the grouping and math for you, every time, the same way.

What you'll build

A small, private web app for your purchasing team that:

• Imports your approved reorder list from a CSV or Google Sheet.
• Looks up each item's supplier, MOQ, case-pack size, price breaks, lead time, and preferred-vendor rule.
• Groups the items into one draft PO per supplier and applies the math: round up to full case packs, lift to MOQ, and nudge quantities to hit the next price break when it clearly pays off.
• Shows each drafted PO to a buyer with line-by-line quantities, prices, and terms.
• Holds everything at "draft" until a human approves - then issues the PO, emails it to the vendor, and exports a CSV/PDF copy.
• Refuses to issue a duplicate PO for the same need in the same reorder cycle.
• Records who did what and when.

What's inside the Implementation Plan

The plan is a single file you paste into an AI coding agent (Claude Code). It builds the whole tool with you, step by step.

The best part: it opens by interviewing you about your business. Before writing any code, the plan has the agent ask about your real reorder process, the exact columns and SKU/vendor codes in your data, how your suppliers' MOQs and price breaks actually work, your typical and peak order volumes, and your messy edge cases (split shipments, sub-vendors, manual overrides). It reads a short tailored spec back to you, you confirm it, and only then does it build - so you get a tool shaped around your purchasing rules, not a generic template you have to fight.

Inside you'll find: a clear definition of done, the account setup, the full discovery interview, the data model, each build step with a ready-to-paste prompt, a verification checklist, and a no-integration fallback so you can ship it today even if your ERP has no API.

The governance it includes (this is the point)

This isn't a script that fires off orders. It's built like a real purchasing system:

• Login so only your team can use it.
• Row-level security so each organization only ever sees its own data.
• A hard human approval gate - the AI drafts every PO, a buyer reviews quantities, price, and terms, and nothing is issued or emailed until a person approves.
• Duplicate guards that dedupe on supplier + item + reorder cycle, so the same need can't become two POs.
• A complete audit trail - who imported, who edited, who approved, who issued, and exactly when.

Who it's for

Buyers, purchasing clerks, and inventory planners who already run a reorder report and are tired of hand-building POs. If you can use a spreadsheet, you can build and run this - no coding background needed.

You've got this. Paste the first prompt and let the interview tailor it to your business.