WhatsApp Product Catalog Bot with PostgreSQL

This n8n workflow powers a WhatsApp bot integrated with a PostgreSQL database to deliver an interactive product catalog experience. In the basic version, it populates product data into the DB and enables users to fetch product lists and detailed info via WhatsApp. The advanced version expands this with category browsing, category-specific products, cart addition/removal/clearing, and a 'Buy' option that sends payment links, creating a full shopping flow without manual intervention.

Benefits include automating customer support and sales inquiries, reducing response times, and enabling 24/7 self-service shopping on WhatsApp—a popular channel for businesses. It saves significant time by handling DB queries, conversation logic, and cart state management automatically, minimizing developer effort for e-commerce bots.

Ideal for e-commerce stores, retailers, or service providers wanting to sell via messaging apps. Use cases: customer product discovery in procurement, upselling via chat, or integrating catalogs into support tickets. Easy setup with SQL scripts and credentials; customizable for schemas, displays, or additional fields like inventory checks.