{"name":"Inventory Alert System","nodes":[{"id":"schedule","type":"n8n-nodes-base.scheduleTrigger","name":"Daily Inventory Check","position":[250,300],"parameters":{"rule":{"interval":[{"field":"cronExpression","expression":"0 8 * * *"}]}}},{"id":"fetchInventory","type":"n8n-nodes-base.shopify","name":"Get Inventory Levels","position":[450,300],"parameters":{"operation":"getAll","resource":"inventoryLevel"}},{"id":"fetchSalesHistory","type":"n8n-nodes-base.shopify","name":"Get Sales Velocity","position":[450,450],"parameters":{"operation":"getAll","resource":"order","filters":{"created_at_min":"={{$now.minus({days:90}).toISO()}}"}}},{"id":"aiDemandForecast","type":"n8n-nodes-base.openAi","name":"AI Demand Forecast","position":[700,300],"parameters":{"model":"gpt-4o","prompt":"Analyze inventory and sales data. For each SKU, forecast demand for next 30/60/90 days. Calculate days of inventory remaining. Flag items with <14 days runway. Identify slow movers (>90 days of stock).\n\nReturn JSON array: [{sku, current_stock, daily_velocity, days_remaining, forecast_30d, forecast_60d, reorder_needed: bool, recommended_order_qty, urgency: \"critical\"|\"warning\"|\"healthy\"|\"overstock\"}]\n\nInventory: {{JSON.stringify($json.inventory)}}\nSales (90d): {{JSON.stringify($json.sales_summary)}}"}},{"id":"filterCritical","type":"n8n-nodes-base.filter","name":"Filter Low Stock","position":[900,200],"parameters":{"conditions":{"string":[{"value1":"={{$json.urgency}}","operation":"equal","value2":"critical"}]}}},{"id":"filterWarning","type":"n8n-nodes-base.filter","name":"Filter Warning Stock","position":[900,400],"parameters":{"conditions":{"string":[{"value1":"={{$json.urgency}}","operation":"equal","value2":"warning"}]}}},{"id":"generatePO","type":"n8n-nodes-base.httpRequest","name":"Generate Purchase Order","position":[1150,200],"parameters":{"url":"={{$env.PROCUREMENT_API}}/purchase-orders","method":"POST","body":{"sku":"={{$json.sku}}","quantity":"={{$json.recommended_order_qty}}","supplier_id":"={{$json.preferred_supplier}}"}}},{"id":"alertSlack","type":"n8n-nodes-base.slack","name":"Alert Inventory Team","position":[1150,350],"parameters":{"channel":"#inventory-alerts","text":"LOW STOCK WARNING:\n{{$json.alerts_summary}}"}},{"id":"weeklyReport","type":"n8n-nodes-base.sendGrid","name":"Send Weekly Report","position":[1350,300],"parameters":{"to":"={{$env.INVENTORY_MANAGER_EMAIL}}","subject":"Weekly Inventory Health Report"}}],"connections":{"Daily Inventory Check":{"main":[[{"node":"Get Inventory Levels","type":"main","index":0},{"node":"Get Sales Velocity","type":"main","index":0}]]},"Get Inventory Levels":{"main":[[{"node":"AI Demand Forecast","type":"main","index":0}]]},"Get Sales Velocity":{"main":[[{"node":"AI Demand Forecast","type":"main","index":0}]]},"AI Demand Forecast":{"main":[[{"node":"Filter Low Stock","type":"main","index":0},{"node":"Filter Warning Stock","type":"main","index":0}]]},"Filter Low Stock":{"main":[[{"node":"Generate Purchase Order","type":"main","index":0}]]},"Filter Warning Stock":{"main":[[{"node":"Alert Inventory Team","type":"main","index":0}]]},"Generate Purchase Order":{"main":[[{"node":"Alert Inventory Team","type":"main","index":0}]]},"Alert Inventory Team":{"main":[[{"node":"Send Weekly Report","type":"main","index":0}]]}}}