Development of Inventory Management System for Small and Medium Enterprises Using Client-Server Architecture

Janice Jane C. Flores-Alhaddad; Jojo Reyes

doi:10.59431/jda.v5i1.819

Quick Links

Journal

Home: Journal Home
Current: Current Issue
Archives: All Issues
News: Announcements
Search: Search Articles

About

About: About Journal
Team: Editorial Team
Reviewers: Reviewer Team
Indexing: Indexed In

For Authors

Guidelines: Author Guidelines
Submit: Submit Article
Fees: Publication Fees

Policies

Ethics: Publication Ethics
Review: Reviewer Guide
Access: Open Access
Contact: Contact Us

081377790601
journal@msti-indonesia.com
Mon - Sat: 08:00 - 15:00

Articles

PDF

Articles

Development of Inventory Management System for Small and Medium Enterprises Using Client-Server Architecture

Janice Jane C. Flores-Alhaddad, Jojo Reyes

View Author Affiliations

Janice Jane C. Flores-Alhaddad: Centro Escolar University, Philippines
Jojo Reyes: Centro Escolar University, Philippines

DOI:

https://doi.org/10.59431/jda.v5i1.819

Published:

June 30, 2026

Pages:

43–51

145

Views

54

Downloads

Article Metrics

Abstract

Small and Medium Enterprises (SMEs) constitute the structural core of the Philippine economy, yet a disproportionate number continue to manage inventory through manual or semi-manual processes—paper logs, ledgers, and spreadsheets that introduce chronic inaccuracies, obscure stock visibility, and produce the kind of unreliable data on which poor business decisions are made. This study details the design, development, and evaluation of a custom Inventory Management System (IMS) built on client-server architecture and tailored specifically for resource-constrained SMEs. The server centralizes data storage through a normalized relational database, while client applications provide intuitive interfaces for real-time inventory tracking, transaction processing, automated low-stock alerts, and report generation. The development stack was selected for cost-effectiveness and local deployability: PHP/Laravel or Node.js for backend logic, MySQL or PostgreSQL for the database layer, and a responsive web front end built with HTML, CSS, JavaScript, and Bootstrap 5, with multi-user access governed by role-based access control (RBAC). Development followed the Waterfall model enhanced with iterative prototyping, informed by surveys and interviews with 15 SME owners and managers in Metro Manila and surrounding provinces. Evaluation across simulated and live SME environments yielded measurable performance gains: inventory accuracy improved from 78% to 97.3%, stockout incidents decreased by 45%, and time spent on inventory-related tasks was reduced by more than 60%, with report generation compressed from one to two hours to under ten seconds. The system was designed with the operational realities of Philippine SMEs explicitly in mind—limited IT infrastructure, intermittent internet connectivity, and sustained pressure to minimize technology costs—and supports on-premises or hybrid deployment as a deliberate alternative to recurring-cost cloud subscriptions. These findings contribute to the growing body of literature on practical digital solutions for micro, small, and medium enterprises in developing-country contexts, and offer a replicable model for SME digitalization in similarly constrained environments across Southeast Asia.

Keywords

Inventory Management System; Client-Server Architecture; SMEs Philippines; Role-Based Access Control; Digital Transformation

Author Biographies

Janice Jane C. Flores-Alhaddad

Centro Escolar University

Centro Escolar University, Manila, Philippines

Jojo Reyes

Centro Escolar University

Centro Escolar University, Manila, Philippines

Article Identifiers

Article Title: Development of Inventory Management System for Small and Medium Enterprises Using Client-Server Architecture
DOI: 10.59431/jda.v5i1.819
Publication Date: 2026-06-30

Journal: Journal Dekstop Application (JDA)
Volume: 5
Issue: 1
Pages: 43–51

References

