PRODUCT INVENTORY MANAGEMENT SYSTEM IN KNM MINI MART

Abstract

This study proposes a product inventory management system specifically developed for KNM MINI MART to enhance stock control and operational efficiency. The system helps prevent stock shortages by accurately monitoring inventory levels and organizing product data for easy access. It also features an expiration tracking function to ensure that outdated products are identified and removed before reaching customers. Development of the system was carried out using Apache NetBeans 2025. The researchers adopted the Waterfall Model of the Software Development Life Cycle (SDLC) to guide the system development process. This method includes the stages of planning, analysis, design, development, testing, implementation, and maintenance. Key activities involved assigning team roles, conducting interviews with the client, defining the research scope, designing the system’s interface and structure, building the system, and performing testing before deployment. The process concludes with ongoing system maintenance to ensure long-term performance and reliability. The Product Inventory Management System aims to enhance the overall efficiency of the client’s business. It enables better control of stock levels, ensures well-organized product data, and facilitates accurate monitoring of product expiration dates to prevent the sale of expired items. The Product Inventory Management System is designed to resolve the client's operational issues, such as inefficient stock handling, unorganized product information, and the lack of expiration date monitoring. By implementing this system, the business benefits from improved operational efficiency, faster transactions, and simplified employee tasks.

System access is restricted to the admin (or owner) and designated users (employees). The admin holds exclusive privileges, including managing employee accounts and assigning specific roles. Employees, based on their roles, can access various system features such as the dashboard, adding new product entries, monitoring stock levels and product expiration dates, reviewing sales data and notifications, and viewing categorized product lists.