SOFTWARE DEVELOPMENT TO OPTIMIZE LOGISTICS PROCESSES IN A RETAIL STORE

Abstract

In the context of rapid digital transformation, retail enterprises face growing challenges in managing logistics and warehouse operations efficiently. Manual inventory control and fragmented data handling often lead to inaccuracies, delays, and higher operational costs. This study addresses the need for accessible and cost-effective software solutions to optimize logistics processes in small and medium-sized retail stores. The purpose of the research is to design and imple- ment an automated warehouse management system that integrates QR-code identification, relational database manage- ment, and real-time data synchronization across different user roles within a retail environment. The research methodology is based on software engineering principles, system analysis, and database modeling. The system was developed using C# and SQL Server in the Microsoft Visual Studio environment, while AForge and ZXing libraries were used to implement video stream capture and QR-code recognition. The application consists of three main functional modules: cashier, warehouse worker, and administrator. Each designed to ensure data accuracy, security, and workflow transparency. The developed software system successfully automated key warehouse and sales operations through QR-code scanning integration. Testing confirmed that the SQL Server database correctly handled concurrent data queries while maintaining data integrity across multiple user sessions. The QR-code recognition module, based on the ZXing library, accurately identified products from camera streams and transferred data to the database with minimal manual input, significantly reducing human error in warehouse operations. The modular system design provided clear separation of access rights, with the administrator controlling data management, the warehouse worker managing inventory, and the cashier processing transactions. Performance evaluation demonstrated stable operation across all functional modules with correct real-time synchronization between interfaces after each database update. The practical value of this research lies in demonstrating that lightweight, software-driven automation can signifi- cantly improve the efficiency and transparency of logistics operations without requiring costly ERP platforms.