A web-based warehouse inventory management system for stock items tracking

• Main Author: Low, Elaine Jing Yi
• Format: Final Year Project / Dissertation / Thesis
• Published: 2022
• Subjects: QA76 Computer software
• Online Access: http://eprints.utar.edu.my/5021/1/1803140_ELAINE_LOW_JING_YI.pdf; http://eprints.utar.edu.my/5021/

Warehouses act as an important role in the supply chain to store inventories. To keep up with the customer’s demand on time, inventories need to be organized and tracked with proper inventory system control so that business operations are done efficiently. However, in the current competitive market environment, warehouses have to deal with discrepancies between the recorded inventory count and the actual item count. Besides, to maintain the accurate inventory count, inventory system control such as cycle counting need to be in place, in which extra manpower is needed to classify the stock keeping unit (SKUs) and schedule the cycle counting process. Moreover, the existing SKU classification methods have their limitations in classifying the SKU. Therefore, a web-based warehouse inventory management system was implemented to address the mentioned problems. The system was developed using the phased-development methodology and was divided into three phases to develop features including the automated cycle counting scheduler, real-time check-in/ out stock module, report management, and the management of warehouses, users, inventories and categories. The front end of the system was developed using Vue.js whereas the back end (APIs) was developed with Pusher Channels for the real-time inventory stock tracking module. ng module. Web service testing was carried out using Postman and the entire system was deployed to Heroku after all test cases of web service testing passed for user acceptance testing and usability testing. The average SUS score was 85.5, hence, it could be concluded that the user interface of implemented system is simple and easy to use. Besides, 100 iterations of check-in/out stock were done and the time differences between creating stock and receiving API message was observed and recorded. The average delay time for the real-time functionality was around 1 second. In a nutshell, the implemented system successfully addressed and achieved the main project objectives to keep track of inventory stocks in real-time, automate cycle counting scheduler and improve and implement the existing SKU classification with higher completeness and efficiency.