Sync Shopify inventory and prices with supplier CSV or Excel files
Ready for 3.0What this workflow does
This workflow has 20 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). It uses only n8n's built-in nodes.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- CONFIG - EDIT ME (Edit Fields (Set)): sets 14 fields: supplierFileUrl, fileType, skuColumn…
- Get Shopify Access Token (HTTP Request): calls an HTTP API (POST)
- Validate Shopify Token (Code): runs custom JavaScript code
- Get Primary Shopify Location (HTTP Request): calls an HTTP API (POST)
- Validate Shopify Location (Code): runs custom JavaScript code
- Download Supplier File (HTTP Request): calls an HTTP API
- Is XLSX? (If): checks a condition and branches into true / false
- Extract XLSX (Extract from File): extracts data from a file (xlsx)
- Extract CSV (Extract from File): extracts data from a file
- Normalize & Validate (Code): runs custom JavaScript code
…plus 8 more steps. See the full node list below.
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 (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Extract from File
n8n-nodes-base.extractFromFile - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Quick overview This workflow runs manually or every 6 hours to download a supplier CSV/XLSX file, match rows by SKU against Shopify variants, and update variant inventory and/or prices via the Shopify Admin GraphQL API, producing a per-run sync summary. How…