Wholesale order intake from emailed PDFs into draft orders
Read wholesale purchase orders sent as PDF attachments and turn them into draft orders with flagged lines for a person to confirm.
The use case
Wholesale buyers often email purchase orders as PDFs with their own item codes, quantities, and requested ship dates. Someone retypes each line into the store or order system, which is slow and easy to get wrong. This agent watches a dedicated inbox, reads each PDF, maps the buyer's item codes to your SKUs using a reference table, and builds a draft order with pricing from the buyer's agreed price list. Lines it cannot match, quantities outside case packs, or prices that differ from the agreement are flagged. A sales or operations person checks the draft and confirms the order before it moves forward.
Example workflow
- A wholesale buyer emails a purchase order to a dedicated address, and a filter routes it to the workflow.
- The agent extracts buyer name, PO number, line items, quantities, requested dates, and ship-to address from the PDF.
- It maps buyer item codes to your SKUs using a cross-reference sheet and pulls the buyer's agreed pricing.
- Unmatched codes, odd quantities, price differences, and missing details are flagged at the top of a review summary.
- An operations person compares the draft with the original PDF, resolves flags, and creates or confirms the draft order in Shopify.
- A confirmation reply to the buyer is drafted for the person to send, and the PO is logged with its status.
Tools
- Gmail
- Claude
- Google Sheets
- Shopify
- Zapier or Make
- QuickBooks
Risks and guardrails
- Scanned or poorly formatted PDFs may be misread — guardrail: the review summary shows the original PDF beside the extracted lines and low-confidence fields are highlighted.
- A wrong SKU mapping could ship the wrong product — guardrail: only mappings in the approved cross-reference table are used and new codes always require a person.
- Pricing errors affect margins and invoices — guardrail: any price that differs from the agreed list is flagged and never silently accepted.
- Duplicate POs could create double orders — guardrail: the log checks PO numbers per buyer and warns before a second draft is built.
Related recipe
B2B Invoice AR Reminder Agent with Approval Gate: An agent reads open invoices from QuickBooks or Xero, skips blocked accounts, and drafts tiered payment reminders in Gmail that a person approves one by one before anything is sent.
Want it set up for you? Request a quote.
Sources
Written by Agents Lookup. Credits and official pages for the tools this use case names:
- Gmail (official page): developers.google.com/workspace/gmail (checked 2026-11-19)
- Claude (official page): claude.ai (checked 2026-11-09)
- Shopify Dev MCP server (AI Toolkit) (official page): shopify.dev/docs/apps/build/ai-toolkit (checked 2026-11-09)
- Zapier MCP (official page): zapier.com/mcp (checked 2026-11-09)
- Make MCP server (official page): developers.make.com/mcp-server (checked 2026-11-09)