Sync Shopify Inventory & Prices from Supplier CSV/XLSX (n8n)

Sync Shopify inventory & prices from your supplier CSV/XLSX (n8n)

Keep your Shopify catalog accurate by automatically downloading a supplier CSV/XLSX, matching products by SKU, and updating variant inventory and/or variant prices in Shopify using the Admin GraphQL API—complete with a clear per-run sync summary.

What this workflow does

• Runs on demand or on a schedule: execute manually or automatically every 6 hours.
• Loads your sync configuration: supplier file URL/type, supplier column names, Shopify domain/API version, and update rules (including stock/price calculations).
• Authenticates to Shopify: requests an Admin API access token.
• Determines the primary Shopify location: fetches the store’s primary location via GraphQL.
• Downloads and processes the supplier file: retrieves the CSV/XLSX over HTTP, extracts rows, and validates SKUs/stock/price.
• Matches by SKU and computes targets: for each valid row, queries Shopify for the matching product variant at the primary location, then applies your configured stock buffer and price multiplier.
• Updates only what changed: uses GraphQL to update inventory at the primary location and/or variant price, including an idempotency key and a change-from-quantity safety check.
• Produces a sync summary: counts updated/unchanged/invalid/missing/duplicate/error rows and includes detailed results per SKU.

Use cases

• Daily/regular supplier refreshes to prevent overselling by keeping Shopify inventory aligned to CSV/XLSX updates.
• Margin-controlled pricing by applying a price multiplier from supplier feeds.
• Operations teams using n8n to standardize supplier-to-Shopify synchronization with transparent reporting.

Technical details

• Workflow type: n8n automation workflow with manual trigger and scheduling every 6 hours.
• Nodes used: if, set, code, sticky note, http request, manual trigger.
• Shopify integration: Admin GraphQL API (updates via write_products, write_inventory, and reads via read_locations).