Transform WhatsApp into a professional-grade helpdesk system. This Node.js bot integrates seamlessly with MySQL to create a structured ticketing workflow. Users initiate requests in private chat, and the system intelligently routes them to the correct department group. Agents can manage, track, and close tickets directly from their WhatsApp groups, ensuring support is fast, organized, and data-driven.

Features

• Automated Routing: Tickets are forwarded to specific WhatsApp groups based on selected categories.
• Database Persistence: Every ticket, status update, and user interaction is saved in MySQL for auditing.
• Intelligent Auto-Reminders: The bot automatically sends periodic status summaries of 'open' or 'pending' tickets to their respective groups, keeping agents alerted to unresolved tasks.
• Seamless Agent Interaction: Agents can continue standard group conversations normally; the bot remains dormant until triggered by specific system commands.
• Agent Command System: Use intuitive commands like /close, /confirm, or /transfer inside group chats to drive the ticket lifecycle.
• Smart Media Handling: Automatically attaches one primary media file to each ticket.
• Multi-Language Support: Localized responses for English, French, and Indonesian.
• Global Ticket Access: Users and agents can run /mytickets at any time to list and track the status of their assigned or requested tickets.
• Admin Dashboard: Easy configuration for group mapping, admin roles, and system pings.

Requirements

• Runtime: Node.js 18+
• Database: MySQL 8.0+
• Connectivity: A dedicated WhatsApp account (QR scan at initial setup)
• Environment: Basic knowledge of terminal/CLI and SQL

Quick Start Guide

Follow these steps to deploy your WhatsApp Helpdesk Bot.

Stage 1: Initial Setup

Prepare Account: Use a dedicated phone number with WhatsApp installed.

Install Dependencies:

npm install

Configure Environment: Edit the .env file with your MySQL credentials and timezone settings.

cp .env.example .env

Stage 2: Database Initialization

Run the SQL schema in your MySQL manager (e.g., phpMyAdmin, MySQL Workbench) to create the required tables.

Stage 3: Linking & Launch

Launch the Bot:

npm start

Scan QR: When the QR code appears in your terminal, scan it using WhatsApp on your phone (Linked Devices → Link a Device).

Session: The bot will save your session in an auth/ folder. It will auto-reconnect on restart.

Stage 4: Admin & Group Configuration

Connect Groups: Invite the bot to your WhatsApp groups.

Get JIDs: Send /list_groups to the bot in a private chat to get your group IDs.

Map Categories: Add group JIDs to config/groups.json.

Apply Changes: Send /reload_config to the bot in a private chat.

Stage 5: Daily Operation

Agents: Work inside your groups. Use commands like /confirm to update tickets or /mytickets to list assigned tasks.

Users: Message the bot in private chat. Use /request to open tickets or /mytickets to track progress.

Reminders: The bot will periodically post open/pending ticket summaries to your groups automatically.