Design and Construction of a Web-Based Information System for Product Performance Monitoring and Inventory Management at John Store
DOI:
https://doi.org/10.51903/q8y5kn82Keywords:
Inventory Management, Product Performance, Monitoring, Waterfall Method, Web-Based ApplicationAbstract
It must be able to stand alone since abstracts are frequently given apart The utilization of information technology has developed into a vital instrument in enhancing operational efficiency and business competitiveness, particularly in the medium-scale retail sector. Accurate inventory management is the primary foundation for business sustainability to maintain consistent customer satisfaction. However, John Store currently faces complex operational obstacles as it relies entirely on manual recording methods. The absence of a structured internal database system causes significant data synchronization issues between administrative records and physical stock in the warehouse, thereby increasing the risk of sudden stockouts. The most fundamental and crucial issue lies in managing bundling category products, where a single package transaction often fails to accurately deduct the stock balance of individual components due to the high risk of human error in manual calculation. To address this inefficiency, this research aims to build the web-based John Store Information System (SIJOHNS) as an integrated internal back-office solution. System development applies the Waterfall method systematically, covering requirements analysis, system design through Flowmap, Data Flow Diagram (DFD), and Entity Relationship Diagram (ERD), to implementation using PHP programming language and MySQL database. Key system features include the automation of bundling stock mapping and multi-role access rights management. Based on Black Box Testing, the system is proven valid. The implementation of SIJOHNS successfully transforms inventory management into a digital format, ensures the accuracy of stock deduction in real-time, and presents analytical data visualization on the dashboard to facilitate the store owner in monitoring sales trends for more strategic and targeted business decision-making
References
R. Fachrina and M. Nawawi, “Analisis Strategi Promosi Digital dan Efisiensi Transaksi pada UMKM,” J. Ekon. dan Bisnis, 2022.
A. Rahmawati and et al., “Peningkatan Volume Penjualan Melalui Integrasi Teknologi Digital,” J. Manaj. Pemasar., 2022.
D. Saputri and et al., “Daya Saing UMKM dalam Ekosistem Toko Online,” J. Bisnis Digit., 2023.
F. Ramadhan and et al., “Dampak Pencatatan Manual Terhadap Akurasi Stok pada Usaha Ritel,” J. Sist. Inf. Akunt., 2024.
A. Rohman and S. Bhakti, “Perancangan Sistem Informasi Persediaan Berbasis Web Menggunakan PHP dan MySQL,” J. Inform. dan Rekayasa Perangkat Lunak, 2022.
A. Putri and I. Ahmad, “Peran Sistem Informasi dalam Pengambilan Keputusan Organisasi,” J. Manaj. dan Bisnis, 2021.
J. Rahmadoni and et al., “Pentingnya Landasan Teori dan Sistem Informasi Terstruktur dalam Penelitian,” J. Ilm. Teknol. Inf., 2021.
Y. Triana, “Efektivitas Sistem Informasi Berbasis Web pada Skala UMKM,” J. Sist. Inf., 2024.
M. Olva and et al., “Integrasi Data pada Sistem Informasi Inventori UKM,” J. Sains dan Teknol., 2021.
D. Mulyadi and A. Susila, “Analisis Pengelolaan Inventori dan Penerapan PHP pada Sistem UMKM,” J. Akunt. dan Teknol., 2021.
B. Setiawan, “Implementasi Teknologi PHP dalam Pengambilan Keputusan Manajerial,” J. Tek. Inform., 2020.
S. Marli’aini and D. Anggoro, “Kemudahan Pemantauan Stok Melalui Sistem Inventori Terkomputerisasi,” J. Rekayasa Perangkat Lunak, 2024.
R. Fauzan and M. Ridwan, “Pemanfaatan PHP dalam Pengembangan Aplikasi Web Dinamis,” J. Inform., 2024.
T. Kurniawan and H. Saputra, “Implementasi Metode Waterfall pada Pengembangan Perangkat Lunak,” J. Tek. Komput., 2022.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Jurnal Manajemen Informatika & Teknologi
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
