Odoo and Telegram integration

Overview This template connects Telegram with Odoo to let your sales team create sales quotes and check product availability in real-time — just by sending chat messages. It’s designed for sales representatives, distributors, and small business owners who want to manage quotes and product information quickly without logging into Odoo. ⚙️ How It Works Once configured, this workflow listens to your Telegram bot for incoming messages. Based on the message text, it performs different actions in Odoo: Product Queries Sales reps can ask about products directly in Telegram: “What’s the price of Product B?” “How many units of Product A are available?” The workflow fetches real-time data from Odoo and replies instantly. Sales Quote Creation Sales reps can also create new sales quotes by typing messages like: “My customer Amazon, his email address is [email protected] wants to buy 10 pcs of Product A and 15 pcs of Product B.” The workflow extracts relevant details, creates a sales quote in Odoo, and sends confirmation back in Telegram. 🧰 Setup Instructions Create a Telegram Bot Go to @BotFather on Telegram. Create a new bot and copy the API Token. Prepare Odoo Enable the Sales and Product modules. Generate an API Key from your Odoo user account. Note your Odoo URL (e.g., https://yourcompany.odoo.com). Import Workflow Open your n8n instance (self-hosted or cloud). Click Import Workflow and upload the provided JSON file. Add Credentials Configure your Telegram credentials (Bot Token). Configure your Odoo credentials (Base URL + API Key). Activate the Workflow Set the workflow to active to start listening for Telegram messages. Send a sample message to your bot to test. 🧠 Use Cases Sales reps capturing orders in the field SMEs managing customer inquiries directly from Telegram Real-time price and stock lookups without opening Odoo Automation of repetitive sales quote tasks 🎛️ Customization Options This workflow can be easily adapted to your business needs: Change trigger platform: Replace Telegram with WhatsApp, Slack, or Discord using the respective n8n nodes. Extend data fields: Add fields like delivery date, salesperson, or payment terms. Auto-confirm orders: Add a node to automatically confirm a Sales Quote once approved. ✅ Requirements Odoo v14 or later (with Sales module enabled) Telegram Bot Token n8n instance (Cloud or self-hosted) 💬 Example Prompts Product Query: “What’s the price of Product B?” “How many units of Product A are available?” Order Entry: “My customer Amazon, his email address is [email protected] wants to buy 10 pcs of Product A and 15 pcs of Product B.”

What Problem Does It Solve? Manual Data Entry Bottlenecks:** Moving shipping data from Odoo to Bosta manually is slow and prone to errors, especially during high-volume periods. Address Mismatches:** Odoo stores addresses as unstructured text, while Bosta requires strict Zone/District IDs. Mismatches lead to failed deliveries and returns. Messy Labels:** Long ERP product names look unprofessional on shipping labels. This workflow solves these by:** Instantly creating the shipping order in Bosta when an Odoo invoice is confirmed. Using an AI Agent to intelligently parse raw addresses and map them to the exact Bosta ID. Ensuring the high operational standards required by automating data cleaning and COD rounding. How to Configure It Odoo Setup Create an Automation Rule in Odoo that sends a POST request to this workflow's Webhook URL when an invoice state changes to "Confirmed". Credentials Connect your Odoo, OpenAI, and Telegram accounts in the respective n8n nodes. Add your Bosta API Key in the Header parameters of the Create Bosta Order node. Product Mapping Open the Summarize Items code node and update the NAME_MAP object to link your Odoo product names to short shipping labels. Data Table Ensure the Fetch Zones node is connected to your Bosta Zones/Districts data table in n8n. How It Works Trigger:** The workflow starts automatically when an invoice is confirmed in Odoo. Fetch & Process:** It pulls customer details and invoice items, then aggregates quantities (e.g., turning 3 lines of "Shampoo" into "Shampoo (3)"). AI Analysis:** The AI Agent cross-references the raw address with the official Bosta zones list to strictly select the correct IDs. Execution:** The order is created in Bosta. If successful, the process is complete. Error Handling:* If any step fails, a Telegram message is sent immediately with the invoice number to alert the operations team*. Customization Ideas Write Back:** Add a node to update the Odoo invoice with the generated Bosta tracking number. Multi-Courier:** Add a switch node to route orders to different couriers (e.g., Aramex, Mylerz) based on the city. Campaign Logging:** Log successful shipments to a spreadsheet to track fulfillment metrics. Notification Channels:** Change the error alert from Telegram to Slack or Email. If you need any help Get in Touch