Roles & Stack
Impact
- Eliminated 5-15 minute 'dead zone' in order processing
- Reduced order-to-rider dispatch time to <1 second
- Zero commission fees by bypassing third-party delivery platforms
- Automated identity mapping eliminates manual customer data entry
- Real-time receipt generation enhances customer trust
Year
2025
Category
Web Development
Deliverables
- React/Vite Admin Dashboard
- Node.js Webhook Architecture
- Supabase/PostgreSQL Database
- Automated Receipt Engine
- Customer Identity Mapping
Project Genesis & Strategic Vision
The transition to an 'online-only' model for a family-owned business presented a massive operational hurdle: Communication Fragmentation. Relying on manual chat monitoring meant the business was limited by the physical speed of the person reading messages.
SaucyKPS Bot v1 was developed to serve as the 'Digital Nervous System,' automating the flow of information between three distinct stakeholders: the Customer, the Kitchen, and the Delivery Fleet.
The Problem: The 'Manual Messaging' Bottleneck
Before the implementation of SaucyKPS, the operational workflow was plagued by several critical failure points. The Relay Lag created a 5–15 minute 'dead zone' where a staff member had to manually copy order details from the customer chat and paste them into the rider group, causing food to sit getting cold.
Identity Fragmentation meant there was no persistent way to track a customer's lifetime value—if a user changed their display name, their order history was effectively lost. The Verification Void left customers feeling insecure about where their money went until the food actually arrived, and Logistics Chaos saw riders 'double-pick' orders because there was no status-tracking mechanism.
The Solution: A Modular Automation Ecosystem
Instead of using inefficient 'polling,' I built a Node.js Webhook listener that ensures the moment a customer interacts with the bot, the server receives a push notification. This architecture allows for sub-second response times, making the 'digital restaurant' feel as responsive as a physical waiter.
I designed a custom SQL schema to move beyond simple chat interactions. Every user is indexed by their unique Telegram chat_id, allowing the restaurant to map @usernames to order histories, preferences, and delivery addresses—turning a chat app into a powerful Customer Relationship Management (CRM) tool.
I engineered a complex message-routing logic that manages three separate environments simultaneously: Customer DMs for private receipt delivery and order status updates, Kitchen/Admin Dashboard as a modern React/Vite interface where the owner accepts or rejects orders, and Rider Logistics Group as an automated dispatch feed that instantly notifies all available riders when an order is ready.
Technical Implementation: The Automation Flow
The automation flow begins when a customer triggers the bot via a /start or /menu command. The bot checks the Supabase database—if new, it captures the chat_id and @username. The web dashboard updates in real-time to show the incoming request.
Upon admin approval, the bot executes a sendMessage request to the Rider Group Chat ID, tagging the order as [UNCLAIMED]. Simultaneously, a professionally formatted Digital Receipt is sent to the customer's private messages, including a timestamped Order ID.
The tech stack leverages Node.js as the runtime, PostgreSQL (via Supabase) for database persistence, React + TypeScript + Tailwind for the Admin Dashboard frontend, and Telegram Bot API with Webhooks for real-time integration. The entire system is deployed via a Git-based workflow with npm dependency management.
Impact & Conclusion
The SaucyKPS Bot v1 transformed a chaotic group chat into a structured, data-driven enterprise. It successfully eliminated the 'Manual Dispatcher' role, allowing the restaurant to redirect labor costs into food quality and faster delivery times.
This project demonstrates that custom-built automation can empower small family businesses to compete effectively in the digital marketplace, providing them with professional-grade tools typically reserved for larger operations.
Gallery
Process visuals
Explore next
GDG Bacolod Community Platform
A web application built to serve as the digital home for the Google Developer Group (GDG) Bacolod chapter. As someone who organized events and managed creatives, I noticed how much time was spent on manual tasks like creating certificates and tracking event history. This platform automates those everyday community management tasks.