Development and Quality Evaluation of a Web-Based Drug Inventory System for Pharmacy Management
DOI:
https://doi.org/10.47776/nuai.v2i1.1933Keywords:
Pharmacy inventory system, Web-Based application, Black box testing, User acceptance testing, Drug supply managementAbstract
Manual drug inventory management in pharmacies that rely on spreadsheets is prone to stock recording errors, unmonitored expiration dates, and reporting delays, and these problems compound as the drug variety and transaction volume grow. This study developed a web-based drug inventory system for pharmacy operations using the Waterfall model and evaluated its quality through Black Box Testing and User Acceptance Testing (UAT). Black Box Testing across thirteen test scenarios confirmed that every feature functioned according to its specification. UAT involved two pharmacy users, a pharmacy manager and an administrative staff member, who evaluated the system across nine criteria after operating its core functions in the actual work environment. The total UAT score was 71 out of 72, an overall average of 98.61%, classified as Very Good. One criterion, the stock depletion and expiry alert feature, scored 87.50% and was the only result below the maximum, pointing to notification responsiveness as the main area for further work. The system is functionally sound and well-received in this operational context, with the caveat that the two-respondent sample limits broader generalizability. Unlike prior pharmacy IS studies that handle stock recording, sales, or expiry management separately, this system combines batch-level tracking, automated expiry alerts, and integrated reporting in one platform designed for small pharmacy operations.
References
[1] S. Kinasih, R. Sahputra, and C. Anwar, “Functional Suitability Testing of Web-Based Warehouse Inventory Application Using Black Box Testing,” Ambidextrous J. Innov. Effic. Technol. Organ., vol. 3, pp. 138–154, Jan. 2026, doi: 10.61536/ambidextrous.v3i02.391.
[2] J. Shen et al., “Management of drug supply chain information based on ‘artificial intelligence + vendor managed inventory’ in China: perspective based on a case study,” Front. Pharmacol., vol. 15, Jul. 2024, doi: 10.3389/fphar.2024.1373642.
[3] R. Chalmeta, A. Navarro-Ruiz, and L. Soriano-Irigaray, “A computer architecture based on disruptive information technologies for drug management in hospitals,” PeerJ Comput. Sci., vol. 9, p. e1455, 2023, doi: 10.7717/peerj-cs.1455.
[4] E. Pranata, B. Abimanyu, and D. Endarti, “Digital Technologies in Hospital Pharmacy: A Systematic Review of Their Impact on Efficiency, Safety, and Inventory Management,” J. Prev. Med. Public Heal., vol. 59, no. 1, pp. 1–11, 2026, doi: https://doi.org/10.3961/jpmph.25.495.
[5] E. Shbaily et al., “Effectiveness of Pharmacy Automation Systems Versus Traditional Systems in Hospital Settings: A Systematic Review,” Cureus, vol. 17, Jan. 2025, doi: 10.7759/cureus.77934.
[6] E. A. Friday and O. S. Tiamiyu, “Automated Drug Expiry Detection and Alert System Via Email Notifications,” Am. J. Networks Commun., vol. 14, pp. 1–9, Jan. 2025, doi: 10.11648/j.ajnc.20251401.11.
[7] W. N. Insani et al., “Digital Health Technology Interventions for Improving Medication Safety: Systematic Review of Economic Evaluations,” J Med Internet Res, vol. 27, p. e65546, 2025, doi: 10.2196/65546.
[8] A. Saravanos and M. Curinga, “Simulating the Software Development Lifecycle: The Waterfall Model,” Appl. Syst. Innov., vol. 6, p. 108, Nov. 2023, doi: 10.3390/asi6060108.
[9] A. Kaur and G. Prakash, “Intelligent inventory management: AI-driven solution for the pharmaceutical supply chain,” Soc. Impacts, vol. 5, p. 100109, 2025, doi: https://doi.org/10.1016/j.socimp.2025.100109.
[10] Z. Alshamaa and N. N. Saleem, “Black Box Software Testing Techniques: a Literature Review,” Passer J. Basic Appl. Sci., vol. 7, pp. 1001–1011, Jan. 2025, doi: 10.24271/PSR.2025.508216.1963.
[11] M. Primasaji, Seliwati, and Muthmainnah, “Designing a Web-Based Drug Supply Information System at Wyata Guna Bandung Polyclinic,” J. JTIK (Jurnal Teknol. Inf. dan Komunikasi), vol. 7, pp. 45–52, Jan. 2023, doi: 10.35870/jtik.v7i1.667.
[12] E. Handayani, S. Saefudin, and D. Fudholi, “Scoping Review of Health Supplies Inventory Management Information System Using Web/Database,” PREPOTIF J. Kesehat. Masy., vol. 8, pp. 5441–5452, Dec. 2024, doi: 10.31004/prepotif.v8i3.32793.
[13] A. Hananta, N. A. Prasetyo, and A. B. Arifa, “Development of an Android-Based Tourism Application for Banyumas Regency using the Waterfall Model,” Nusant. J. Artif. Intell. Inf. Syst., vol. 1, no. 1, pp. 11–18, 2025, doi: 10.47776/nuai.v1i1.1613.
[14] A. Aliyah, N. Hartono, and A. A. Muin, “Penggunaan User Acceptance Testing (UAT) Pada Pengujian Sistem Informasi Pengelolaan Keuangan Dan Inventaris Barang,” Switch J. Sains dan Teknol. Inf., vol. 3, no. 1, pp. 84–100, Dec. 2024, doi: 10.62951/switch.v3i1.330.
[15] C. Ilham, R. K. Saragih, R. M. Sukmosuwarno, Z. A. Athalla, M. Nasir, and S. Indriasari, “Functional Testing of the Add Product Feature on the Admin Page of the Cimahpar Quail Farm Website Using the Black-Box Testing Method with the Equivalence Partitioning Technique,” J. Informatics Commun. Technol., vol. 7, no. 2 SE-Informatika, pp. 97–106, Dec. 2025, [Online]. Available: https://ejournal.akademitelkom.ac.id/j_ict/index.php/j_ict/article/view/472
[16] M. Tavakoli, F. Fazl, M. Sedighi, K. Naseri, M. Ghavami, and M. Taghipour, “Enhancing Pharmacy Warehouse Management With Faster R-CNN for Accurate and Reliable Pharmaceutical Product Identification and Counting,” Int. J. Intell. Syst., vol. 2025, no. 1, Jan. 2025, doi: 10.1155/int/8883735.
[17] K. Majumdar, J. Jain, and D. Mohan, “AI-Driven Optimization of Pharmaceutical Supply Chains: Enhancing Forecasting, Inventory, and Transparency,” 2025, pp. 230–241. doi: 10.1007/978-3-032-03072-6_18.
[18] Z. Wang et al., “The application of Chinese herbal medicine-derived extracellular vesicles as drug carriers in drug delivery systems,” Chem. Eng. J., vol. 540, p. 177298, 2026, doi: https://doi.org/10.1016/j.cej.2026.177298.
[19] Y. Numa and A. Ohnishi, “Supporting change management of UML class diagrams,” Procedia Comput. Sci., vol. 225, pp. 208–217, 2023, doi: 10.1016/j.procs.2023.10.005.
[20] L. Cavique, M. Cavique, A. Mendes, and M. Cavique, “Improving information system design: Using UML and axiomatic design,” Comput. Ind., vol. 135, p. 103569, 2022, doi: 10.1016/j.compind.2021.103569.
[21] E. S. Baxtiyor, “Design of Automated Enterprise Information Systems using UML Diagrams,” Innov. Technol. Methodical Res. J., vol. 3, no. 12, pp. 25–31, 2022.
[22] L. Specht et al., “Evaluating the Acceptance and Usability of an Independent, Noncommercial Search Engine for Medical Information: Cross-Sectional Questionnaire Study and User Behavior Tracking Analysis,” JMIR Hum. Factors, vol. 12, 2025, doi: https://doi.org/10.2196/56941.
[23] F. Fink, I. Kalter, J.-V. Steindorff, H. K. Helmbold, D. Paulicke, and P. Jahn, “Identifying Factors of User Acceptance of a Drone-Based Medication Delivery: User-Centered Design Approach,” JMIR Hum. Factors, vol. 11, 2024, doi: https://doi.org/10.2196/51587.
[24] J. Lai-Kwon et al., “Usability and Acceptance Testing of an Electronic Patient-Reported Outcome Symptom Monitoring System for People Receiving Immune Checkpoint Inhibitors: Mixed Methods Study,” JMIR Form. Res., vol. 10, 2026, doi: https://doi.org/10.2196/79694.
[25] L. C. B. Juliano, Z. Rodriguez, G. G. Habing, R. Portillo-Gonzalez, and P. L. Ruegg, “Comparison of antimicrobial usage estimated using records-based software with estimates based on an inventory of drug packaging waste,” J. Dairy Sci., vol. 109, no. 4, pp. 4296–4306, 2026, doi: https://doi.org/10.3168/jds.2025-27814.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Heru Budianto, Leni Nur Angraeni, Nanda Haipah Nabila, Muhamad Fikri
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Published by Faculty of Engineering and Computer Science, Universitas Nahdlatul Ulama Indonesia. This is an open access article under the CC BY-NC-ND license, which permits use and distribution in any medium, provided the original work is properly cited, the use is non-commercial, and no modifications or adaptations are made.
