Main Content
Lembaga Kita Journal Portal

Abstract

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.

Keywords

Inventory System Google Apps Script Google Sheets Black Box Testing Business Operations

How to Cite

Citation Format
Sari, N. L., Lestari, S., & Betty Yel, M. (2026). Implementation of a Web-Based Inventory System to Support Operations at Hanbai Photocopy. International Journal Software Engineering and Computer Science (IJSECS), 6(3), 1111-1120. https://doi.org/10.35870/ijsecs.v6i3.8308

References

20 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

Author Biographies

Nandini Ladivina Sari, Sekolah Tinggi Ilmu Komputer Cipta Karya Informatika

Department of Information Systems, Faculty of Computer Technology, Sekolah Tinggi Ilmu Komputer Cipta Karya Informatika, East Jakarta City, Special Capital Region of Jakarta, Indonesia.

Sri Lestari, Sekolah Tinggi Ilmu Komputer Cipta Karya Informatika

Department of Information Systems, Faculty of Computer Technology, Sekolah Tinggi Ilmu Komputer Cipta Karya Informatika, East Jakarta City, Special Capital Region of Jakarta, Indonesia.

Mesra Betty Yel, Sekolah Tinggi Ilmu Komputer Cipta Karya Informatika

Department of Information Systems, Faculty of Computer Technology, Sekolah Tinggi Ilmu Komputer Cipta Karya Informatika, East Jakarta City, Special Capital Region of Jakarta, Indonesia.

License

Copyright (c) 2026 Nandini Ladivina Sari, Sri Lestari, Mesra Betty Yel

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

This is an open-access journal distributed under the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits unrestricted use, distribution, reproduction, and adaptation in any medium (even commercially), provided appropriate credit is given to the original author(s), a link to the license is provided, and any changes made are indicated. Authors retain copyright without restrictions and grant the journal the right of first publication as well as non-exclusive publishing rights for archiving, indexing, and scholarly dissemination.

Downloads

OJS UsageStats Plugin
Download data is not yet available.

Most read articles by the same author(s)

Contrimetric

Recommended Articles