Abegunde, I. (2025). Development of brewery inventory app with integrated barcode scanning. Ammattikorkeakoulujen opinnäytetyöt ja julkaisu. https://urn.fi/URN:NBN:fi:amk-2025060118890
Alfarizi, M., Widiastuti, T., & Ngatindriatun. (2024). Exploration of technological challenges and public economic trends phenomenon in the sustainable performance of Indonesian digital MSMEs on industrial era 4.0. Journal of Industrial Integration and Management, 9(01), 65–96. https://doi.org/10.1142/S2424862223500045
Amalia, A. A., Supriyati, E., & Listyorini, T. (2025). Design of a web-based point of sale system for transaction recording at Sumber Rejeki Store. SAGA: Journal of Technology and Information System, 3(3), 475–486. https://doi.org/10.58905/saga.v2025i3.547
Asana, I. M. D. P., Radhitya, M. L., Widiartha, K. K., Santika, P. P., & Wiguna, I. K. A. G. (2020, February). Inventory control using ABC and min-max analysis on retail management information system. Journal of Physics: Conference Series, 1469(1), Article 012097. https://doi.org/10.1088/1742-6596/1469/1/012097
Azra, A., Nazhifah, F., Indonesia, D., & Insani, T. (2025). Design of AiStock application based on artificial intelligence for stock management efficiency of digital retail SMEs. Intellectual Article Studies of Social, Language, and Art, 2(2). https://doi.org/10.70904/
Beheshti, H. M., Grgurich, D., & Gilbert, F. W. (2012). ABC inventory management support system with a clinical laboratory application. Journal of Promotion Management, 18(4), 414–435. https://doi.org/10.1080/10496491.2012.715502
Borromeo, A. S., Cervantes, R. J., & Sumicad, E. H., Jr. (2024). Analyzing the recording practices in accounting of micro and small businesses: The case of the Philippines. Review of Business and Economics Studies, 12(1), 70–80.
Brela, M. G. K., Ochua, A. C., Gabriel, A., & Resuello, G. (2024, September). Determining user requirements for a tailored web-based inventory and sales management system in micro-small construction supply stores using design thinking. Proceedings of the 2024 The 6th World Symposium on Software Engineering (WSSE), 144–153. https://doi.org/10.1145/3698062.3698082
Chia, J. Y., & Harun, N. Z. (2025). Inventory management system with two-factor authentication for Heng Huat Motor & Electrical Trading. Applied Information Technology and Computer Science, 6(1), 343–361.
Chong, N., Nguyen, T., Tong, A., & Zainol, Z. (2026). Emerging technology adoption in Southeast Asia (SEA)'s Micro, Small and Medium Enterprises (MSMEs). In Emerging technologies and business development in the tropics: A roadmap for transformation (pp. 3–20). Routledge. https://doi.org/10.4324/9781003586043-2
Daracan, V. S. L., Latayan, R. J. E., Padilla, C. L. D., & Young, M. N. (2020, December). Designing an inventory database software suitable for small business. Proceedings of the 2020 IEEE 7th International Conference on Engineering Technologies and Applied Sciences (ICETAS), 1–5. https://doi.org/10.1109/ICETAS51660.2020.9484166
Díaz-Arancibia, J., Hochstetter-Diez, J., Bustamante-Mora, A., Sepúlveda-Cuevas, S., Albayay, I., & Arango-López, J. (2024). Navigating digital transformation and technology adoption: A literature review from small and medium-sized enterprises in developing countries. Sustainability, 16(14), Article 5946. https://doi.org/10.3390/su16145946
Febriansyah, R. P. (2025). Design of a web-based incoming goods information system to support logistics performance at Bintang Technic. Journal Innovations Computer Science, 4(2), 82–93. https://doi.org/10.56347/jics.v4i2.299
Gabriel, M. G. (2025). Inventory management practices of retailers in Santiago City. International Journal of Research, 12, 857–864. https://doi.org/10.51244/IJRSI.2025.12020066
Gavhane, K. (2025). Digital transformation in SME retail operations: An empirical study of AI-driven inventory management systems in regulated markets [Working paper]. SSRN. https://dx.doi.org/10.2139/ssrn.5401566
Ivanov, D., Tsipoulanidis, A., & Schönberger, J. (2021). Inventory management. In Global supply chain and operations management: A decision-oriented introduction to the creation of value (pp. 385–433). Springer International Publishing. https://doi.org/10.1007/978-3-030-72331-6_13
Karimov, N. (2025). Inventory optimization in multinational firms using the economic order quantity technique. Global Perspectives in Management, 3(2), 20–30. https://doi.org/10.66027/GPIM/V3I2/GPM25203
Khoshaba, O. M., & Fokin, O. I. (2026). Design and development of an order and inventory management system for small businesses [Doctoral dissertation, Vinnytsia National Technical University].
Leonardo, P., & Wiratama, J. (2023). Empowering efficiency: A web-based inventory and sales information system for drinking water distributors through rapid application development. Journal of Information Systems and Informatics, 5(2), 742–757. https://doi.org/10.51519/journalisi.v5i2.498
Loo, M. K., Ramachandran, S., & Raja Yusof, R. N. (2023). Unleashing the potential: Enhancing technology adoption and innovation for micro, small and medium-sized enterprises (MSMEs). Cogent Economics & Finance, 11(2), Article 2267748. https://doi.org/10.1080/23322039.2023.2267748
Margate, A. M. N., Ravina, M. C. F., Pido, J. J. G., & Young, M. N. (2020, December). Seiton: A mobile inventory management system application for micro, small and medium-sized enterprise. Proceedings of the 2020 IEEE 7th International Conference on Engineering Technologies and Applied Sciences (ICETAS), 1–5. https://doi.org/10.1109/ICETAS51660.2020.9484183
Marlinda, M., & Khotimah, K. (2025). Development of a web-based information system to digitalize florist SME operations. bit-Tech, 8(2), 2306–2315. https://doi.org/10.32877/bt.v8i2.3239
Mukherjee, M., & Wood, J. (2021). Consolidating unorganised retail businesses through digital platforms: Implications for achieving the UN Sustainable Development Goals. Sustainability, 13(21), Article 12031. https://doi.org/10.3390/su132112031
Oliverio, M. B. M., Panes, D. E. T., Vinluan, T. M. C., Intal, G. L., & Balan, A. K. (2023). Business process reengineering and ERP system implementation plan for a manufacturing company: A case study. Journal of Namibian Studies, 33.
Pararach, S., & Muanme, W. (2023). Implementation of ABC classification and economic order quantity (EOQ) to reducing ordering cost: A case study on small medium enterprise (SME). Proceedings of the 4th Asia Pacific Conference on Industrial Engineering and Operations Management. https://doi.org/10.46254/ap04.20230036
Perez, J. J., Peralta, J. M., Eugenio, A., Bueno, A. S., & Acerado, R. M. (2026, January). Development and evaluation of an AI-enhanced mobile inventory management system for the construction industry. Proceedings of the 2026 9th International Conference on Software Engineering and Information Management, 175–180. https://doi.org/10.1145/3796315.3796339
Putri, R. A., Putri, S. M., Mardiah, H., & Khair, R. (2026). Integrating automatic stock monitoring and digital inventory systems for MSMEs: A mobile application approach (case study in Serang City, Indonesia). Journal of Informatics and Telecommunication Engineering, 9(2), 370–380.
Putra, J. E. (2025). Digital transformation in enhancing operational efficiency of e-commerce platforms in Southeast Asia: A comprehensive analysis and strategic implications. Techtalent & Business Review, 1(2), 1–12.
Racal, S. (2025). Designing a scalable order fulfillment and inventory management framework for an e-commerce-driven craft beverage enterprise [Unpublished thesis]. Ammattikorkeakoulujen opinnäytetyöt ja julkaisu. https://urn.fi/URN:NBN:fi:amk-2025112730399
Rodillas, G. C., Suya, J., Doctor, R. C., & Tubog, X. J. (2026). Sort Out: A smart inventory management system using descriptive analytics and rule-based algorithm for mini grocery stores. International Journal of Research and Innovation in Applied Science, 11(2). https://doi.org/10.51584/IJRIAS.2026.110200012
Setyadi, H. A., Al Amin, B., & Widodo, P. (2024). Implementation economic order quantity and reorder point methods in inventory management information systems. Journal of Information Systems and Informatics, 6(1), 103–117.
Shahhilina, D. S., Supriyati, E., & Listyorini, T. (2025). Web-based hotel inventory information system at Guna Wijaya Hotel Pati. SAGA: Journal of Technology and Information System, 3(3), 487–497. https://doi.org/10.58905/saga.v3i3.546
Umam, M. K., Khotimah, T., & Jazuli, A. (2025). Web-based cashier management, inventory, and sales management application design. International Journal of Science and Environment, 5(4), 493–500. https://doi.org/10.51601/ijse.v5i3.218
Umry, T. F., & Singgih, M. L. (2019). Inventory management and reorder point (ROP) strategy using ABC analysis methods in textile manufacture. IPTEK Journal of Proceedings Series, (5), 1–7. https://doi.org/10.12962/j23546026.y2019i5.6499
Vanesa, L., & Helma, H. (2023). Analysis of raw material inventory control using the ABC analysis method and EOQ method in the Fajar Onion Crackers Business. Mathematical Journal of Modelling and Forecasting, 1(1), 1–9. https://doi.org/10.24036/mjmf.v1i1.7
Wulan, T. S., Putri, R. A., & Solihin, D. A. (2024). Digital transformation as a catalyst for SMEs productivity and profitability in the digital era. Journal of Economic Education and Entrepreneurship Studies, 5(4), 601–611. https://doi.org/10.62794/je3s.v5i4.4543
Yoraeni, A., Margaret, A., Ifadah, M., & Mulyono, A. (2025). Implementation of a web-based inventory management information system. bit-Tech, 8(2), 2338–2347. https://doi.org/10.32877/bt.v8i2.3245
Zaki, N. F., & Hermawan, A. (2025). Development of a mobile web information system for ordering and managing local products. bit-Tech, 8(2), 2419–2429. https://doi.org/10.32877/bt.v8i2.3263
Zheng, X., & Chen, Y. (2024). Optimization of inventory cost control for SMEs in supply chain transformation: A case study and discussion. E&M Economics and Management, 27(1), 87–107. https://doi.org/10.15240/tul/001/2024-5-002

Article Statistics

Downloads

Download data is not yet available.

Issue Information

Article Details

Volume:	5
Issue:	1
Year:	2026
Published:	2026-06-30
Pages:	43–51
Section:	Articles

View Full Issue

Additional Information

How to Cite

Flores-Alhaddad, J. J. C., & Reyes, J. (2026). Development of Inventory Management System for Small and Medium Enterprises Using Client-Server Architecture. Journal Dekstop Application (JDA), 5(1), 43–51. https://doi.org/10.59431/jda.v5i1.819