Sync New E-commerce Products to ERP - n8n Workflow

E-commerce managers needing real-time inventory and product data synchronization.
Businesses utilizing both Shopify for sales and Odoo for ERP/backend management.
Automation specialists looking for practical n8n templates for integration between specialized systems.
Users seeking to implement robust conditional logic within an n8n workflow.

Maintaining consistency between e-commerce product catalogs (like Shopify) and enterprise resource planning systems (like Odoo) is critical. Manually updating these systems leads to errors and delays. This expert n8n workflow template solves this by providing instant, automated synchronization whenever a new product is added to Shopify. The key value of this specific n8n workflow is the built-in duplicate detection mechanism, utilizing an Odoo n8n node to search Odoo before attempting creation, ensuring data integrity across your platforms. This logic makes it one of the most reliable n8n templates available for retail operations, drastically reducing manual data entry and preventing costly synchronization errors within your n8n environment.

The process starts with the n8n trigger listening for specific product creation events on Shopify.

1. Shopify Detection: The dedicated Shopify n8n trigger instantly detects a new product creation event and pulls the full product payload into the n8n workflow.


2. Odoo Search: The flow immediately passes the new product data to the 'Search for Existing Product in Odoo' n8n node. This node executes a search query (typically based on SKU or unique title) to determine if the product already exists in the Odoo database.


3. Conditional Check: An 'Is Product Found?' If n8n node evaluates the search result. If the Odoo search returned zero matching records, the conditional logic determines the product is new and continues the n8n workflow.


4. Creation or Stop: If the product is truly new, the data proceeds to the 'Create Odoo Product' n8n node, successfully registering the item in Odoo. If the product was found (duplicate), the flow routes to the 'Stop - Duplicate Found' NoOp n8n node, terminating the n8n workflow execution gracefully. This precise logic ensures efficient use of your n8n platform and prevents unnecessary data duplication.

To deploy this powerful n8n workflow, follow these steps:

1. Import: Copy the provided n8n JSON data and import it directly into your n8n instance via the 'Workflows' section using the 'New' -> 'Import from JSON' option.


2. Shopify Configuration: Click on the 'Shopify Trigger' n8n node. Configure your Shopify credential and select the appropriate resource (Product) and operation (Created). Ensure the webhook URL provided by this n8n trigger is correctly set up in your Shopify admin panel.


3. Odoo Credentials: Update both the 'Search for Existing Product in Odoo' and 'Create Odoo Product' n8n node components. You must input your Odoo connection details (URL, API key, database name) in the credential setup for the Odoo n8n node.


4. Mapping: Verify that the field mappings in the 'Create Odoo Product' n8n node correctly translate the Shopify data structure into the required Odoo fields.


5. Activation: After configuring all n8n node credentials and parameters, activate the n8n workflow to enable real-time synchronization. Explore other n8n templates for similar business process automation.

This n8n workflow utilizes several specialized nodes to achieve reliable synchronization:

Shopify Trigger (n8n trigger):
Function: Acts as the starting n8n trigger, initiating the entire n8n workflow whenever a new product is created in your Shopify store.
Key Configuration: Set up to listen for Product creation events. Requires proper webhook registration setup within the Shopify console.
Odoo (Search for Existing Product):
Function: Searches the Odoo database to verify if the incoming Shopify product already exists, a crucial step for data integrity in this n8n workflow.
Key Configuration: Resource set to Product, Operation set to Search, utilizing a filter based on the incoming product's unique identifier (e.g., SKU).
Is Product Found? (If n8n node):
Function: Controls the flow based on the preceding Odoo search result. Determines if the workflow should create a new product or stop.
Key Configuration: The condition checks the output of the Odoo search to determine if any matching records were returned.
Odoo (Create Odoo Product):
Function: Creates the new product record in Odoo, mapping necessary fields from the Shopify payload.
Key Configuration: Resource set to Product, Operation set to Create. Requires accurate data mapping.
Stop - Duplicate Found (NoOp n8n node):
Function: A clean terminal point for the n8n workflow path where a duplicate product was detected, conserving API resources.