Food Ordering ChatBot using Dialogflow

This project is an AI-powered Food Ordering Chatbot designed to simulate a real-world food ordering and tracking experience. The chatbot allows users to place food orders conversationally, modify orders dynamically, complete orders, and track order status — all through natural language interaction.

The system is built using Dialogflow ES for intent handling, FastAPI for backend webhook processing, and MySQL for persistent order storage.

This project demonstrates strong concepts in backend development, stateful conversations, API integration, and database-driven business logic.

🧩 Problem Statement

Traditional food ordering systems rely on rigid user interfaces and manual navigation.
This project explores how conversational AI can simplify the food ordering experience by allowing users to place, modify, and track orders using natural language, while maintaining conversational state and backend consistency.

✨ Key Features

🗣️ Natural language food ordering using Dialogflow
➕ Add multiple food items with quantities
➖ Remove items partially (e.g., remove 1 biryani from 2 biryani)
🔄 Maintain session-based in-progress orders
📦 Generate unique order IDs on order completion
📍 Track order status using order ID
🗄️ Persistent storage using MySQL & stored procedures
🌐 Web-based chatbot UI using Dialogflow Messenger

🛠️ Tech Stack

1. Frontend
   • HTML
   • CSS
   • Dialogflow Messenger
     
     
2. Backend
   • Python
   • FastAPI (Webhook Server)
     
     
3. AI / NLP
   • Dialogflow ES (Intents, Entities, Contexts)
     
     
4. Database
   • MySQL
     
     

🧠 System Architecture

User interacts with the chatbot through a web interface powered by Dialogflow Messenger.
Dialogflow processes user input using NLU and triggers a webhook request to the FastAPI backend.
The backend handles business logic, manages conversational state, and interacts with a MySQL database for order persistence and tracking.

User (Browser)
↓
Dialogflow Messenger
↓
Dialogflow ES (NLU, Intents, Contexts)
↓
FastAPI Webhook (Python)
↓
MySQL Database

📸 Project Screenshots

New Order

Order Tracking