Sync New Shopify Products to Odoo for Real-time Updates
detail.loadingPreview
Automatically update your Odoo ERP with product information from Shopify. This workflow listens for newly created products in Shopify and ensures corresponding product details are synchronized in Odoo if a match exists, helping maintain data consistency across your e-commerce and ERP systems.
About This Workflow
This powerful n8n workflow streamlines your product data synchronization between Shopify and Odoo. Designed to trigger whenever a new product is created in your Shopify store, it intelligently checks your Odoo ERP to determine if a matching product, identified by its Shopify product ID, already exists. If a corresponding product is found in Odoo, the workflow proceeds to update its critical details—including name, description, default code, and list price—with the latest information from Shopify. This ensures that your Odoo product catalog remains consistent and up-to-date for existing items that originate from Shopify, reducing manual data entry and preventing discrepancies in your integrated e-commerce and ERP systems.
Key Features
- Real-time Shopify Product Creation Monitoring: Automatically triggers the workflow upon new product creation events in Shopify.
- Intelligent Odoo Product Matching: Efficiently searches Odoo for existing products using the Shopify product ID as a unique identifier (
default_code). - Selective Odoo Product Updates: Updates key product fields in Odoo (name, description, price, default code) only if a matching product is found, preventing unintended data duplication or errors.
- Seamless E-commerce & ERP Data Synchronization: Ensures product information consistency between your storefront and backend management system.
- Customizable Data Mapping: Easily configure which Shopify product fields map to specific Odoo product fields.
How To Use
- Shopify Trigger Node: Configure this node to connect to your Shopify store using an Access Token. Select "products/create" as the topic to trigger the workflow whenever a new product is added.
- Odoo6 Node (Check Existing): Connect to your Odoo instance. Set the resource to "custom" and
customResourcetoproduct.product. Configure thefilterRequestto search for products wheredefault_codematches theproduct_idfrom the incoming Shopify data (e.g.,{{ $('Shopify Trigger').all()[0].json.variants[0].product_id }}). - Code Node: This node prepares the data for the next steps. It takes the Shopify product details and the result from the Odoo check, then outputs
existing: true/falseandproduct_detail. - Filter2 Node: This node controls the flow. Configure it to pass items only if
existingistrue(i.e.,{{ $json.existing }}is true), meaning an existing product was found in Odoo. - Odoo7 Node (Update Product): Connect to the same Odoo instance. Set
resourceto "custom" andcustomResourcetoproduct.product. Map the fields to update:nameto{{ $json.product_detail.title }},default_codeto{{ $json.product_detail.variants[0].product_id }},descriptionto{{ $json.product_detail.body_html }}, andlist_priceto{{ $json.product_detail.variants[0].price }}.
Apps Used
Workflow JSON
{
"id": "6040a483-023d-4aea-908f-d99eab979d21",
"name": "Sync New Shopify Products to Odoo for Real-time Updates",
"nodes": 5,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 6040a483-023d...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.