Manage coupon campaigns and customer chats with WhatsApp and PostgreSQL

Coupon Bot Dashboard & WhatsApp Management System

A complete bilingual admin dashboard and WhatsApp bot solution for managing discount coupons, partner companies, and customer conversations through an intuitive web interface and automated chatbot.

What does this workflow do?

This workflow provides a comprehensive coupon management system with dual interfaces: a modern Vue.js admin dashboard for managers and an interactive WhatsApp bot for customers. It handles everything from company onboarding and coupon issuance to real-time customer support and conversation tracking.

Key features: - 🎛️ Admin Dashboard - Full-featured Vue.js 3 interface with Tailwind CSS for managing companies, coupons, and viewing analytics - 🤖 WhatsApp Bot - Automated customer service bot with session-based state management - 🏢 Company Management - CRUD operations for partner companies and their coupon catalogs - 🎫 Advanced Coupon System - Support for percentage/fixed discounts, expiry dates, minimum purchase requirements, and maximum discount caps - 💬 Real-time Inbox - Live chat interface for viewing customer conversation history - 🌐 Bilingual Support - Full Arabic (RTL) and English interface support - 📊 Analytics Dashboard - Track customers, messages, coupons issued, and partner companies - 🔧 Database Tools - Built-in schema initialization and migration capabilities - 👤 Role-Based Access - Separate admin and customer flows with phone number authentication

Setup Requirements

Integrations Needed: 1. PostgreSQL - Primary database for all system data 2. WhatsApp Business API - For customer bot interactions via Facebook Graph API 3. n8n - Workflow automation platform (self-hosted or cloud)

Credentials Required: - PostgreSQL database credentials (host, port, database, user, password) - WhatsApp Business API Bearer Token (Facebook Graph API v22.0) - Phone Number ID from WhatsApp Business account