Title: The designing of warehouse management information system: a case study in helmet company

Authors: Nhat Quang Nguyen; Duc Duy Nguyen; Van Hoang Nguyen; Ngoc-Hien Do

Addresses: Department of Industrial System Engineering, Ho Chi Minh City University of Technology (HCMUT), 268 Ly Thuong Kiet Street, District 10, Ho Chi Minh City, Vietnam; Vietnam National University Ho Chi Minh City, Linh Trung Ward, Thu Duc City, Ho Chi Minh City, Vietnam ' Department of Industrial System Engineering, Ho Chi Minh City University of Technology (HCMUT), 268 Ly Thuong Kiet Street, District 10, Ho Chi Minh City, Vietnam; Vietnam National University Ho Chi Minh City, Linh Trung Ward, Thu Duc City, Ho Chi Minh City, Vietnam ' Department of Industrial System Engineering, Ho Chi Minh City University of Technology (HCMUT), 268 Ly Thuong Kiet Street, District 10, Ho Chi Minh City, Vietnam; Vietnam National University Ho Chi Minh City, Linh Trung Ward, Thu Duc City, Ho Chi Minh City, Vietnam ' Department of Industrial System Engineering, Ho Chi Minh City University of Technology (HCMUT), 268 Ly Thuong Kiet Street, District 10, Ho Chi Minh City, Vietnam; Vietnam National University Ho Chi Minh City, Linh Trung Ward, Thu Duc City, Ho Chi Minh City, Vietnam

Abstract: This study aims to improve the efficiency and effectiveness of warehousing activities and remove manual handling by designing and developing a warehouse management information system. Our methodology is based on the waterfall model with six steps: analysis, system design, implementation, integration, operation and maintenance. The system was formulated as Excel add-in, then developed as software using Python for front-end, JavaScript for backend, SQL for the database and Figma for the user interface. The system's efficiency is illustrated using a practical case study from a helmet company in Vietnam. The results show that the system satisfies the stakeholder's demand and improves warehousing activities such as long-life saving data in the system, real-time tracking, automatic updating, removing 100% input errors caused by human factors, reducing 90% time of report generating, and so on.

Keywords: warehouse management system; WMS; system design; helmet industry; digital transformation; management information system; barcode.

DOI: 10.1504/IJSOM.2025.146904

International Journal of Services and Operations Management, 2025 Vol.51 No.2, pp.172 - 189

Received: 01 Jun 2023
Accepted: 05 Jun 2023
Published online: 25 Jun 2025 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article