Whatsapp Ai Agent Mvp Development for Beverage Store with Stock Management and Order Processing

We are seeking a skilled freelancer to develop a Minimum Viable Product (MVP) for a WhatsApp AI Agent for a beverage store. This bot will handle customer interactions in Spanish (Argentina), manage stock, process orders, and facilitate delivery notifications.

Core Scope (MVP) Requirements:
*  WhatsApp Cloud API Integration: Implement the bot using WhatsApp Cloud API for reliable and scalable communication. Flows should be managed and orchestrated using n8n.
*  Stock Management: Develop a robust stock lookup system with fuzzy search and typo tolerance, providing the top 3 suggestions for product queries. The system will check stock from the store's primary database, utilizing Supabase as a cache, replica, or temporary primary database.
*  Order Processing: Enable customers to build multi-item orders. The system must validate stock availability, decrease stock upon order creation, and manage various order states (e.g., Pending, confirmed, preparing, out for delivery).
*  Customer Data & Payments: Implement placeholders for customer data and payment methods (cash, bank transfer, QR code). The bot should be able to send CBU/alias/payment links as needed based on the chosen method.
*  Delivery Notifications & Handoff: Send automated WhatsApp notifications to the delivery team. Implement a human handoff mechanism to an on-duty seller with a service level agreement (SLA) of 10-15 minutes for urgent queries or complex situations.
*  Interaction Logging: Ensure all bot interactions and transactions are logged for auditing and analysis.
*  Documentation: Provide a comprehensive README file and a handover video for easy setup and future maintenance.

Deliverables:
*  Git Repository: A well-structured Git repository (GitHub/GitLab) containing all source code.
*  N8n Flow JSON: Exported JSON files for all developed n8n workflows.
*  Optional FastAPI Backend: If applicable, a FastAPI application with endpoints for /stock, /order, /catalog, and /health.
*  Database Schema: DDL (Data Definition Language) scripts and seed data for the database.
*  Postman Collection: A Postman collection for testing all API endpoints.
*  Environment Configuration: An .env.example file for easy environment variable setup.
*  README: A detailed README file covering local and server setup instructions.
*  Handover Video: A 15-30 minute video demonstrating the system's functionality and setup process.