Aurora ChatBot
Full-Stack Product Discovery and Inquiry Platform Case Study
Aurora Living Designs is a production-focused catalog platform for handcrafted architectural products. It combines guided product browsing, category-first navigation, and a website-trained chatbot that answers customer questions instantly. The system includes a protected admin panel with product overview, recently added listings, category control, and inquiry management workflows.
Customer Chat Assistant
The chatbot is trained on the website's product and category data, so users can ask specific questions and get direct, useful answers while browsing. It helps customers compare options, understand what fits their project, and move forward without waiting for manual support.
Admin Control Panel
The admin panel provides platform overview with recently added products, category status, and inquiry visibility. Administrators can manage product entries, organize categories, and respond to customer intent from a centralized operations flow.
Key Features
Essential functionality designed for product discovery and admin operations
Website-Trained Chatbot
The assistant answers product questions using site-grounded catalog context.
Admin Overview Dashboard
Admins monitor platform health, recently added products, and inquiry activity in one place.
Product CRUD Workflow
The management layer supports create, update, and remove operations for catalog entries.
Category Operations
Categories are structured for cleaner navigation and scalable catalog growth.
Inquiry Pipeline
Customer inquiries are captured with product context for better follow-up accuracy.
Cloudinary Media Layer
Product images are uploaded and delivered through Cloudinary for consistent performance.
Role-Protected Access
JWT-backed auth and middleware guards secure admin-only operational routes.
Responsive Product UX
Catalog browsing and inquiry flows stay usable across desktop and mobile screens.
Category-First Discovery
Visitors navigate the catalog through meaningful groups instead of flat lists.
Operational Consistency
Centralized admin control reduces metadata drift and improves listing quality.
System Architecture
The frontend is built with React and state management layers, while the Express API handles business logic, authentication, and data access. Cloudinary is used for media storage and delivery, keeping the API focused on transactional workloads and platform behavior.
Database Architecture and ERD
MongoDB collections are centered around User, Product, Category, Inquiry, and Setting. Product-category mapping supports scalable browsing, while inquiry records preserve customer intent and product context for operational follow-up.
