Implementation of a Web-Based Inventory System to Support Operations at Hanbai Photocopy
DOI:
https://doi.org/10.35870/ijsecs.v6i3.8308Keywords:
Inventory System, Google Apps Script, Google Sheets, Black Box Testing, Business OperationsAbstract
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.
Downloads
References
Abdulloh, R. (2018). 7 in 1 pemrograman web untuk pemula. PT Elex Media Komputindo.
Afifah, F. N. (2023). Konsep sistem informasi (konsep dan penerapan). Yayasan Literasi Sains Indonesia.
Aghniya, A., Rivai, A. M., Febisatria, A., Harun, N., & Azza, N. (2025). Penerapan metode First In First Out (FIFO) dalam peningkatan kinerja operasional sektor ritel di Indonesia. Jurnal Akademik Ekonomi dan Manajemen, 2(4), 181–192. https://doi.org/10.61722/jaem.v2i4.7265
Anwar, M. S., Nindyasari, R., & Murti, A. C. (2025). Implementasi aplikasi persediaan barang berbasis web. JATI (Jurnal Mahasiswa Teknik Informatika), 9(4), 7166–7171. https://doi.org/10.36040/jati.v9i4.14418
Denovya, A. R., & Voutama, A. (2026). Development of a web-based chemical laboratory inventory system using the prototype model. Jurnal Ilmiah Sistem Informasi, 5(2), 363–381. https://doi.org/10.51903/juisi.v5i2.1577
Google Developers. (2024). Apps Script overview [Technical documentation]. https://developers.google.com/apps-script
Google. (2024). Google Sheets: Online spreadsheet editor [Software documentation]. https://www.google.com/sheets/about/
Heryanto, A., Fuad, H., & Dananggi, D. (2014). Rancang bangun sistem informasi inventory barang berbasis web studi kasus di PT. Infinetworks Global Jakarta. Sisfotek Global, 4(2), 2–5.
Hidayat, T., & Muttaqin, M. (2018). Pengujian sistem informasi pendaftaran dan pembayaran wisuda online menggunakan black box testing dengan metode equivalence partitioning dan boundary value analysis. Jurnal Teknik Informatika UNIS, 6(1), 25–29. https://doi.org/10.33592/jutis.v6i1.278
Hidrawan, M. A., Badawi, A., & Fachri, B. (2026). Perancangan sistem informasi pengelolaan inventaris barang berbasis web di SMA Negeri 5 Binjai. JUKTISI (Jurnal Kemahasiswaan Teknologi Informasi dan Sains), 5(1), 257–266. https://doi.org/10.55338/juktisi.v5i1.745
Islamiah, R., & Roslina, R. (2025). Rancang bangun sistem manajemen inventory barang sample berbasis web pada divisi pemasaran (Studi kasus: PT. Berjaya Abadi). Indonesian Journal of Informatic Research and Software Engineering (IJIRSE), 5(1), 60–67. https://doi.org/10.57152/ijirse.v5i1.1396
Mulyati, Y. S. (2017). Konsep sistem informasi. CV. Andi Offset.
Nugroho, A. Y. (2025). Sistem dan teknik manajemen inventory. Gemilang Press Indonesia.
Pressman, R. S. (2014). Software engineering: A practitioner's approach (8th ed.). McGraw-Hill.
Qisthina, N. A. C., Andarwati, M., & Putri, D. M. (2025). Desain sistem informasi inventaris barang untuk usaha mikro kecil dan menengah (UMKM) berbasis website. Journal of Information System and Application Development, 3(1), 47–57. https://doi.org/10.26905/jisad.v3i1.15396
Saputra, D., Ratnasari, M., Azhari, A., & Maisaroh, M. (2026). Pengembangan website ujian online berbasis Google Apps Script dan Google Spreadsheet. Indonesian Journal of Multidisciplinary on Social and Technology, 4(3), 2278–2288. https://doi.org/10.69693/ijmst.v4i3.12603
Sekti, B. A., Gusti, A. P., & Erzed, N. (2024). Perancangan sistem informasi stok barang berbasis web dengan metode FIFO. Jurnal Teknologi Informatika dan Komputer, 10(2), 506–518. https://doi.org/10.37012/jtik.v10i2.2253
Sugiyono. (2019). Metode penelitian kuantitatif, kualitatif, dan R&D. Alfabeta.
Suryawinata, M. (2019). Pengembangan aplikasi berbasis web. Umsida Press.
Wau, K. (2022). Pengembangan sistem informasi persediaan gudang berbasis website dengan metode waterfall. Jurnal Teknik, Komputer, Agroteknologi dan Sains, 1(1), 10–23. https://doi.org/10.56248/marostek.v1i1.8
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Nandini Ladivina Sari, Sri Lestari, Mesra Betty Yel
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
