💬 Shopify Canceled Order Recovery via WhatsApp

Recover lost sales automatically by checking customers’ WhatsApp numbers and sending personalized discount codes for canceled orders. Perfect for Shopify store owners, marketing teams, and customer-success teams who want to recover revenue with minimal effort.

---

Who Is This For?

• Shopify store owners looking to recover canceled orders
• Marketing teams wanting personalized customer outreach
• Customer-success teams aiming to boost repeat purchases

No manual work required—everything is automated and tracked.

---

What This Workflow Does

• Detects canceled Shopify orders on a set schedule
• Fetches order and customer data
• Creates personalized recovery messages including discount codes
• Verifies WhatsApp numbers via Rapiwa API
• Logs results in Google Sheets:
  • "Verified & Sent" for successful messages
  • "Unverified & Not Sent" for invalid numbers

---

Requirements

• Shopify store with API access
• Shopify API credentials with orders and customer data access
• Rapiwa account with a valid Bearer token
• Google account with Sheets access and OAuth2 credentials

---

Setup Plan

1. Add Credentials

   • Rapiwa: HTTP Bearer credential in n8n (example: Rapiwa Bearer Auth)
   • Google Sheets: OAuth2 credential (example: Google Sheets)

2. Configure Shopify

   • Replace your_shopify_domain and API token with your store credentials

3. Set Up Google Sheets

   • Update spreadsheet ID and sheet gid
   • Ensure column headers match mapping keys exactly

4. Schedule Trigger

   • Set the workflow to check for canceled orders at your preferred interval

5. Verify HTTP Request Nodes

   • Verify endpoint: Rapiwa’s verifyWhatsAppNumber
   • Send endpoint: Rapiwa’s send-message API with templated messages

---

Google Sheet Column Structure

Sample Sheet

Name	Number	Item Name	Coupon	Item Link	Validity	Status
Abdul Mannan	8801322827799	Samsung Galaxy S24 Ultra 5G	REORDER5	Re-order Link	verified	sent
Abdul Mannan	8801322827790	Samsung Galaxy S24 Ultra 5G	REORDER5	Re-order Link	unverified	sent

---

Important Notes

• Use n8n credentials; do not hard-code API keys
• Google Sheets headers must exactly match mapping keys
• Update message templates if referencing different data
• Adjust batch size to avoid API rate limits

---

Useful Links

• Install Rapiwa
• Rapiwa Dashboard
• Official Website
• Rapiwa Documentation
• Shopify API Documentation

---

Support & Help

• 💬 WhatsApp
• 🖥 Website
• 🛠 Discord Community
• 📘 Facebook Group
• 👨‍💻 Developer Portfolio

---

💡 Recover canceled orders automatically—verify numbers, send personalized discount codes, and track all messages seamlessly.