Development of a software tool for order and inventory management for small businesses

Abstract

Small businesses frequently manage orders and stock using spreadsheets and manual workflows, increasing the likelihood of user errors and weakening operational control. This paper presents the design and implementation of an information system to automate order processing, supply registration, and real-time inventory tracking. The proposed solution relies on a centralised database and explicit business rules to ensure consistent accounting of stock movements and document states. The software supports product catalogue management, customer orders, inbound deliveries, warehouse balances, reporting, and user activity auditing. Role-based access control is applied to separate responsibilities between management and warehouse staff. Functional and scenario-based testing demonstrates correct handling of typical inventory operations and a reduction in routine manual actions.