Implementation Of the C4.5 Algorithm for Web-Based Skincare Sales Classification at Sintia Distributor SR12

Wahyuni Wahyuni; Elfi Fauziah

doi:10.31004/riggs.v5i2.12628

Authors

Wahyuni Wahyuni Universitas Pamulang
Elfi Fauziah Universitas Pamulang

DOI:

https://doi.org/10.31004/riggs.v5i2.12628

Keywords:

C4.5 Algorithm, Classification, Data Mining, Skincare Sales, Web-Based System

Abstract

Sintia Distributor SR12 is a business that distributes various skincare products. Sales records available at the store had not been optimally utilized to objectively identify products with high and low sales. This condition could affect inventory planning and sales evaluation because product performance was still assessed through manual observation. This study aimed to implement the C4.5 algorithm in a web-based system for classifying skincare product sales. Data were collected through observation, interviews, and literature review. The system was developed using Python Flask, MySQL, HTML, CSS, Bootstrap, JavaScript, and Chart.js. The classification process consisted of selecting a sales period, combining product and sales data, calculating the average quantity sold, forming class labels, calculating entropy, gain, split information, and gain ratio, and generating classification rules. Testing was conducted using Black Box Testing, White Box Testing with the Basis Path technique, and a user response questionnaire. The implementation processed 31 product records, consisting of 13 Best-Selling products and 18 Non-Best-Selling products. The initial entropy value was 0.981, while the quantity-sold attribute obtained a gain ratio of 1.000. All main system functions and internal classification paths operated according to the designed scenarios. User response testing involving five respondents and ten questions produced a score of 95.60%, categorized as Very Good. The developed system can assist the store in managing sales data and presenting period-based product classification information for inventory and sales strategy evaluation.

Downloads

Download data is not yet available.

References

[1] N. Nawiyah, R. C. Kaemong, M. A. Ilham, and F. Muhammad, “Penyebab pengaruhnya pertumbuhan pasar Indonesia terhadap produk skin care lokal pada tahun 2022,” ARMADA: Jurnal Penelitian Multidisiplin, vol. 1, no. 12, pp. 1390–1396, Dec. 2023, doi: 10.55681/armada.v1i12.1060.

[2] A. K. Lalo, P. Batarius, and Y. C. H. Siki, “Implementasi algoritma C4.5 untuk klasifikasi penjualan barang di Swalayan Dutalia,” Jurnal Teknik Informatika UNIKA Santo Thomas, vol. 6, no. 1, pp. 1–12, Jun. 2021, doi: 10.54367/jtiust.v6i1.1089.

[3] N. W. Wardani, P. G. S. C. Nugraha, E. Hartono, I. W. D. Suryawan, A. M. Dirgayusari, I. W. Darmadi, and G. S. Mahendra, “Penerapan data mining untuk klasifikasi penjualan barang terlaris menggunakan metode Decision Tree C4.5,” Jurnal Teknologi Informasi dan Komputer, vol. 8, no. 3, pp. 268–279, Oct. 2022, doi: 10.36002/jutik.v8i3.2081.

[4] T. Salsabilla and S. Sulastri, “Implementasi algoritma C4.5 untuk klasifikasi produk laris sepeda motor Honda pada CV Cendana Motor Cepiring,” RABIT: Jurnal Teknologi dan Sistem Informasi Univrab, vol. 7, no. 2, pp. 164–171, Jul. 2022, doi: 10.36341/rabit.v7i2.2489.

[5] Suwandi, E. Gustami, K. P. Astuti, and Yunita, “Klasifikasi barang menggunakan algoritma C4.5 dalam penentuan prediksi stok barang pada PT Aerofood Indonesia,” Reputasi: Jurnal Rekayasa Perangkat Lunak, vol. 3, no. 2, pp. 12–18, Nov. 2022, doi: 10.31294/reputasi.v3i2.1398.

[6] F. Husna, H. Rahman, and J. Juhari, “Implementasi data mining menggunakan algoritma C4.5 pada klasifikasi penjualan hijab,” Jurnal Riset Mahasiswa Matematika, vol. 2, no. 2, pp. 40–46, Dec. 2022, doi: 10.18860/jrmm.v2i2.14891.

[7] D. Septieni, E. Purwanto, and H. Permatasari, “Sistem informasi penjualan skincare berbasis website: Studi kasus Toko Kumara Sukoharjo,” in Prosiding Seminar Nasional Teknologi Informasi dan Bisnis (SENATIB), Surakarta, Indonesia, 2023, pp. 294–299.

[8] A. C. Praniffa, A. Syahri, F. Sandes, U. Fariha, and Q. A. Giansyah, “Pengujian sistem informasi parkir berbasis web pada UIN SUSKA Riau menggunakan White Box dan Black Box Testing,” Jurnal Testing dan Implementasi Sistem Informasi, vol. 1, no. 1, pp. 1–16, 2023, doi: 10.55583/jtisi.v1i1.321.

[9] J. B. L. Sie, I. A. Musdar, and S. Bahri, “White Box Testing on the website Room using the Basis Path technique,” KHARISMA Tech, vol. 17, no. 2, pp. 45–57, Sep. 2022, doi: 10.55645/kharismatech.v17i2.235.

[10] Aliyah, N. Hartono, and A. A. Muin, “Penggunaan User Acceptance Testing (UAT) pada pengujian sistem informasi pengelolaan keuangan dan inventaris barang,” Switch: Jurnal Sains dan Teknologi Informasi, vol. 3, no. 2, pp. 42–58, Mar. 2025, doi: 10.62951/switch.v3i1.330.

[11] A. C. Darmawan and L. Iswari, “Pengembangan aplikasi berbasis web dengan Python Flask untuk klasifikasi data menggunakan metode Decision Tree C4.5,” Jurnal Pendidikan dan Konseling, vol. 4, no. 5, pp. 5351–5362, Oct. 2022, doi: 10.31004/jpdk.v4i5.7492.

[12] T. Y. Pratama and Armansyah, “Decision Tree C4.5 dengan teknik information gain untuk klasifikasi pemilihan program studi tingkat lanjut,” Journal of Information System Research, vol. 5, no. 4, pp. 1042–1052, Jul. 2024, doi: 10.47065/josh.v5i4.5643.

[13] R. Yap and R. Arijanto, “Analysis and design of online based plastic sales information system with User Acceptance Testing method,” bit-Tech, vol. 6, no. 1, pp. 8–15, Aug. 2023, doi: 10.32877/bt.v6i1.739.

[14] D. I. Suranda and A. Nugroho, “Klasifikasi data penjualan untuk memprediksi tingkat penjualan produk menggunakan metode Decision Tree,” Jurnal Teknik Informasi dan Komputer (Tekinkom), vol. 7, no. 1, pp. 370–376, Jun. 2024, doi: 10.37600/tekinkom.v7i1.1269.

[15] D. Putri, R. Afriansyah, and P. A. Prayesy, “Implementation of User Acceptance Testing (UAT) in testing the academic and financial information system for Islamic boarding school students,” TeIKa, vol. 15, no. 2, pp. 1–15, Jan. 2026, doi: 10.36342/ztavmp10.