The Smart Retail Query and Alert System harnesses generative AI to transform the shopping experience in the apparel and footwear sector. Designed for both customers and administrators, the system provides an integrated platform where end-users can easily register, log in, browse products, manage carts, and complete orders with a streamlined interface. For administrators, the platform offers secure access and robust product management capabilities, including the addition, update, and removal of items, along with comprehensive order processing from acceptance to delivery. A key feature of the system is its integration with the Gemini API, which enables prompt-driven database interactions for real-time updates and intelligent alert management. This dual-faceted approach not only enhances operational efficiency but also delivers personalized, data-driven insights, paving the way for a responsive and innovative retail environment.

Keywords: Smart Retail, Generative AI, Gemini API, Apparel, Footwear, E-commerce, Customer Experience, Product Management, Real-Time Updates, Intelligent Alert Management, Data-Driven Insights, Administrative Functionality