Odoo
3 sonuç — tümü kaynağa bağlı n8n referansı
Fetch Odoo Customer Data and Export to JSON or Excel
Odoo Customers API – Export to JSON or Excel Odoo Customers API – Export to JSON or Excel provides a simple way to fetch customer records from your Odoo database and get them back either as a structured JSON response or a downloadable Excel (.xlsx) file. ⚙️ What it does Listens for HTTP GET requests on the endpoint /api/v1/get-customers. Checks for the required name parameter and builds a search filter automatically. Queries the res.partner model to return only customer contacts (is_company = false). Delivers results in JSON by default, or as an Excel (.xlsx) export when response_format=excel is included. 📥 Parameters name — Required. Used for partial matching on customer names (via Odoo’s Like filter). response_format — Optional. Accepts json (default) or excel. 🔗 Examples Excel Example GET /api/v1/get-customers?name=Demo&response_format=excel JSON Example GET /api/v1/get-customers?name=Demo&response_format=json 🧩 Default fields display_name, name, email, phone, mobile, parent_id, company_id, country_code, country_id 🛠️ Setup Open the Odoo node and connect your Odoo API credentials. Adjust the fieldsList in the node if you want to include more data fields (e.g., address, city,
Sync New Shopify Products to Odoo Products
Seamlessly sync newly created Shopify products into Odoo with this smart, no-code n8n workflow. Automatically checks for duplicates and creates new products only when needed – fully compatible with standard Odoo setup. 🚀 Key Features: Trigger-based Automation: Starts instantly when a new product is created in Shopify Duplicate Check: Searches for an existing product in Odoo using Shopify’s product SKU as the Internal Reference (Default Code) Smart Condition Logic: If a matching product is found, the workflow stops – preventing duplicates If not found, a new product is created in Odoo Auto-Creation of Odoo Product using Shopify data: Product Name Description Price Internal Reference (SKU) Works with both Odoo Community and Enterprise editions Fully customizable and extendable in n8n No coding, no custom modules required 🛠 Requirements: n8n (self-hosted or cloud) Shopify API access Odoo instance with standard API access 💡 A perfect solution for businesses that regularly add new products to Shopify and want them mirrored in Odoo – automatically and without manual effort. +++++++++++++++++++++++++++++++++++++++++ Workflow functions like the integration of a Shopify product with an O
Sync New Shopify Customers to Odoo Contacts
This workflow functions by integrating Shopify customers into Odoo customers. Trigger: Shopify – New Customer Created The workflow starts when a new customer is added in Shopify. Action: Odoo – Search Contact by Email It checks in Odoo to see if a contact already exists with the same email address as the Shopify customer. Condition: Email Match Check If a contact with the same email is found, the workflow ends (no duplicate contact is created). If no match is found, the workflow proceeds to the next step. Action: Odoo – Create New Contact A new contact is created in Odoo using the customer's: Full name Email address Phone number Full Address (whichever is available)