Create Bosta shipping orders from Odoo invoices using OpenAI GPT models

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 1. 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". 2. 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. 3. Product Mapping - Open the Summarize Items code node and update the NAMEMAP object to link your Odoo product names to short shipping labels. 4. 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