{ "edges": [ { "to": "0a19f77e-d3b2-41e8-8a61-6be83fd536b7", "from": "da6a3a81-4495-4b9a-acc9-9d756cb4f243", "toPort": "0", "fromPort": "0" }, { "to": "fa08116b-5b16-4d35-a500-d5674fd9210b", "from": "fb2119a3-91fb-4910-82d9-bb8cd139e5d8", "toPort": "0", "fromPort": "0" }, { "to": "da6a3a81-4495-4b9a-acc9-9d756cb4f243", "from": "9dffd428-e03e-4aaa-bef0-c9356dfd4c95", "toPort": "0", "fromPort": "0" }, { "to": "f60a0edc-d6c3-40cf-8c56-7e469aff6faa", "from": "152ac14f-ba84-4f0f-b413-7f53a37414fa", "toPort": "0", "fromPort": "0" }, { "to": "49fbfe38-6c4d-4d98-8bee-6f3cbed260ee", "from": "f60a0edc-d6c3-40cf-8c56-7e469aff6faa", "toPort": "0", "fromPort": "0" }, { "to": "b7aaf7e2-acb5-4fc5-b995-695ad788faa6", "from": "f60a0edc-d6c3-40cf-8c56-7e469aff6faa", "toPort": "0", "fromPort": "1" }, { "to": "554fc78c-2c70-441a-9a8a-6cab7006d139", "from": "b7aaf7e2-acb5-4fc5-b995-695ad788faa6", "toPort": "0", "fromPort": "0" }, { "to": "fb2119a3-91fb-4910-82d9-bb8cd139e5d8", "from": "554fc78c-2c70-441a-9a8a-6cab7006d139", "toPort": "0", "fromPort": "0" }, { "to": "152ac14f-ba84-4f0f-b413-7f53a37414fa", "from": "0a19f77e-d3b2-41e8-8a61-6be83fd536b7", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "49fbfe38-6c4d-4d98-8bee-6f3cbed260ee", "name": "No Operation, do nothing1", "type": "passthrough", "params": { "mode": "noOp" }, "position": [ 0, 0 ] }, { "id": "9dffd428-e03e-4aaa-bef0-c9356dfd4c95", "name": "Fetching Cart Contents", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "fde986cf-7c26-42e9-885d-cb44ee305863", "options": {}, "httpMethod": "POST" }, "position": [ -1024, 80 ] }, { "id": "da6a3a81-4495-4b9a-acc9-9d756cb4f243", "name": "Waiting Time", "type": "passthrough", "params": { "mode": "noOp", "unit": "minutes", "amount": 15 }, "position": [ -848, 80 ] }, { "id": "0a19f77e-d3b2-41e8-8a61-6be83fd536b7", "name": "Fetching If Customer has placed order", "type": "integration", "params": { "limit": 10, "options": { "after": "={{ $('Fetching Cart Contents').item.json.body.arg.timestamp }}", "search": "={{ $json.body.arg.customer_id }}", "status": "completed" }, "service": "woocommerce", "resource": "order", "operation": "getAll", "__originalType": "n8n-nodes-base.wooCommerce" }, "position": [ -656, 80 ] }, { "id": "f60a0edc-d6c3-40cf-8c56-7e469aff6faa", "name": "If, There's a Order Placed", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "137f38ed-baa4-4027-b4a1-9fad50c94ca5", "operator": { "type": "number", "operation": "gt" }, "leftValue": "={{ $node[\"Set Default Order Data\"].json.length }}", "rightValue": "=0" } ] }, "looseTypeValidation": true }, "position": [ -224, 80 ] }, { "id": "fa08116b-5b16-4d35-a500-d5674fd9210b", "name": "Abandoned Cart Recovery Email", "type": "integration", "params": { "html": "={{ $json.email_html }}", "options": { "appendAttribution": false }, "service": "smtp", "subject": "=Greetings! You left [Your Product Name] in your cart! ", "toEmail": "={{ $('Set Default Order Data').item.json.body.arg.billing_email }}", "fromEmail": "", "operation": "read" }, "position": [ 720, 192 ] }, { "id": "152ac14f-ba84-4f0f-b413-7f53a37414fa", "name": "Set Default Order Data", "type": "code", "params": { "jsCode": "try {\n // Get input data from WooCommerce node\n const inputData = $input.first() || {};\n // Get original webhook payload from Fetching Cart Contents\n const webhookData = $node[\"Fetching Cart Contents\"].json || {};\n // Log input for debugging\n console.log('Input to Set Default Order Data: ' + JSON.stringify(inputData, null, 2));\n console.log('Webhook Data: ' + JSON.stringify(webhookData, null, 2));\n // Extract and validate orders\n let orders = inputData.json;\n if (orders === undefined || orders === null || typeof orders !== 'object') {\n orders = [];\n } else if (!Array.isArray(orders)) {\n console.log('Invalid data format, forcing empty array');\n orders = [];\n }\n // Merge webhook data with orders\n const output = {\n orders: orders,\n ...webhookData // Preserve original payload fields\n };\n // Return normalized data\n return [{ json: output }];\n} catch (error) {\n console.log('Error in Set Default Order Data: ' + error.message);\n return [{ json: { orders: [] } }];\n}" }, "position": [ -448, 80 ] }, { "id": "b7aaf7e2-acb5-4fc5-b995-695ad788faa6", "name": "Generate Unique Coupon Code", "type": "code", "params": { "jsCode": "// --- CONFIGURATION SECTION ---\nconst CONFIG = {\n COUPON_PREFIX: '', // Specify the Coupon Code Phrase here\n EXPIRY_MINUTES: 30, // Time until expiry\n TIMEZONE: 'UTC' // CHANGE THIS: 'Asia/Kolkata', 'America/New_York', 'UTC', etc.\n};\n\n// --- COUPON GENERATION LOGIC ---\nconst customerId = $input.first().json.body.arg.customer_id;\n\n// Generate base number (0-1000) based on ID and current timestamp\nlet baseNumber = Math.floor(Math.abs(parseInt(customerId + Date.now().toString().slice(-6))) % 1000 + 1);\nlet codeNumber = ('000' + baseNumber).slice(-3);\nlet finalCode = CONFIG.COUPON_PREFIX + codeNumber;\n\n// Handle collisions\nlet usedCodes = $json.usedCodes || [];\nwhile (usedCodes.includes(finalCode)) {\n baseNumber = (baseNumber % 1000) + 1;\n codeNumber = ('000' + baseNumber).slice(-3);\n finalCode = CONFIG.COUPON_PREFIX + codeNumber;\n}\nusedCodes.push(finalCode);\n\n// --- TIME CALCULATION LOGIC ---\n\n// 1. Calculate the exact expiry moment (Current Time + Expiry Minutes)\nconst now = new Date();\nconst expiryDate = new Date(now.getTime() + CONFIG.EXPIRY_MINUTES * 60000);\n\n// 2. Format: \"HH:mm\" (e.g., \"19:09\") based on TARGET TIMEZONE\nconst expiryTime = expiryDate.toLocaleTimeString('en-GB', {\n timeZone: CONFIG.TIMEZONE,\n hour12: false,\n hour: '2-digit',\n minute: '2-digit'\n});\n\n// 3. Format: \"YYYY-MM-DD HH:mm:ss\" based on TARGET TIMEZONE\n// We use the 'sv-SE' (Swedish) locale hack, which naturally formats dates as ISO 8601 (YYYY-MM-DD)\nconst dateExpires = expiryDate.toLocaleString('sv-SE', {\n timeZone: CONFIG.TIMEZONE,\n year: 'numeric',\n month: '2-digit',\n day: '2-digit',\n hour: '2-digit',\n minute: '2-digit',\n second: '2-digit'\n}).replace('T', ' ');\n\nreturn [{\n json: {\n code: finalCode,\n usedCodes: usedCodes,\n customer_id: customerId,\n expiry_time: expiryTime, // Local time in HH:mm\n date_expires: dateExpires, // Full timestamp YYYY-MM-DD HH:mm:ss\n timezone: CONFIG.TIMEZONE // Helpful for debugging\n }\n}];" }, "position": [ 0, 192 ] }, { "id": "554fc78c-2c70-441a-9a8a-6cab7006d139", "name": "Create Abandoned Cart Coupon (HTTP)", "type": "http", "params": { "url": "", "method": "POST", "options": {}, "jsonBody": "={\n \"code\": \"{{ $json.code }}\",\n \"discount_type\": \"percent\",\n \"amount\": \"5\",\n \"date_expires\": \"{{ $json.date_expires }}\",\n \"individual_use\": true,\n \"usage_limit\": 1,\n \"usage_limit_per_user\": 1,\n \"customer_id\": \"{{ $('Set Default Order Data').item.json.body.arg.customer_id }}\",\n\"meta_data\": [\n {\n \"key\": \"expiry_time\",\n \"value\": \"{{ $json.expiry_time }}\"\n }\n ]\n}", "sendBody": true, "specifyBody": "json", "authentication": "predefinedCredentialType", "nodeCredentialType": "wooCommerceApi" }, "position": [ 240, 192 ] }, { "id": "fb2119a3-91fb-4910-82d9-bb8cd139e5d8", "name": "Generate Email HTML", "type": "code", "params": { "jsCode": "// --- CONFIGURATION SECTION ---\nconst CONFIG = {\n TIMEZONE: 'UTC', // CHANGE THIS: 'Asia/Kolkata', 'America/New_York', 'UTC', etc.\n CURRENCY_SYMBOL: '', // CHANGE THIS: '$', '€', '£', etc.\n LOCALE_FORMAT: 'en-US' // CHANGE THIS: 'en-GB', 'en-US' (for number formatting)\n};\n\n// --- DATA EXTRACTION ---\nconst inputData = $input.first().json;\n\n// Safe navigation for inputs (defaults provided if missing)\nconst cartContents = $('Set Default Order Data').first().json.body.arg.cart_contents || [];\nconst billingEmail = $('Set Default Order Data').first().json.body.arg.billing_email || '';\nconst cartTotal = $('Set Default Order Data').first().json.body.arg.cart_total || '0.00';\n\n// --- TIMESTAMP LOGIC (LOCALE AWARE) ---\n// If timestamp is missing, generate current time in the Configured Timezone\nlet currentTimestamp;\nif ($('Set Default Order Data').first().json.body.arg.timestamp) {\n currentTimestamp = $('Set Default Order Data').first().json.body.arg.timestamp;\n} else {\n // Generate ISO-like format (YYYY-MM-DD HH:mm:ss) respecting the CONFIG.TIMEZONE\n currentTimestamp = new Date().toLocaleString('sv-SE', {\n timeZone: CONFIG.TIMEZONE,\n year: 'numeric',\n month: '2-digit',\n day: '2-digit',\n hour: '2-digit',\n minute: '2-digit',\n second: '2-digit'\n }).replace('T', ' ');\n}\nconst timestamp = currentTimestamp;\n\n// Retrieve Coupon Data (Ensure these nodes exist in your workflow)\nconst couponCode = $node[\"Generate Unique Coupon Code\"].json.code; \nconst dateExpires = $node[\"Create Abandoned Cart Coupon (HTTP)\"].json.date_expires;\n// Note: Ensure meta_data[0] actually exists in your previous node's output\nconst expiryTime = $node[\"Create Abandoned Cart Coupon (HTTP)\"].json.meta_data && $node[\"Create Abandoned Cart Coupon (HTTP)\"].json.meta_data[0] \n ? $node[\"Create Abandoned Cart Coupon (HTTP)\"].json.meta_data[0].value \n : '';\n\n// --- CALCULATIONS ---\n// Calculate discount (5%) and total\nconst discount = (parseFloat(cartTotal) * 0.05).toFixed(2);\nconst totalWithDiscount = (parseFloat(cartTotal) - parseFloat(discount)).toFixed(2);\n\n// --- DYNAMIC HTML GENERATION ---\nlet tableRows = '';\ncartContents.forEach(item => {\n // Use CONFIG.CURRENCY_SYMBOL here\n tableRows += `\n \n \n $\"${item.name$ \n \n ${item.name || 'Unnamed Item'}\n ${item.quantity || '1'}\n ${CONFIG.CURRENCY_SYMBOL}${item.price || '0.00'}\n \n `;\n});\n\n// Construct checkout URL\nconst baseUrl = \"\"; // Replace with your actual domain\nconst cartUrl = couponCode ? `${baseUrl}/cart/?coupon=${couponCode}` : `${baseUrl}/cart/`;\n\n// --- EMAIL CONTENT ---\n// You can now use variables: ${timestamp}, ${formattedTotal}, ${tableRows}, etc.\n// HTML Version (Add Your Mail's HTML Code)\nconst htmlContent = `\n \n`;\n\n// Plain Text Version (Fallback) (Add Fallback Text)\n\nreturn [{\n json: {\n email_html: htmlContent,\n email_text: textContent,\n meta: {\n timestamp: timestamp,\n timezone: CONFIG.TIMEZONE,\n currency: CONFIG.CURRENCY_SYMBOL\n }\n }\n}];" }, "position": [ 480, 192 ] } ] }

Recover abandoned WooCommerce carts with custom coupon emails