{ "edges": [ { "to": "be5298cc-5a62-4e86-8cf8-641fceb8d2c5", "from": "c9d3f410-9ba0-49ae-b11a-fc6eec70ff5d", "toPort": "0", "fromPort": "0" }, { "to": "eff4aab4-2149-4f6b-860f-1d63706fa714", "from": "c9d3f410-9ba0-49ae-b11a-fc6eec70ff5d", "toPort": "0", "fromPort": "1" }, { "to": "0825665e-ad08-4576-836e-baa074294a2d", "from": "1f8a64ed-475b-4589-a783-9ce974891dea", "toPort": "0", "fromPort": "0" }, { "to": "8127ab51-ad94-4f26-a48f-12d04ef81f59", "from": "9b30b060-c895-458a-942a-2160cb146bd5", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "eff4aab4-2149-4f6b-860f-1d63706fa714", "from": "be5298cc-5a62-4e86-8cf8-641fceb8d2c5", "toPort": "0", "fromPort": "0" }, { "to": "44d9823e-3f64-4220-8a3f-fae0f242048c", "from": "0825665e-ad08-4576-836e-baa074294a2d", "toPort": "0", "fromPort": "0" }, { "to": "8127ab51-ad94-4f26-a48f-12d04ef81f59", "from": "acbb6299-063c-4fe8-b4d2-89f97ab63235", "toPort": "0", "fromPort": "ai_outputParser" }, { "to": "1f8a64ed-475b-4589-a783-9ce974891dea", "from": "c3e2e2b9-77bc-493f-a69d-d26fc789f0d9", "toPort": "0", "fromPort": "0" }, { "to": "c9d3f410-9ba0-49ae-b11a-fc6eec70ff5d", "from": "8127ab51-ad94-4f26-a48f-12d04ef81f59", "toPort": "0", "fromPort": "0" }, { "to": "8127ab51-ad94-4f26-a48f-12d04ef81f59", "from": "44d9823e-3f64-4220-8a3f-fae0f242048c", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "c3e2e2b9-77bc-493f-a69d-d26fc789f0d9", "name": "Daily Inventory Check", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "cronExpression", "expression": "0 6 * * *" } ] } }, "position": [ 20256, 5936 ] }, { "id": "1f8a64ed-475b-4589-a783-9ce974891dea", "name": "Fetch All Products", "type": "integration", "params": { "service": "shopify", "resource": "product", "operation": "getAll", "returnAll": true, "__originalType": "n8n-nodes-base.shopify", "additionalFields": {} }, "position": [ 20416, 5936 ] }, { "id": "0825665e-ad08-4576-836e-baa074294a2d", "name": "Fetch Recent Orders", "type": "integration", "params": { "options": { "status": "any" }, "service": "shopify", "operation": "getAll", "returnAll": true, "__originalType": "n8n-nodes-base.shopify" }, "position": [ 20672, 5920 ] }, { "id": "44d9823e-3f64-4220-8a3f-fae0f242048c", "name": "Compute Sales Velocity", "type": "code", "params": { "jsCode": "const orders = $('Fetch Recent Orders').all();\nconst salesMap = {};\nfor (const order of orders) {\n for (const item of (order.json.line_items || [])) {\n const vid = String(item.variant_id);\n salesMap[vid] = (salesMap[vid] || 0) + (item.quantity || 0);\n }\n}\nconst products = $('Fetch All Products').all();\nconst result = [];\nfor (const product of products) {\n for (const variant of (product.json.variants || [])) {\n const vid = String(variant.id);\n const stock = variant.inventory_quantity || 0;\n const sold7d = salesMap[vid] || 0;\n const velocity = sold7d / 7;\n const days_until_stockout = velocity > 0 ? Math.floor(stock / velocity) : 999;\n result.push({ json: {\n product_title: product.json.title,\n variant_id: vid,\n variant_title: variant.title,\n sku: variant.sku || '',\n stock,\n sold_7d: sold7d,\n velocity_per_day: Math.round(velocity * 100) / 100,\n days_until_stockout\n }});\n }\n}\nreturn result;" }, "position": [ 20944, 5904 ] }, { "id": "8127ab51-ad94-4f26-a48f-12d04ef81f59", "name": "Predict Stockout Risk", "type": "llm", "params": { "text": "=Analyse this Shopify product variant and determine reorder urgency.\n\nProduct: {{ $json.product_title }} — {{ $json.variant_title }}\nSKU: {{ $json.sku }}\nCurrent Stock: {{ $json.stock }} units\nSold in Last 7 Days: {{ $json.sold_7d }} units\nSales Velocity: {{ $json.velocity_per_day }} units/day\nEstimated Days Until Stockout: {{ $json.days_until_stockout }}\n\nAssess risk level, recommend a reorder quantity that covers 30 days of demand plus 20% safety stock, and decide whether an immediate reorder is needed.", "prompt": "=Analyse this Shopify product variant and determine reorder urgency.\n\nProduct: {{ $json.product_title }} — {{ $json.variant_title }}\nSKU: {{ $json.sku }}\nCurrent Stock: {{ $json.stock }} units\nSold in Last 7 Days: {{ $json.sold_7d }} units\nSales Velocity: {{ $json.velocity_per_day }} units/day\nEstimated Days Until Stockout: {{ $json.days_until_stockout }}\n\nAssess risk level, recommend a reorder quantity that covers 30 days of demand plus 20% safety stock, and decide whether an immediate reorder is needed.", "options": { "systemMessage": "=You are an inventory analyst for an e-commerce business. Assess stockout risk based on sales velocity and current stock. critical = stockout within 3 days, high = within 7 days, medium = 7-14 days, low = 14+ days. Recommend reorder quantities based on 30-day demand plus 20% safety buffer. If stock is 0 and velocity is 0, classify as low risk.", "returnIntermediateSteps": false }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "=You are an inventory analyst for an e-commerce business. Assess stockout risk based on sales velocity and current stock. critical = stockout within 3 days, high = within 7 days, medium = 7-14 days, low = 14+ days. Recommend reorder quantities based on 30-day demand plus 20% safety buffer. If stock is 0 and velocity is 0, classify as low risk.", "hasOutputParser": true }, "position": [ 21216, 5904 ] }, { "id": "9b30b060-c895-458a-942a-2160cb146bd5", "name": "OpenAI — Predict", "type": "llm", "params": { "model": "gpt-4o", "options": { "temperature": 0 }, "provider": "openai", "temperature": 0 }, "position": [ 21088, 6144 ] }, { "id": "acbb6299-063c-4fe8-b4d2-89f97ab63235", "name": "Stockout Risk Schema", "type": "passthrough", "params": { "mode": "noOp", "schemaType": "manual", "inputSchema": "{\"type\":\"object\",\"properties\":{\"risk_level\":{\"type\":\"string\",\"enum\":[\"critical\",\"high\",\"medium\",\"low\"]},\"recommended_reorder_qty\":{\"type\":\"integer\"},\"reasoning\":{\"type\":\"string\"},\"should_reorder\":{\"type\":\"boolean\"}},\"required\":[\"risk_level\",\"recommended_reorder_qty\",\"reasoning\",\"should_reorder\"]}" }, "position": [ 21408, 6128 ] }, { "id": "c9d3f410-9ba0-49ae-b11a-fc6eec70ff5d", "name": "Should Reorder?", "type": "if", "params": { "options": {}, "conditions": { "options": { "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "cond-reorder", "operator": { "type": "boolean", "operation": "equal" }, "leftValue": "={{ $json.output.should_reorder }}", "rightValue": true } ] } }, "position": [ 21536, 5904 ] }, { "id": "be5298cc-5a62-4e86-8cf8-641fceb8d2c5", "name": "Send Reorder Email", "type": "integration", "params": { "sendTo": "user@example.com", "message": "=

Reorder Request

Product	{{ $('Compute Sales Velocity').item.json.product_title }} — {{ $('Compute Sales Velocity').item.json.variant_title }}
SKU	{{ $('Compute Sales Velocity').item.json.sku }}
Current Stock	{{ $('Compute Sales Velocity').item.json.stock }} units
Sales Velocity	{{ $('Compute Sales Velocity').item.json.velocity_per_day }} units/day
Days Until Stockout	{{ $('Compute Sales Velocity').item.json.days_until_stockout }}
Risk Level	{{ $json.output.risk_level.toUpperCase() }}
Recommended Reorder Qty	{{ $json.output.recommended_reorder_qty }} units

{{ $json.output.reasoning }}

Please confirm receipt and expected delivery timeline.

", "options": {}, "service": "gmail", "subject": "=Reorder Request — {{ $('Compute Sales Velocity').item.json.product_title }} (SKU: {{ $('Compute Sales Velocity').item.json.sku }})", "operation": "read" }, "position": [ 21808, 5840 ] }, { "id": "eff4aab4-2149-4f6b-860f-1d63706fa714", "name": "Log to Google Sheets", "type": "integration", "params": { "columns": { "value": { "SKU": "={{ $('Compute Sales Velocity').item.json.sku }}", "Stock": "={{ $('Compute Sales Velocity').item.json.stock }}", "Product": "={{ $('Compute Sales Velocity').item.json.product_title }}", "Sold 7d": "={{ $('Compute Sales Velocity').item.json.sold_7d }}", "Variant": "={{ $('Compute Sales Velocity').item.json.variant_title }}", "Reasoning": "={{ $('Predict Stockout Risk').item.json.output.reasoning }}", "Timestamp": "={{ DateTime.now().toISO() }}", "Risk Level": "={{ $('Predict Stockout Risk').item.json.output.risk_level }}", "Reorder Qty": "={{ $('Predict Stockout Risk').item.json.output.recommended_reorder_qty }}", "Velocity/day": "={{ $('Compute Sales Velocity').item.json.velocity_per_day }}", "Days to Stockout": "={{ $('Compute Sales Velocity').item.json.days_until_stockout }}", "Reorder Triggered": "={{ $('Predict Stockout Risk').item.json.output.should_reorder }}" }, "mappingMode": "defineBelow" }, "options": {}, "service": "googleSheets", "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "name", "value": "Reorder Log" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_REORDER_LOG_SHEET_ID" } }, "position": [ 21840, 6096 ] } ] }

Predict Shopify stockouts with GPT-4o and email suppliers via Gmail