Improving Inventory Control Through a Web-Based System in a Retail Company

Abstract

Background Currently, retail companies that fail to digitise their logistics processes experience difficulties in controlling stock, resulting in inaccuracies in the quantity of products and excess amounts in the warehouse. Consequently, the aim was to introduce a web-based system to enhance inventory control in retail firms within the city of Huaraz. Methods The Extreme Programming methodology was implemented in four phases. During the planning phase, roles and user stories were established. In the coding phase, Hypertext Preprocessor and JavaScript programming languages were utilised alongside the MySQL database management system. The testing phase involved evaluating each interface’s functionality to ensure that it was a part of the web system. The objective of this was to develop the web system and utilise it as an inventory control tool. Results The utilization of the web-based system within the logistics sector led to enhanced indicators, as seen through a 52.94% increase in inventory precision rate and 91.94% rise in the stock turnover rate. Conclusions The web system facilitates the minimisation of input errors in product quantity records while also enabling visualisation of such data. It further provides an illustrated representation, in the form of a bar graph, of each product’s indicator behaviour.