Implementation of a Web-Based Inventory Monitoring System at Optik Sanjaya Depok
DOI:
https://doi.org/10.35870/ijsecs.v6i3.8249Keywords:
Stock Monitoring System, Web-Based Information System, Inventory Management, Waterfall Method, Optical Retail MSMEAbstract
Optik Sanjaya Depok, a micro, small, and medium enterprise (MSME) engaged in eyewear retail, still recorded its eyeglasses stock manually in handwritten ledgers, which frequently resulted in recording errors, delayed stock updates, difficulty in determining available items, and time-consuming report preparation. This study aimed to design and implement a web-based stock monitoring system to establish more structured, efficient, and traceable inventory management for the store. The system was developed using the Waterfall software development life cycle, covering requirement analysis, Unified Modeling Language (UML) and Entity-Relationship Diagram (ERD) design, implementation using PHP Native, MySQL, and Bootstrap, and testing. The system provides role-separated access for the Administrator and the Warehouse Admin, a summary dashboard, user management, item and item-category data management, incoming-stock and outgoing-stock recording that automatically updates item quantities, real-time stock monitoring, stock reporting with Excel export, and DataTables-based search, filter, sort, and pagination. Black box testing was applied to ten core features, and every test scenario produced the expected result. User Acceptance Testing using a five-point Likert-scale questionnaire completed by two respondents consisting of the owner and warehouse staff of Optik Sanjaya Depok yielded average scores between 4.7 and 4.9 (overall average 4.82). The system replaced the manual recording process and supported centralized, consistent stock recording; the reduction of stock-data errors was not measured quantitatively in this study and is therefore not claimed as a research finding. These findings indicate that a role-based, web-based stock monitoring system is a feasible initial step in the digital transformation of small-scale optical retail businesses.
Downloads
References
Adha, N. (2022). Website inventaris barang menggunakan metode Waterfall untuk pengelolaan persediaan barang pada Bidang Prasarana dan Pengembangan Transportasi DISHUB Singkawang. Jurnal Sistem Informasi Akuntansi, 3(2), 51–61. https://doi.org/10.31294/justian.v3i2.1506
Alfarizi, M., & Priyadi, W. (2024). Sistem informasi inventory kacamata berbasis web pada Toko Optik Nouglasses Bekasi. Journal of Information Systems Management and Digital Business, 1(2), 176–188. https://doi.org/10.59407/jismdb.v1i2.404
Aliyah, A., Hartono, N., & Muin, A. A. (2025). Penggunaan User Acceptance Testing (UAT) pada pengujian sistem informasi pengelolaan keuangan dan inventaris barang. Switch: Jurnal Sains dan Teknologi Informasi, 3(2), 42–58. https://doi.org/10.62951/switch.v3i1.330
Ananda, A., Butsianto, S., & Sulaeman, A. (2024). Penerapan metode Waterfall pada sistem informasi inventory berbasis website. Journal of Information System Research (JOSH), 5(4), 1147–1155. https://doi.org/10.47065/josh.v5i4.5669
Aprilisa, S., & Aulia, R. (2024). Penerapan metode prototype dalam pengembangan sistem informasi inventory barang berbasis web. Jurnal Teknik Industri Terintegrasi (JUTIN), 7(1), 333–340. https://doi.org/10.31004/jutin.v7i1.24749
Artino, R., & Istiyani, Y. (2025). Analisis implementasi sistem informasi pengajuan pas bandara Sultan Thaha Jambi dengan black box testing. Bridge: Jurnal Publikasi Sistem Informasi dan Telekomunikasi, 3(3), 161–172. https://doi.org/10.62951/bridge.v3i3.360
Damanik, F., Meilano, R., & Wr, T. (2021). Pengembangan sistem informasi persediaan barang dengan metode Waterfall. Jurnal Elektronika, Listrik, dan Teknologi Informasi Terapan, 2(2), 26–30. https://doi.org/10.37338/e.v2i2.153
Fahrizal, P., & Azhar, N. C. (2025). Perancangan sistem informasi laporan inventori bahan baku berbasis web dengan metode Waterfall pada Kedai Kopi Disiniaja. Infomatek, 27(1), 153–164. https://doi.org/10.23969/infomatek.v27i1.24838
Fathoni, M., & Kustiyono. (2025). Pengembangan sistem informasi persediaan barang menggunakan model Waterfall untuk meningkatkan efisiensi pengelolaan stok. Jurnal Algoritma, 22(2), 523–532. https://doi.org/10.33364/algoritma/v.22-2.2533
Faturrachman, M. S., Huda, B., Nurapriani, F., & Hilabi, S. S. (2025). Perancangan aplikasi manajemen stok barang berbasis web menggunakan metode Waterfall dengan modul barang masuk, barang keluar dan permintaan barang. Jurnal Mahasiswa Teknik Informatika (JATI), 9(5), 10189–10196. https://doi.org/10.36040/jati.v9i5.15198
Hady, E. L., Haryono, K., & Rahayu, N. W. (2020). User Acceptance Testing (UAT) pada purwarupa sistem tabungan santri (Studi kasus: Pondok Pesantren Al-Mawaddah). Jurnal Ilmiah Multimedia dan Komunikasi, 5(1), 1–10. https://doi.org/10.56873/jimk.v5i1.64
Hikmal, M., Yudertha, A., & Ramadhani, Y. (2025). Perancangan sistem informasi manajemen stok material berbasis web di Gudang PLN ULP Telanaipura Jambi. RIGGS: Journal of Artificial Intelligence and Digital Business, 4(3), 4845–4856. https://doi.org/10.62951/riggs.v4i3.504
Imam, B. (2020). Sistem informasi penjualan kacamata berbasis web pada Indo Optikal Jakarta Timur [Undergraduate thesis, Universitas Nusa Mandiri]. Repository Universitas Nusa Mandiri.
Indarto, A. K., Purwahana, R., & Syahputra, S. L. (2022). Sistem informasi penjualan kacamata toko Optik Kunanti berbasis Android. Go Infotech: Jurnal Ilmiah STMIK AUB, 28(2), 195–206. https://doi.org/10.36309/goi.v28i2.179
Mahardika, F., Fitriani, A., & Al'Amin, M. (2023). Testing sistem pada Dealer Management System Service menggunakan metode black box testing. Hello World: Jurnal Ilmu Komputer, 2(3), 139–144. https://doi.org/10.56211/helloworld.v2i3.364
Narulita, S., Nugroho, A., & Abdillah, M. Z. (2024). Diagram Unified Modelling Language (UML) untuk perancangan sistem informasi manajemen penelitian dan pengabdian masyarakat (SIMLITABMAS). Bridge: Jurnal Publikasi Sistem Informasi dan Telekomunikasi, 2(3), 244–256. https://doi.org/10.62951/bridge.v2i3.155
Ramadhan, F. A., Amsory, M. I., Ikhsan, M., & Haryono, W. (2025). Perancangan sistem informasi manajemen stok barang berbasis web menggunakan model Waterfall pada Toko Dhanisa Mandiri Jaya. Router: Jurnal Teknik Informatika dan Terapan, 3(2), 127–138. https://doi.org/10.62951/router.v3i2.509
Ridwansyah, R., Rifqie, D. M., & Nuridayanti, N. (2023). Sistem informasi inventaris toko berbasis web untuk UMKM penyewaan kostum. Jurnal Teknologi dan Sistem Informasi Bisnis, 5(3), 289–295. https://doi.org/10.47233/jteksis.v5i3.874
Setiawan, A. B., Rachmawati, W., Arrahman, A. T., Natasyah, N., & Fadil, F. N. S. (2021). Aplikasi monitoring stok barang berbasis web pada PT. Intermetal Indo Mekanika. ADI Bisnis Digital Interdisiplin Journal, 2(2), 1–6. https://doi.org/10.34306/abdi.v2i2.254
Shadiq, J., Safei, A., & Ratu Loly, R. W. (2021). Pengujian aplikasi peminjaman kendaraan operasional kantor menggunakan black box testing. Information Management for Educators and Professionals, 5(2), 97–110. https://doi.org/10.51211/imbi.v5i2.1557
Suhada, M. R., Muchsam, Y., Firizkiansah, A., & Ardiansyah, M. (2026). Rancang bangun sistem monitoring stok barang berbasis web untuk meningkatkan efisiensi manajemen persediaan barang pada UMKM. JIKOMTI: Jurnal Ilmiah Ilmu Komputer dan Teknologi Informasi, 3(1), 53–58. https://doi.org/10.62951/jikomti.v3i1.597
Susanto, D. A., & Purnomo, H. D. (2023). Perancangan sistem informasi gudang berbasis web menggunakan framework Laravel. JATISI (Jurnal Teknik Informatika dan Sistem Informasi), 10(1), 63–77. https://doi.org/10.35957/jatisi.v10i1.2619
Tolampi, C. C. P., & Maria, E. (2024). Perancangan sistem informasi tracking dan monitoring posisi barang menggunakan metode Waterfall. Jurnal Teknologi dan Sistem Informasi Bisnis, 6(4), 806–812. https://doi.org/10.47233/jteksis.v6i4.1616
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
Yakub, H., Daniawan, B., Wijaya, A., & Damayanti, L. (2024). Sistem informasi e-commerce berbasis website dengan metode pengujian User Acceptance Testing. JSITIK: Jurnal Sistem Informasi dan Teknologi Informasi Komputer, 2(2), 113–127. https://doi.org/10.53624/jsitik.v2i2.378
Yofena. (2022). Sistem informasi penjualan kacamata berbasis web pada Optik Yonotrend. Jurnal Topik Global, 1(1), 1–6.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Axel Rajaliu Chaniago, Frencis Matheos Sarimole
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.
