Shopify to Odoo Product Sync: Real-Time Inventory and Pricing Updates

This n8n workflow automates product synchronization from Shopify to Odoo, ensuring consistent inventory and pricing. Key nodes include Webhook for API triggers, Shopify Trigger for product events, Condition for security validation, Set for data sanitization, Function for product processing, Odoo for ERP integration, Switch for sync routing, Merge for result consolidation, and Webhook Response for output. It supports real-time product creation and updates with duplicate detection. To set up, download n8n from n8n.io for self-hosting or sign up at cloud.n8n.io. Obtain Shopify API credentials (Access Token) from your Shopify admin under Apps > Develop Apps > Create App, enabling product read/write scopes. For Odoo, get API credentials (URL, Database, Username, Password) from your Odoo instance under Settings > API Keys. In n8n, add these under Credentials > Add Credential > Shopify Access Token API and Odoo API. Import the workflow JSON via Workflows > Import. Configure the Webhook node (path: /ecommerce-erp-sync, method: POST) with CORS headers (Access-Control-Allow-Origin: *). Use ngrok for local webhook testing. Set the Shopify Trigger to monitor products/create events. Ensure HTTPS for secure data transmission. Test by creating a product in Shopify or sending a POST request to the webhook with JSON (e.g., {id: '123', title: 'Test Product', variants: [{price: '50'}]}). Include headers (x-api-key, x-ecommerce-authorization). Validate outputs in the Set node for devHubConnectEcommerceResponse (e.g., success: true, businessMetrics.revenueImpact > 0). Handle errors like invalid Shopify credentials (401 response with 'ECOMMERCE_SECURITY_VALIDATION_FAILED') or missing Odoo product fields (check default_code in Odoo). For issues, verify HTTPS, credential accuracy, and webhook setup in the Shopify admin. Deploy by saving and enabling the workflow, ensuring triggers are active. Test with a Shopify product creation to confirm Odoo sync. Check Webhook Response for businessMetrics (e.g., inventoryValue > 0). If sync fails, verify node connections and Odoo field mappings in n8n’s editor.