Business ops

100 Ordered, 80 Confirmed: An n8n Workflow Checks Supplier Confirmations Against the Purchase Order Line by Line

  • Level Advanced
  • Setup1–3 hrs (estimated)
  • Evidence Anecdotal
  • CostNot stated in source
  • No-codeNo
n8nSource-linkedNeeds verification

What they did

When a supplier confirmation has dozens of lines, checking each SKU, quantity, price and date against the purchase order takes ages, especially when suppliers count in packs or boxes. This n8n build takes an Excel confirmation uploaded to Slack, pulls the matching PO from ERPNext and compares every line, including pack conversions. It posts the result in the Slack thread, for example a 20-unit shortage when 100 were ordered and 80 confirmed, or ALL CHECKS PASSED.

How it went

Every supplier confirmation checked against the PO, with mismatches posted in Slack.

Worth knowing

  • The builder calls it an MVP demo, not a production system. The comparison uses fixed rules, not AI, which makes it predictable.

Prompt

Cleaned version rewritten from the source — not a direct quote.

When I upload a supplier confirmation to [channel], find the matching purchase order in [ERP]. Compare each line: SKU, quantity (convert packs or boxes to units), unit price and delivery date. Reply in the thread with every mismatch, like shortages or price changes, or 'all checks passed'.

Recommended

Try it in Grok Bot

Grok Bot can compare a supplier confirmation to your PO and list every mismatch.

  1. Copy the prompt (button below).
  2. Open Grok Bot chat and paste it. Replace any [bracketed] placeholders.
  3. Connect the listed tools (Slack) as connectors when Grok Bot asks.
  4. If the task repeats, ask: "Make this a daily routine."

Alternatives: the same prompt works in n8n, Claude, ChatGPT Agent, OpenClaw.

Set it up

Tools: Slack · Stack: n8n + ERPNext API + Slack + Excel

  1. Read the original source for full context.
  2. Connect the tools your agent needs.
  3. Paste the prompt and replace [bracketed] placeholders.
  4. Run once manually and check the output before scheduling it.

Generic suggested steps, not from the source.

Evidence

n8n community post: Excel via Slack, ERPNext PO lookup, SKU/qty with pack conversion/price/date checks, 100 vs 80 example, error handling, MVP

Source: Web · 2026-10-22 · Verified by us: not yet · Report broken or outdated

Related use cases

Inbox & communicationReddit

6-class email router for a 22-person consultancy

An IMAP trigger feeds an OpenAI classifier that routes 80–120 emails a day to Slack, Pipedrive and Zendesk. It hit 94% accuracy on 500 emails and saves 11 hours a week.

  • Level Intermediate
  • Setup1–3 hrs*
  • Evidence Some evidence
n8nSource-linked
MoneyReddit

Invoice capture for a distributor: 4m12s down to 38s each

A shared Gmail label feeds an extractor, totals are validated to €0.01, low-confidence fields go to a human, and results push to Sage. 87% need no human touch.

  • Level Intermediate
  • Setup1–3 hrs*
  • Evidence Some evidence
n8nMakeSource-linkedNeeds verification