Design and Development of an Integrated Web-Based Sales and Inventory Management System for a Grocery Store

Abstract:This study presents the development of an Integrated Web-Based Sales and Inventory Management System designed for an emerging grocery store. The project addresses the challenges of manual record-keeping, such as human error, inconsistent stock monitoring, and delayed reporting.The system provides a centralized platform for real-time transaction recording, automated inventory updates, and secure user management. Developed using the Agile methodology, the system utilizes PHP for the backend, MySQL for the database (3NF normalized), and HTML/CSS for the frontend interface. Key features include Role-Based Access Control (RBAC) for Admin and Cashier roles and automated generation of sales and stock reports. The final output demonstrates improved operational efficiency, data accuracy, and secure information management for small-scale retail businesses. OUR SOFTWARE ADVISER: Mrs. Rose Ann SP. Rayon || roseannsanpascual102093@gmail.com