ORDER PROCESSING PIPELINE ARCHITECTURE
═══════════════════════════════════════════════════════════════

  ORDER SOURCE (Choose one):
  ├── Shopify Webhook → n8n Shopify Trigger (native node)
  ├── Daraz Seller API → n8n HTTP Request (polling every 30 min)
  ├── Daraz Email → n8n Gmail Trigger (parse order emails)
  └── WooCommerce → n8n WooCommerce Trigger (native node)
         │
         ▼
  DATA EXTRACTION (Set Node):
  ├── Order ID
  ├── Customer name + phone number
  ├── Product name + quantity + SKU
  ├── Total amount (PKR)
  ├── Shipping city + address
  └── Payment method (COD / JazzCash / Card)
         │
         ▼
  ROUTING (IF Nodes):
  ├── IF amount > PKR 5,000 → VIP notification to owner
  ├── IF payment = COD → Add to COD tracking sheet
  ├── IF city = Karachi → Same-day dispatch flag
  └── IF inventory < 5 → Low stock alert
         │
         ▼
  NOTIFICATIONS:
  ├── Customer → WhatsApp confirmation via WATI
  ├── Supplier → WhatsApp pick-list via WATI
  ├── Owner → Daily summary at 6 PM PKT
  └── Warehouse → Real-time Slack/WhatsApp alert
         │
         ▼
  LOGGING:
  ├── Google Sheets → Order database
  ├── Inventory sheet → Auto-decrement stock
  └── Monthly analytics → Revenue, city breakdown, AOV

═══════════════════════════════════════════════════════════════

// Extract and rename fields for clarity
order_id: {{$json.id}}
customer_name: {{$json.billing_address.first_name}} {{$json.billing_address.last_name}}
customer_phone: {{$json.billing_address.phone}}
product_name: {{$json.line_items[0].name}}
quantity: {{$json.line_items[0].quantity}}
total_pkr: {{$json.total_price}}
city: {{$json.shipping_address.city}}
payment_method: {{$json.payment_gateway_names[0]}}
order_date: {{new Date().toLocaleString('en-PK', {timeZone: 'Asia/Karachi'})}}

ROUTING RULES FOR PAKISTANI E-COMMERCE
═══════════════════════════════════════════════════════════════

  RULE 1: VIP ORDER (amount > PKR 5,000)
  ├── → WhatsApp to owner with VIP flag
  └── → Priority processing queue

  RULE 2: COD ORDER (payment = cash_on_delivery)
  ├── → Add to COD tracking sheet
  ├── → Customer gets "COD amount: PKR X ready at delivery"
  └── → Rider gets COD collection amount

  RULE 3: SAME-DAY ELIGIBLE (city = Karachi + order before 2 PM)
  ├── → Flag as same-day dispatch
  └── → Warehouse gets urgent alert

  RULE 4: LOW INVENTORY (remaining stock < 5)
  ├── → Alert to procurement team
  └── → Consider pausing product listing

═══════════════════════════════════════════════════════════════

HTTP Request Configuration:
  Method: POST
  URL: https://live-server-XXXXX.wati.io/api/v1/sendTemplateMessage
       ?whatsappNumber=92{{$json.customer_phone}}
  Headers: Authorization: Bearer YOUR_WATI_TOKEN
  Body (JSON):
  {
    "template_name": "order_confirmation",
    "broadcast_name": "order_{{$json.order_id}}",
    "parameters": [
      {"name": "customer_name", "value": "{{$json.customer_name}}"},
      {"name": "order_id", "value": "{{$json.order_id}}"},
      {"name": "total", "value": "PKR {{$json.total_pkr}}"},
      {"name": "dispatch_time", "value": "24-48 hours"}
    ]
  }

Assalam o Alaikum {{customer_name}}!

Aapka order #{{order_id}} receive ho gaya hai.
Amount: PKR {{total}}
Dispatch time: {{dispatch_time}}

JazzCash/Easypaisa se payment confirm ho chuki hai.
Tracking details jald bheje jayenge. Shukriya!

Naya Order!
Order #: {{$json.order_id}}
Product: {{$json.product_name}}
Qty: {{$json.quantity}}
Ship to: {{$json.city}}
Dispatch by: {{same_day ? "TODAY" : "Tomorrow"}}

DARAZ INTEGRATION STRATEGIES
═══════════════════════════════════════════════════════════════

  STRATEGY 1: EMAIL PARSING (Most reliable for small sellers)
  ├── Gmail Trigger → Watch for emails from "noreply@daraz.pk"
  ├── Code Node → Parse order details from email HTML
  ├── Extract: order ID, customer, product, amount
  └── Feed into same WATI + Sheets pipeline

  STRATEGY 2: SELLER API (For registered API users)
  ├── HTTP Request → GET /orders?status=pending
  ├── Schedule Trigger → Poll every 30 minutes
  ├── Compare against existing orders in Sheet
  ├── New orders → trigger notification pipeline
  └── Requires: Daraz Open Platform developer account

  STRATEGY 3: APIFY SCRAPER (For Seller Center scraping)
  ├── HTTP Request → Apify's Daraz scraper actor
  ├── Returns order list as JSON
  ├── Schedule every 30 minutes
  └── Cost: Apify free tier (1,000 results/month)

═══════════════════════════════════════════════════════════════

Daily Order Summary (WhatsApp to Owner):

*Orders Today — {{date}}*

Total orders: 12
Total revenue: PKR 87,500
Average order: PKR 7,292

*By City:*
Karachi: 7 orders (PKR 52,000)
Lahore: 3 orders (PKR 24,500)
Islamabad: 2 orders (PKR 11,000)

*Pending Actions:*
- 3 COD orders need rider assignment
- 1 order flagged as VIP (PKR 15,000)
- Low stock alert: Blue Kurta (2 remaining)