复现n8n付费模板：Shopify退货退款邮件半自动审批流（本站隔离练习版）

本站独立编写的练习提示词，{{emailBody}}在n8n中替换为表达式引用上一节点字段

你是电商售后信息提取器。从下面的退货邮件正文中提取信息，只输出一个JSON对象，不要输出任何其他文字。字段：orderNumber（字符串，形如#1001的订单号，没有则为null）、items（数组，每项含name和quantity）、reason（字符串，退货理由原文概括）、requestedResolution（refund/exchange/store_credit之一，无法判断填refund）。邮件正文：
{{emailBody}}

本站设计，规则值（30天、15%手续费）为练习参考值，需按店铺政策替换

// 本站练习用Code节点脚本，规则数值均为本站设定示例
const extracted = $json.extracted;
const order = $json.order; // 合成订单数据
const headers = $json.headers || {};
const FINAL_SALE_TAGS = ['final-sale'];
const RETURN_WINDOW_DAYS = 30;
const RESTOCK_FEE_PCT = 0.15;

if (/dmarc=fail/i.test(headers['Authentication-Results'] || '')) {
  return [{ json: { decision: 'manual_review', reason: 'dmarc_fail' } }];
}
if (!extracted.orderNumber) {
  return [{ json: { decision: 'manual_review', reason: 'missing_order_number' } }];
}
if (extracted.requestedResolution !== 'refund') {
  return [{ json: { decision: 'manual_review', reason: 'non_refund_request' } }];
}
if (!order || order.financialStatus === 'pending') {
  return [{ json: { decision: 'manual_review', reason: 'order_not_found_or_unpaid' } }];
}
const deliveredDays = (Date.now() - new Date(order.deliveredAt).getTime()) / 86400000;
if (deliveredDays > RETURN_WINDOW_DAYS) {
  return [{ json: { decision: 'rejected', reason: 'outside_return_window' } }];
}
let subtotal = 0;
for (const item of extracted.items) {
  const line = order.lineItems.find(l => l.name === item.name);
  if (!line) return [{ json: { decision: 'manual_review', reason: 'item_not_in_order: ' + item.name } }];
  if (line.tags.some(t => FINAL_SALE_TAGS.includes(t))) {
    return [{ json: { decision: 'rejected', reason: 'final_sale: ' + item.name } }];
  }
  subtotal += line.price * Math.min(item.quantity, line.quantity);
}
const faulty = /破损|故障|defect|broken/i.test(extracted.reason);
const fee = faulty ? 0 : subtotal * RESTOCK_FEE_PCT;
return [{ json: { decision: 'eligible', reason: faulty ? 'faulty_no_fee' : 'standard', suggestedRefund: +(subtotal - fee).toFixed(2), currency: order.currency } }];

全部为虚构测试数据，order字段需按提取到的orderNumber匹配后并入$item

{
  "emails": [
    {
      "subject": "退货申请 订单#2041",
      "from": "customer-a@example.test",
      "headers": { "Authentication-Results": "mx.example.test; dmarc=pass" },
      "body": "你好，我收到订单#2041里的蓝色卫衣尺码不对，想退一件并退款。谢谢。"
    },
    {
      "subject": "退款请求",
      "from": "customer-b@example.test",
      "headers": { "Authentication-Results": "mx.example.test; dmarc=pass" },
      "body": "我要退货退款，但邮件里忘了写订单号，请帮我处理。"
    },
    {
      "subject": "退货 订单#2042",
      "from": "customer-c@example.test",
      "headers": { "Authentication-Results": "mx.example.test; dmarc=fail" },
      "body": "订单#2042的耳机有故障，申请全额退款。"
    }
  ],
  "orders": {
    "#2041": { "financialStatus": "paid", "currency": "CNY", "deliveredAt": "2026-09-20T08:00:00Z", "lineItems": [ { "name": "蓝色卫衣", "quantity": 1, "price": 259, "tags": [] } ] },
    "#2042": { "financialStatus": "paid", "currency": "CNY", "deliveredAt": "2026-09-25T08:00:00Z", "lineItems": [ { "name": "无线耳机", "quantity": 1, "price": 399, "tags": [] } ] }
  }
}