Automate Product Detail Updates from Shopify to Odoo
detail.loadingPreview
This n8n workflow automatically updates existing product details in your Odoo ERP system whenever a new product is created in Shopify. It ensures consistency by synchronizing key information like name, description, and pricing for matching products.
About This Workflow
Streamline your e-commerce and ERP operations with this n8n workflow designed to keep your Odoo product catalog synchronized with Shopify. When a new product is created in your Shopify store, this automation kicks in. It intelligently checks Odoo to see if a product with a matching identifier (Shopify's product ID as Odoo's default code) already exists. If a match is found, the workflow proceeds to update the Odoo product's name, description, and list price with the latest information from Shopify, ensuring your inventory and sales data remain accurate and consistent across both platforms.
Key Features
- Event-Driven Shopify Integration: Automatically triggers on
products/createevents in Shopify. - Intelligent Odoo Lookup: Searches Odoo for existing products using Shopify's product ID to avoid duplicates and identify records for update.
- Conditional Data Synchronization: Updates Odoo product details only for matching products found in your ERP system.
- Key Field Synchronization: Syncs essential product attributes including
name,default_code,description, andlist_pricefrom Shopify to Odoo. - Improved Data Consistency: Ensures your Odoo product data reflects the latest information from your active Shopify listings.
How To Use
- Configure Shopify Trigger: Add your Shopify Access Token credentials to the
Shopify Triggernode. Ensure theTopicis set toproducts/create. - Set Up Odoo Credentials: Provide your Odoo API credentials for both
Odoo6(lookup) andOdoo7(update) nodes. This typically includes your Odoo URL, database, username, and password. - Review Logic: This workflow is designed to update existing Odoo products when a match is found. If you intend to also create new Odoo products when no match is found, you would need to adjust the
Filter2node's logic and potentially add another Odoo node for creation. - Activate Workflow: Once configured, activate the workflow to begin automatically syncing product details.
Apps Used
Workflow JSON
{
"id": "c6bd7b99-2edc-4dad-a147-25519dc88a9b",
"name": "Automate Product Detail Updates from Shopify to Odoo",
"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: c6bd7b99-2edc...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
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.
Automate Getty Images Editorial Search & CMS Integration
This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.