Chigoziennam/pharmflow-whatsapp-ai — reverse-engineered prompt

Build me a WhatsApp AI assistant called PharmFlow for Nigerian pharmacy owners. I want the owner to chat with it like a business partner and record sales, check stock, update inventory, save supplier details, and ask questions like which drugs are selling fastest or what items are running low.

Use WhatsApp through Twilio, store the long term memory and business records in Supabase, use OpenRouter for the AI replies, and connect the flow with n8n. Add any small Python backend tools needed to make the workflow reliable. The bot should understand normal chat messages, save important events, remember past context, and give helpful business insight in simple language.

Please create the full working setup, including the n8n workflow, database tables, webhook logic, prompts for the AI, and clear setup instructions for environment variables. Keep it practical and easy for a small pharmacy owner to use. Look up current docs online if you need to.