Implementation of a Web-Based Inventory System to Support Operations at Hanbai Photocopy

Hanbai Photocopy is a micro-enterprise providing photocopying and office stationery retail services that requires structured inventory management to maintain seamless daily operations. Previously, inventory tracking relied entirely on paper-based ledger records, which frequently resulted in recording discrepancies between physical stock and written logs, slow search retrieval, and time-consuming report compilation. This study aims to design and implement a web-based inventory management system to support operations at Hanbai Photocopy through centralized and automated data administration. The research adopted a qualitative case study methodology, collecting operational data through direct field observation, semi-structured interviews with the business owner, and literature review. System development followed the classical Waterfall lifecycle, encompassing requirements analysis, system design, implementation, testing, and maintenance. The application was constructed using Google Apps Script as the execution platform and Google Sheets as the relational cloud database, enabling a cost-effective serverless architecture without independent hosting requirements. Functional validation was conducted through black box testing across key functional requirements, including master data management, transaction logging, automated stock validation, role-based access control, and activity auditing. The results demonstrate that all planned test scenarios executed successfully, effectively preventing invalid stock deductions and enabling real-time inventory adjustments. The operational deployment facilitates structured stock tracking, mitigates manual recording errors, and streamlines periodic reporting, thereby improving operational efficiency at Hanbai Photocopy.