Sync retail product prices between Shopify and WooCommerce with alerts
Ready for 3.0What this workflow does
This workflow has 17 nodes and runs on WooCommerce events (product.updated) (plus 1 other trigger). Along the way it connects Shopify, WooCommerce, Google Sheets and Gmail.
How it runs
Trigger: On WooCommerce events (product.updated) (plus 1 other trigger).
- WooCommerce Configuration (Edit Fields (Set)): sets 6 fields: oldPrice, newPrice, priceChangeThreshold…
- Shopify Configuration (Edit Fields (Set)): sets 6 fields: oldPrice, newPrice, priceChangeThreshold…
- Extract Price Data (Edit Fields (Set)): sets 6 fields: oldPrice, newPrice, sourceSystem…
- Check Price Change Threshold (If): checks a condition and branches into true / false
- Alert Team - Major Price Drop (Gmail): uses Gmail
- Apply Platform-Specific Rules (Code): runs custom JavaScript code
- FormatWooCommerce (Edit Fields (Set)): sets 3 fields: regular_price, id, sku
- FormatShopify (Edit Fields (Set)): sets 3 fields: price, productId, sku
- Get many products (WooCommerce): get many
- Get many orders (Shopify): get many
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Shopify Trigger
n8n-nodes-base.shopifyTrigger - WooCommerce Trigger
n8n-nodes-base.wooCommerceTrigger - Edit Fields (Set)
n8n-nodes-base.set - WooCommerce
n8n-nodes-base.wooCommerce - Shopify
n8n-nodes-base.shopify - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if
From the author
Retail Price Sync Automation for Shopify & WooCommerce This workflow automates the synchronization of product prices across Shopify and WooCommerce platforms to ensure retail consistency. It triggers when a price change is detected in either system, applies…