Quick overview
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 it works Runs when you execute the workflow manually or on a schedule every 6 hours. Reads your sync configuration (supplier file URL/type, column names, Shopify domain/API version, and update rules) and requests an Admin API access token from Shopify. Fetches the store’s primary Shopify location via GraphQL and downloads the supplier CSV or XLSX file over HTTP. Extracts rows from the file, validates SKUs/stock/price, and normalizes each row into a Shopify SKU search query. For each valid row, queries Shopify for the matching product variant at the primary location and calculates target stock/price using the configured stock buffer and price multiplier. Updates only changed values in Shopify (inventory at the primary location and/or variant price) using GraphQL with an idempotency key and change-from-quantity safety check. Outputs a sync summary that counts updated/unchanged/invalid/missing/duplicate/error rows and includes detailed results per SKU. Setup Create and install a Shopify app for the target store with write_products, write_inventory, and read_locations scopes, then copy its Client ID and Client Secret. In the configuration step, set your shopDomain, shopifyApiVersion, and paste the Shopify Client ID/Secret used to request an access token. Provide a direct, publicly reachable HTTP(S) URL to your supplier CSV/XLSX file and set fileType plus the exact column names for SKU, Stock, and Price. Choose whether to update stock and/or price and optionally set stockBuffer and priceMultiplier to control how supplier values translate into Shopify updates. Run the workflow once manually and review the final sync summary for missing/duplicate SKUs and validation errors before activating the 6-hour schedule. Requirements Shopify store, Shopify Dev Dashboard app, direct supplier CSV/XLSX URL Customization Change sync interval, supplier column names, stock buffer, price multiplier, and enable/disable stock or price updates Additional info Updates existing Shopify variants only. Products are matched by exact SKU. V1 does not create new products and uses the store's primary inventory location. An n8n automation workflow template by Hoa Nguyen.
Hoa Nguyen
web
free
Others in the same category, ranked by how often they are opened.
