{"product_id":"odoo-low-stock-reorder-vendor-bill-approvals-via-n8n","title":"Odoo Low-Stock Reorder + Vendor Bill Approvals via n8n","description":"\u003ch3\u003eAutomate Odoo low-stock reorders and get vendor bills approved via Slack—with n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks Odoo for low-stock items, drafts purchase orders, and emails vendors through Gmail. It also turns incoming “vendor bill”\/“invoice” emails into draft vendor bills in Odoo, then sends them to Slack for approval before posting.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 8:00 AM\u003c\/strong\u003e to fetch product records from Odoo and identify items below your configured stock threshold.\u003c\/li\u003e\n  \u003cli\u003eIf low-stock products are found, it \u003cstrong\u003elooks up the preferred vendor\u003c\/strong\u003e and vendor contact details in Odoo for each product.\u003c\/li\u003e\n  \u003cli\u003eIt then \u003cstrong\u003ecreates a draft purchase order\u003c\/strong\u003e in Odoo using a \u003cstrong\u003efixed reorder quantity of 20 units\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eNext, the workflow \u003cstrong\u003eemails the draft PO details to the vendor\u003c\/strong\u003e via Gmail.\u003c\/li\u003e\n  \u003cli\u003eIt posts to \u003cstrong\u003eSlack\u003c\/strong\u003e (in \u003cstrong\u003e#procurement\u003c\/strong\u003e) with the drafted PO information—or posts a “no reorder needed” update if nothing is low.\u003c\/li\u003e\n  \u003cli\u003eSeparately, it \u003cstrong\u003epolls Gmail every 5 minutes\u003c\/strong\u003e for unread emails with subjects matching \u003cem\u003e“vendor bill”\u003c\/em\u003e or \u003cem\u003e“invoice”\u003c\/em\u003e, extracting vendor name, amount, and reference from the subject line.\u003c\/li\u003e\n  \u003cli\u003eIf the vendor matches an \u003cstrong\u003eOdoo partner\u003c\/strong\u003e, it \u003cstrong\u003ecreates a draft vendor bill\u003c\/strong\u003e in Odoo and sends a \u003cstrong\u003eSlack approval request\u003c\/strong\u003e to \u003cstrong\u003e#finance-approvals\u003c\/strong\u003e that \u003cstrong\u003epauses until approved or declined\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eWhen approved, it \u003cstrong\u003eposts the vendor bill in Odoo\u003c\/strong\u003e. If declined—or if the vendor is not recognized—it \u003cstrong\u003eemails the submitter via Gmail\u003c\/strong\u003e with next steps.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep purchasing responsive by automatically reordering when stock drops below threshold.\u003c\/li\u003e\n  \u003cli\u003eStandardize vendor bill intake by capturing key details from subject lines and creating draft bills in Odoo.\u003c\/li\u003e\n  \u003cli\u003eEnforce finance governance with Slack-based approvals before bills are posted.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOdoo\u003c\/strong\u003e node: read products\/vendors; create \u003ccode\u003epurchase.order\u003c\/code\u003e and draft\/post vendor bills via \u003ccode\u003eaccount.move\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e node: send draft PO emails and poll for unread bill\/invoice messages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e node: notify procurement and request finance approvals in \u003ccode\u003e#procurement\u003c\/code\u003e and \u003ccode\u003e#finance-approvals\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic built with nodes like \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and supports clarity via `sticky note`.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e add an Odoo API credential with permissions to read products\/vendors and create purchase orders and vendor bills.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45814429155507,"sku":"N8N-17992","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fr6Lz6B1zr9-vKfJ6aQ9a_K72a0BFu.png?v=1786439714","url":"https:\/\/buyflowscripts.com\/products\/odoo-low-stock-reorder-vendor-bill-approvals-via-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}