Shopify and Odoo Full Sales Synchronization - n8n Workflow

E-commerce businesses running Shopify and using Odoo as their primary ERP system.
Developers and system administrators needing reliable, real-time synchronization between disparate systems.
Users seeking advanced n8n templates to handle complex transactional logic, filtering, and data transformation.
Automation specialists looking for a high-performance n8n workflow to maintain data integrity across platforms.

Maintaining consistency between your e-commerce platform (Shopify) and your backend ERP/CRM (Odoo) is critical for inventory management and accounting. Manual data entry is time-consuming and prone to errors. This comprehensive n8n workflow solves this synchronization challenge by providing a robust, real-time integration layer. When a new order is placed in Shopify, this n8n automation simultaneously checks and updates the customer record, the products involved, and finally, creates the complete sales order in Odoo, including line items. Utilizing specialized n8n node configurations for Odoo, this solution ensures that your sales operation is fully automated from storefront checkout to backend fulfillment.

This highly transactional n8n workflow operates in three parallel synchronized paths immediately after receiving a signal from the Shopify n8n trigger, ensuring all related data (Contact, Product, Order) is processed efficiently.

1. The n8n Trigger and Initial Data Capture: The process begins with the Shopify Trigger, configured as an n8n webhook, which activates upon a specific Shopify event (typically a new order). The payload is split immediately to handle three parallel synchronization tasks.


2. Contact Synchronization (Path 1): The workflow first attempts to find the customer associated with the order using the Search Odoo Contact n8n node. A subsequent Code4 n8n node prepares the data, and a Filter n8n node determines if the contact already exists. If not found, the Odoo5 n8n node creates the new contact record in Odoo.


3. Product Synchronization (Path 2): To ensure every ordered item exists in Odoo before creating the sale order lines, the workflow extracts all line items using the Code6 n8n node and processes them one by one via Split Out4. The Odoo6 n8n node searches for the product, and if needed, the data is mapped via Code5 and filtered via Filter2 before the Odoo7 n8n node creates or updates the product record in Odoo.


4. Order Header and Line Item Creation (Path 3): Once products and contacts are verified, the main order path proceeds. The Odoo n8n node ensures the order doesn't already exist. The Sale Order1 n8n node creates the main sale order header in Odoo. Finally, the order line items are prepared by Code3, split using Split Out3, and then created as line items attached to the newly created order header via the Odoo4 and Sale Order Line1 n8n nodes. This complete n8n workflow ensures a flawless transition of sales data.

To deploy this powerful n8n workflow, follow these steps:

1. Import: Download the provided JSON file and import it directly into your n8n instance.


2. Credentials Setup: You must configure credentials for both services.

1. Webhook Activation: After importing and setting credentials, activate the Shopify Trigger n8n node. n8n will provide a unique webhook URL. You must copy this URL and register it within your Shopify store settings (under Notifications or Webhooks) for the appropriate event (e.g., 'Order Created').


2. Review Mappings: Examine the Code n8n node steps (Code4, Code6, Code5, Code3) to ensure the data mapping (e.g., field names for customer addresses, product SKUs, and price formats) matches the specific setup of your Odoo installation. These n8n templates are designed to be highly adaptable.

This n8n workflow relies on several core nodes and service-specific integrations:

Shopify Trigger: The essential starting point, this n8n trigger is configured to listen for webhook events from Shopify, initiating the entire synchronization process.
Odoo (Multiple Instances): The backbone of the integration. Multiple Odoo n8n node instances are used for specific operations:
Search Odoo Contact: Searches for existing customer records based on Shopify data.
Odoo5: Creates new customer contacts (res.partner) if they don't exist.
Odoo6 / Odoo7: Searches, creates, or updates product templates (product.template).
Sale Order1: Creates the main sales order header (sale.order).
Sale Order Line1: Creates the line items associated with the sales order (sale.order.line).
Code (Code3, Code4, Code5, Code6): Critical for data hygiene and transformation. These n8n node components contain custom JavaScript to normalize the complex nested Shopify JSON structure (e.g., line items, addresses) into the flat structure required by the Odoo API.
Split Out (Split Out3, Split Out4): Used to take arrays of data (like order line items) and process each item sequentially. This ensures that every product or line item gets checked or created individually before proceeding to the next step in the n8n automation.
Filter (Filter, Filter2): These logic n8n node steps check the results of the preceding search steps (e.g., checking if the Odoo search returned a record ID) to conditionally branch the workflow—either updating an existing record or creating a new one.