{"product_id":"sync-shopify-inventory-prices-from-supplier-csv-xlsx-n8n","title":"Sync Shopify Inventory \u0026 Prices from Supplier CSV\/XLSX (n8n)","description":"\u003ch3\u003eSync Shopify inventory \u0026amp; prices from your supplier CSV\/XLSX (n8n)\u003c\/h3\u003e\n\u003cp\u003eKeep your Shopify catalog accurate by automatically downloading a supplier CSV\/XLSX, matching products by \u003cstrong\u003eSKU\u003c\/strong\u003e, and updating \u003cstrong\u003evariant inventory\u003c\/strong\u003e and\/or \u003cstrong\u003evariant prices\u003c\/strong\u003e in Shopify using the Admin GraphQL API—complete with a clear per-run sync summary.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand or on a schedule:\u003c\/strong\u003e execute manually or automatically every \u003cstrong\u003e6 hours\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your sync configuration:\u003c\/strong\u003e supplier file URL\/type, supplier column names, Shopify domain\/API version, and update rules (including stock\/price calculations).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuthenticates to Shopify:\u003c\/strong\u003e requests an Admin API access token.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetermines the primary Shopify location:\u003c\/strong\u003e fetches the store’s primary location via GraphQL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads and processes the supplier file:\u003c\/strong\u003e retrieves the CSV\/XLSX over HTTP, extracts rows, and validates SKUs\/stock\/price.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches by SKU and computes targets:\u003c\/strong\u003e for each valid row, queries Shopify for the matching product variant at the primary location, then applies your configured \u003cstrong\u003estock buffer\u003c\/strong\u003e and \u003cstrong\u003eprice multiplier\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates only what changed:\u003c\/strong\u003e uses GraphQL to update inventory at the primary location and\/or variant price, including an \u003cstrong\u003eidempotency key\u003c\/strong\u003e and a change-from-quantity safety check.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProduces a sync summary:\u003c\/strong\u003e counts updated\/unchanged\/invalid\/missing\/duplicate\/error rows and includes detailed results per SKU.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily\/regular supplier refreshes to prevent overselling by keeping \u003cstrong\u003eShopify inventory\u003c\/strong\u003e aligned to CSV\/XLSX updates.\u003c\/li\u003e\n  \u003cli\u003eMargin-controlled pricing by applying a \u003cstrong\u003eprice multiplier\u003c\/strong\u003e from supplier feeds.\u003c\/li\u003e\n  \u003cli\u003eOperations teams using n8n to standardize supplier-to-Shopify synchronization with transparent reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow type:\u003c\/strong\u003e n8n automation workflow with \u003cem\u003emanual trigger\u003c\/em\u003e and scheduling every 6 hours.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e if, set, code, sticky note, http request, manual trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eShopify integration:\u003c\/strong\u003e Admin GraphQL API (updates via \u003cstrong\u003ewrite_products\u003c\/strong\u003e, \u003cstrong\u003ewrite_inventory\u003c\/strong\u003e, and reads via \u003cstrong\u003eread_locations\u003c\/strong\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978932150451,"sku":"N8N-19313","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0uGXyMSQnHVTDVF2Qprtt_1OK0JkwD.png?v=1788859859","url":"https:\/\/buyflowscripts.com\/products\/sync-shopify-inventory-prices-from-supplier-csv-xlsx-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}