{"product_id":"shopify-to-airtable-inventory-sync-with-slack-low-stock-alerts","title":"Shopify to Airtable Inventory Sync with Slack Low-Stock Alerts","description":"\u003ch3\u003eAutomatically Sync Shopify Inventory to Airtable—and Get Slack Low-Stock Alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow listens for \u003cstrong\u003epaid Shopify orders\u003c\/strong\u003e, subtracts sold quantities from your \u003cstrong\u003eAirtable inventory per SKU\u003c\/strong\u003e, and instantly posts a \u003cstrong\u003eSlack low-stock warning\u003c\/strong\u003e whenever stock drops to (or below) your reorder threshold.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on paid Shopify orders\u003c\/strong\u003e once an order is marked as paid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits the order into individual line items\u003c\/strong\u003e so each SKU is processed separately.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinds the matching Airtable inventory record by SKU\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates and updates stock levels\u003c\/strong\u003e by subtracting the ordered quantity from \u003cem\u003eStockOnHand\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks the reorder threshold\u003c\/strong\u003e after the update.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts to Slack only when needed\u003c\/strong\u003e: if \u003cem\u003eStockOnHand\u003c\/em\u003e is at or below \u003cem\u003eReorderThreshold\u003c\/em\u003e, a warning is sent to your chosen Slack channel; otherwise the workflow ends.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep Airtable inventory accurate in near real time without manual SKU tracking after each Shopify sale.\u003c\/li\u003e\n  \u003cli\u003eNotify your team in \u003cstrong\u003eSlack\u003c\/strong\u003e when a product is about to run out, so you can reorder before stockouts.\u003c\/li\u003e\n  \u003cli\u003eSupport operators and SaaS teams who want a reliable “source of truth” for inventory with automated alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eShopify\u003c\/strong\u003e (OAuth2): triggers when orders are \u003cstrong\u003emarked as paid\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAirtable\u003c\/strong\u003e: searches and updates an inventory table using fields including \u003cstrong\u003eSKU\u003c\/strong\u003e, \u003cstrong\u003eProductName\u003c\/strong\u003e, \u003cstrong\u003eStockOnHand\u003c\/strong\u003e, and \u003cstrong\u003eReorderThreshold\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e: sends low-stock warnings to a specified channel via Slack OAuth2.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: if, set, no op, slack, airtable, split out.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup at a glance\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConnect Shopify OAuth2 credentials and ensure the workflow has access to the store’s Admin API order webhooks.\u003c\/li\u003e\n  \u003cli\u003eConnect Airtable Personal Access Token and point nodes to your inventory base\/table.\u003c\/li\u003e\n  \u003cli\u003eConnect Slack OAuth2 and select the channel for low-stock alerts.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45747800473779,"sku":"N8N-17653","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/uSOaGyz-k2YRXnyCGdKju_knlA5y35.png?v=1785488762","url":"https:\/\/buyflowscripts.com\/products\/shopify-to-airtable-inventory-sync-with-slack-low-stock-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}