IMPLEMENTASI DATABASE MYSQL PADA SISTEM INFORMASI PENJUALAN BERBASIS WEB UNTUK PENINGKATAN OPERASIONAL USAHA GROSIR

Abstract

Sales operations, particularly at the wholesale scale, require concise and accurate data management to reduce the risks of inefficiency and manual errors. The majority of Small and Medium Enterprises (SMEs) still rely on manual systems such as calculators and notepads, which are considered ineffective, time-consuming, and prone to causing discrepancies between recorded stock and actual physical inventory in the warehouse. This research focuses on the design and implementation of a web-based sales information system using MySQL as the primary Database Management System (DBMS), aiming to create an innovative and efficient solution. The applied system development methodology includes the Waterfall model, Agile Software Development, and the Dynamic System Development Method (DSDM), with PHP as the main programming language. The implementation of a reliable MySQL database enables the automatic storage of sales reports and inventory data, which is crucial for wholesale operations. The results show that this system successfully addresses previous issues with manual data recording and cashier transactions. Business Process Reengineering (BPR) in transaction management and reporting improved throughput efficiency from 77.78% to 100%. The use of a MySQL database ensures the sustainability of the Inventory Accounting Information System while supporting strategic decision-making by sales management. Furthermore, the system integrates a real-time tracking feature that links stock movement with sales, thereby reducing the risk of lost items and improving inventory accuracy. The web-based implementation allows remote access for SME owners, facilitating multi-location management without geographical constraints. A key challenge in implementing this system includes resistance to change from employees accustomed to manual methods, which can be overcome through intensive training and ongoing technical support. Integration with e-commerce platforms like Shopee and Tokopedia enables online market expansion, increasing wholesale sales volume by up to 40% within the first six months. Risk analysis indicates that the system can reduce losses due to stock errors by 50%, thanks to an automated validation algorithm integrated with warehouse sensors. The utilization of cloud computing to support MySQL ensures data security through end-to-end encryption, thereby minimizing cyber threats such as hacking or leakage of sensitive information. Therefore, this innovation not only strengthens the global competitiveness of SMEs but also promotes sustainable digital transformation as a foundation for inclusive and sustainable local economic growth.