A Real-Time Sales Data Management System for Small and Medium-Sized Enterprises (SMEs)

Abstract

This research aimed to design and develop a real-time sales data management system for small and medium-sized enterprises (SMEs) to enhance the efficiency of collecting, processing, and visualizing sales data from multiple branches accurately and in a timely manner. The case study employed in this research was a community-based warehouse-type retail business located in the northeastern region of Thailand, comprising 23 branch stores across four provinces: Ubon Ratchathani, Yasothon, Sisaket, and Amnat Charoen. The developed system was implemented as a web-based application using Visual Studio Code, PHP, and JavaScript, integrated with a MySQL database deployed on a cloud-based infrastructure. The system was developed using an agile development methodology to ensure alignment with actual business operating contexts. System performance evaluation was conducted using a system usability scale questionnaire administered to 70 users from a total population of 257 users, representing 27.24% of the population. The evaluation results indicated that the system achieved an average score of 84.78 out of 100, corresponding to the “highest” level. High ratings were observed in terms of ease of use, data accuracy, and the system’s capability to effectively support actual operational tasks. These findings demonstrated that the integration of a real-time system significantly enhanced the efficiency of strategic data management and encouraged entrepreneurs to adopt digital technologies to strengthen their competitive capabilities. Furthermore, the system provided a foundation for future predictive data analytics to support effective decision-making.