How to Import Supplier Order Confirmations into Odoo Automatically
Update purchase order prices, quantities, and delivery dates in Odoo — without retyping a single supplier PDF
Every purchase order you send comes back as a confirmation email: a PDF, an Excel sheet, sometimes just a few lines of text. Someone on your team opens each one, compares it line by line against the PO in Odoo, and updates prices, quantities, and delivery dates by hand. This guide shows why that manual loop breaks down, what the usual workarounds miss, and how Supplier2ERP imports supplier confirmations into Odoo automatically — with your tolerance rules deciding what gets updated and what gets flagged.
💸 What Manual Confirmation Entry Really Costs
A supplier order confirmation looks harmless — until you multiply it by every PO you send. Each confirmation has to be opened, read, and compared against the purchase order in Odoo. Did the supplier confirm the full quantity? Did the unit price change? Did the delivery date slip by two weeks? Every answer means clicks and retyping in the Purchase app.
The damage of skipping that work is worse than the work itself. When confirmations are not entered, Odoo quietly shows the wrong picture:
- Wrong incoming dates: Odoo still expects goods on the original date, so your scheduled receipts, sales promises, and replenishment planning are built on stale data.
- Wrong prices: the vendor bill arrives and does not match the PO, so accounting chases purchasing for an explanation weeks after anyone remembers the order.
- Silent short shipments: the supplier confirmed 60 of 100 units, nobody updated the line, and the stockout surfaces only when a customer order cannot ship.
- Hours of skilled time lost: procurement people spend their day copying numbers between a PDF and a browser tab instead of negotiating or solving supply problems.
The task is pure comparison and data entry — exactly the kind of work software should do, and exactly the kind of work people do worst when bored.
🔧 The Ways Teams Usually Try to Solve It
1. Keep doing it manually
Works at five POs a week. At fifty, confirmations pile up unread, and the ones that get entered are entered in a hurry. Manual comparison is also where transposed digits and skipped lines are born.
2. The built-in Odoo email gateway
Odoo’s incoming mail gateway is great at attaching an email to a record — it can log the confirmation in the chatter of a purchase order. But it does not read the PDF, does not compare confirmed values against your PO lines, and does not update quantities, prices, or dates. The document is filed; the work remains.
3. Generic OCR tools and Zapier-style connectors
Template-based OCR tools can extract fields from a document — after you build and maintain a template per supplier layout. Suppliers change their formats without warning, and a connector that extracts text still cannot answer the real question: does this match my open PO in Odoo, and is the difference within tolerance? Extraction without ERP-aware matching just moves the manual comparison one step downstream.
4. Custom scripts
A developer can script the happy path for your top three suppliers. Then supplier number four sends a scanned image, the layout changes, the developer leaves, and the script becomes one more thing nobody dares touch.
🤖 The Automated Way: Supplier2ERP
Supplier2ERP is a BOTS4.me bot that watches your mailbox, reads supplier confirmations in any format, matches them to open purchase orders in Odoo, and updates quantities, prices, and delivery dates according to tolerance rules you set.
Supplier confirmation arrives
Data extracted from PDF, Excel, Word, or scan
Matched to your open PO
Odoo PO updated within tolerance
Report emailed, differences flagged
🧠 Three-tier extraction — rules first, AI as backup
Tier 1 — Code anchoring: Supplier2ERP looks for your own product codes from the Odoo item catalog inside the supplier document. No templates, works with any layout from day one.
Tier 2 — Learned patterns: once a supplier’s format has been processed, its extraction rules are saved. Future confirmations from the same supplier process instantly.
Tier 3 — AI fallback: only when rules and learned patterns are not enough does AI extract and verify the data — including scanned images via OCR.
Set it up in about five minutes
- Step 1 — Register: create an account at bots4.me/bots and add the Supplier2ERP app. First month free, cancel anytime.
- Step 2 — Connect your mailbox: use secure Quick Connect (OAuth for Gmail, Office 365; any IMAP provider supported). No middleware, no forwarding rules.
- Step 3 — Connect Odoo: install the free BOTS4.me Connect module (Odoo 13–19). Odoo Online users add a zero-code XML helper and paste an API key from Settings → Users → Account Security; Odoo.sh and on-premise get the one-click Python connector. One connector serves all eleven BOTS4.me apps.
- Step 4 — Set your tolerances: choose how much a confirmed price or quantity may differ from the PO before it is flagged instead of auto-accepted, and which suppliers to process.
- Step 5 — Start in Demo Mode: the bot processes real confirmations and reports exactly what it would update — writing nothing. Move to read-only Preview, then full automation when the reports earn your trust.
📅 What Day-to-Day Operation Looks Like
Once live, Supplier2ERP runs on the schedule you choose — from every 15 minutes to weekly, within operating hours you define. Each run works through new supplier emails and attachments:
- Within tolerance: confirmed quantities, unit prices, and delivery dates are written to the matching PO lines in Odoo, and the processed email is filed into
_Supplier2ERP/PROCESSED. - Outside tolerance: large differences are flagged in your report and the email stays unread in your INBOX — the PO is left untouched until you review it. Nothing gets buried in a hidden folder.
- Full transparency: after every run you receive a difference report — what was extracted, what matched, what changed, what was skipped and why. The dashboard’s Logs tab keeps the complete decision history.
- Full control: Bot Power on/off, per-feature toggles, AI Mode from Off to Ultra, all in the Control tab at bots4.me/bots. EU-hosted, GDPR-native, 2FA, interface in 31 languages.
🔄 The Missing Piece of the Odoo Inventory Loop
Supplier2ERP closes a loop that two sibling bots open. AutoSTOCK computes optimal stock targets from your real sales history and writes them as native Odoo reordering rules. AutoPURCHASE turns those targets into draft purchase orders, grouped per vendor with minimums respected. When your suppliers confirm those orders, Supplier2ERP reads the confirmations and keeps every PO honest — confirmed prices, quantities, and dates land back in Odoo automatically.
Together the three bots take you from “how much should we stock?” to “the goods are confirmed and Odoo knows it” with almost no manual procurement work.
🌍 Works Beyond Odoo
This guide focuses on Odoo (versions 13–19, including Odoo Online, Odoo.sh, and on-premise), but Supplier2ERP ships optimized adapters for other systems too: SAP Business One, Oracle NetSuite, QuickBooks, Xero, and Offeris — each with its own update strategy (batch updates, PO rewrites, or individual line updates). Using something else? Contact us — integrations are added regularly.
❓ Frequently Asked Questions
Can Odoo update purchase orders from supplier confirmation emails automatically?
Not out of the box. Odoo’s email gateway can attach a confirmation to a PO’s chatter, but it does not read the document or change PO lines. Supplier2ERP adds that layer: it extracts confirmed quantities, prices, and delivery dates from the email or attachment, matches them to the open purchase order, and updates Odoo within tolerance rules you define.
How does Supplier2ERP read supplier PDFs without templates?
Through code anchoring: it searches the document for your own product codes taken from your Odoo item catalog, so any supplier layout works from day one. After a supplier’s format is processed once, extraction patterns are saved and reused. Only when both fail does AI step in as a fallback — including OCR for scans and images.
What happens when the confirmed price or quantity differs from my PO?
You set tolerance thresholds. Small differences can be auto-accepted and written to the PO. Large differences are flagged in your report, the PO update is skipped, and the supplier email stays unread in your INBOX so the pending review is impossible to miss.
Does it handle scanned confirmations and images?
Yes. Supplier2ERP processes PDF, Word, Excel, HTML, plain email body text, and images via OCR — so a photographed or scanned confirmation is read just like a digital one.
Can I test it without letting it write anything to Odoo?
Yes. Start in Demo Mode with no ERP access at all, then move to Preview mode, where the bot reads your POs and reports exactly what it would change — while writing nothing. You enable full automation only when you are confident. The first month is free and you can cancel anytime.
Which Odoo versions and hosting types are supported?
Odoo 13 through 19. Odoo.sh and on-premise installations use the free one-click BOTS4.me Connect Python module; Odoo Online (which forbids custom Python) uses a zero-code XML helper module plus an API key created in Settings → Users → Account Security. One connector serves all eleven BOTS4.me apps.
Does Supplier2ERP work with ERPs other than Odoo?
Yes — SAP Business One, Oracle NetSuite, QuickBooks, Xero, and Offeris are supported, each with an optimized purchase order update strategy. New integrations are added regularly.
📚 Related Guides
- Hub: How to Automate Odoo End-to-End: From Email Order to Paid Invoice
- Step before this one: How to Automate Purchasing in Odoo: Draft POs from Real Needs
- Where the targets come from: How to Set Optimal Reorder Points in Odoo from Real Sales History
- The sales side of your mailbox: How to Import Email Orders and RFQs into Odoo Automatically
- Connector setup: How to Connect Odoo to BOTS4.me (Odoo 13–19)
Stop Retyping Supplier Confirmations
Connect your mailbox and Odoo in about five minutes, watch Supplier2ERP work in Demo Mode, and go live when the reports convince you. First month free, cancel anytime.