Send Shopify shipping tracking WhatsApp notifications with full tracking info

Order Fulfillment & Shipping Notification System Automatically notify customers via WhatsApp when their orders ship, with intelligent phone validation, multi-country support, and bilingual messaging including complete tracking information. What does this workflow do? When you fulfill an order in Shopify, this workflow instantly updates your database, validates the customer's phone number across 23+ countries, and sends a professional WhatsApp notification with full tracking details in their preferred language. Key features: - 🌍 23+ Country Phone Validation - Automatically detects and formats phone numbers for GCC, MENA, and international customers - 📦 Complete Tracking Info - Includes tracking number, courier name, and clickable tracking URL - 🌐 Smart Bilingual Messaging - Arabic and English with luxury brand tone - 💾 Real-time Database Sync - Updates order status and shipping details instantly - 🔒 Test Number Protection - Blocks notifications to development phone numbers - ✨ Personalized Messages - Addresses customers by first name - ⏱️ Delivery Expectations - Communicates clear 7-12 business day timeline - 🎯 International Format - Handles phone numbers with automatic country code detection Setup Requirements Integrations Needed: 1. Shopify - For order fulfillment webhooks 2. PostgreSQL - For order and customer data storage 3. WhatsApp Business API - For sending notifications via Facebook Graph API Credentials Required: - Shopify Access Token (with fulfillment webhook permissions) - PostgreSQL database credentials - WhatsApp Business API Bearer Token (Facebook Graph API v18.0) How to Use 1. Import the workflow into your n8n instance 2. Configure credentials: - Add your Shopify store access token - Connect your PostgreSQL database - Add your WhatsApp Business API credentials 3. Update test phone numbers in filter nodes (If10 and If11) with your actual test numbers 4. Customize brand name in WhatsApp message templates if needed (currently "" / "") 5. Activate the workflow to start sending shipping notifications Workflow Structure 1. Trigger (Shopify Webhook) Listens for fulfillments/create events when orders are marked as shipped in Shopify 2. Update Order Status Updates PostgreSQL database with: - Status changed to 'shipped' - Shipping company name - Tracking number 3. Customer Lookup Retrieves customer record from database using phone number from fulfillment data 4. Phone Validator (Code Node) Intelligent phone number formatting: - Detects country from shipping address - Validates and cleans phone number - Adds appropriate country code if missing - Supports 23 countries across GCC, MENA, and international markets - Ensures proper international format (+CountryCode) 5. Get Customer Preferences Retrieves language preference and first name for personalization 6. Language Detection Routes workflow based on customer's preferred language (Arabic vs. English) 7. Test Number Filter Prevents notifications to internal/development phone numbers 8. WhatsApp Notification Sends comprehensive shipping notification with tracking details in customer's language Supported Countries & Codes GCC Region: - 🇴🇲 Oman (968) - 🇦🇪 UAE (971) - 🇸🇦 Saudi Arabia (966) - 🇰🇼 Kuwait (965) - 🇶🇦 Qatar (974) - 🇧🇭 Bahrain (973) MENA Region: - 🇯🇴 Jordan (962) - 🇪🇬 Egypt (20) - 🇮🇶 Iraq (964) - 🇱🇧 Lebanon (961) - 🇸🇾 Syria (963) - 🇵🇸 Palestine (970) - 🇾🇪 Yemen (967) International: - 🇺🇸 USA (1) - 🇬🇧 UK (44) - 🇩🇪 Germany (49) - 🇫🇷 France (33) - 🇮🇹 Italy (39) - 🇪🇸 Spain (34) - 🇹🇷 Turkey (90) - 🇮🇳 India (91) - 🇵🇰 Pakistan (92) Message Templates Arabic Message (عربي): مرحبًا الاسم، يسرّنا إعلامكم بأنه تم شحن طلبكم بنجاح. رقم الطلب: orderid رقم التتبع: trackingnumber شركة الشحن: couriername رابط التتبع: trackingurl المدة المتوقعة للتوصيل: من 7 إلى 12 يوم عمل. يمكنكم متابعة حالة الشحنة عبر رقم التتبع، وسنحرص على إبقائكم على اطلاع حتى استلام الطلب. مع أطيب التحيات، English Message: Hello Name, We are pleased to inform you that