Skip to main content
journal@msti-indonesia.com 081377790601
Register
Articles

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

  • 1*,2 Centro Escolar University

* Corresponding Author: Janice Jane C. Flores-Alhaddad

Open Access
DOI
https://doi.org/10.59431/jda.v5i1.819
Published
Pages
43–51

Issue

Vol. 5 No. 1 (2026)

Journal Dekstop Application (JDA)
June

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

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

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

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

License

Copyright (c) 2026 Janice Jane C. Flores-Alhaddad, Jojo Reyes

Creative Commons License

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

This is an open-access journal. All articles are distributed under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

Under this license, you 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, even commercially.

Attribution Requirements:
You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.

Copyright and Retention:
Authors retain copyright without restrictions and grant this journal the right of first publication under an open-access model. The journal retains non-exclusive publishing rights for archiving, indexing, and scholarly dissemination.

Usage Statistics