Development of Web System for Sales Optimization at CV. CS Swalayan using Association Rule Method

Steven Imanuel Naibaho; Yullita Molliq Rangkuti

doi:10.59934/jaiea.v5i3.1796

Authors

Steven Imanuel Naibaho Universitas Negeri Medan
Yullita Molliq Rangkuti Universitas Negeri Medan

DOI:

https://doi.org/10.59934/jaiea.v5i3.1796

Keywords:

Association Rule, Apriori Algorithm, Data Mining, Sales Optimizing, Purchase Patterns

Abstract

CV. CS Swalayan encounters challenges related to declining consumer purchasing power and the underutilization of transactional data for analyzing customer purchasing patterns. This study aims to develop a web-based system employing Association Rule methodology with the Apriori algorithm to optimize sales performance, identify top-selling products, and determine frequently co-purchased product combinations. The research methodology encompasses the collection of 296 sales transaction records for basic commodity products from CV—CS Swalayan during January 2025, followed by data preprocessing procedures. The Apriori algorithm is implemented with minimum support and confidence thresholds set at 0.01 and 0.3, respectively. The web-based system is developed using Python with the Flask framework for backend functionality, MySQL for database management, and validated through black-box testing methodology. The findings reveal the generation of 14 valid and robust association rules, notably "if Selai Srikaya Ngetop is purchased, then Roti Tawar Kupas Ngetop will be purchased" (confidence: 100%; lift ratio: 49.3) and "if Beras Sukaraya Cap Gurih 10KG is purchased, then Minyak Kita Minyak Goreng Sawit 1ltr will be purchased" (confidence: 100%; lift ratio: 16.4). The developed web system successfully passed black-box testing with a 100% success rate. This research contributes by providing a system that enables CV. CS Swalayan will make data-driven decisions to optimize sales strategies, marketing approaches, and inventory management practices.

Downloads

Download data is not yet available.

References

Maria Cicilia Galuh Prayudhia, “Aprindo prediksi pertumbuhan ritel nasional capai 4,2 persen,” ANTARA. Accessed: Sep. 27, 2024. [Online]. Available: https://www.antaranews.com/berita/3824925/aprindo-prediksi-pertumbuhan-ritel-nasional-capai-42-persen

R. Hammad, V. C. Hardita, M. Zulfikri, and E. W. Sholeha, “Penerapan Metode Apriori Sebagai Sistem Pendukung Keputusan Pembentukan Paket Penjualan Bibit Buah,” J. SAINTEKOM, vol. 12, no. 1, pp. 58–68, 2022, doi: 10.33020/saintekom.v12i1.240.

L. G. Prasad, A., & Malik, “Application of Association Rule Mining in Market Basket Analysis: A Comprehensive Review,” Int. J. Inf. Technol. Comput. Sci., no. 14(3), pp. 51–62, 2022, doi: https://doi.org/10.5815/ijitcs.2022.03.05.

A. Sari, D. P., Wicaksono, A. R., & Nurhalim, “Implementasi Algoritma Apriori untuk Analisis Pola Belanja Konsumen pada E-commerce di Era New Normal,” J. Teknol. Inf. dan Ilmu Komput., vol. 10, p. 3, 2023.

A. N. Rahmi and Y. A. Mikola, “Implementasi Algoritma Apriori Untuk Menentukan Pola Pembelian Pada Customer (Studi Kasus : Toko Bakoel Sembako),” Inf. Syst. J., vol. 4, no. 1, pp. 14–19, 2021, [Online]. Available: https://jurnal.amikom.ac.id/index.php/infos/article/view/561

M. H. Santoso, “Application of Association Rule Method Using Apriori Algorithm to Find Sales Patterns Case Study of Indomaret Tanjung Anom,” Brill. Res. Artif. Intell., vol. 1, no. 2, pp. 54–66, 2021, doi: 10.47709/brilliance.v1i2.1228.

Faris Syaifulloh, Eva Yulia Puspaningrum, and M. Muharram Al Haromainy, “Analisis Pola Pembelian Pelanggan Menggunakan Algoritma Squeezer, Apriori dan FP-Growth Pada Toko Bangunan,” Modem J. Inform. dan Sains Teknol., vol. 2, no. 3, pp. 134–147, 2024, doi: 10.62951/modem.v2i3.153.

A. Adri, N. D. Rumlaklak, and D. R. Sina, “Implementasi Algoritma Apriori Untuk Analisa Data Penjualan (Studi Kasus: Toko Ud. Suryani),” J. Komput. dan Inform., vol. 9, no. 2, pp. 182–188, 2021, doi: 10.35508/jicon.v9i2.5132.

Sasonoputri Fauzia Safitrie and Wahyusarib Retno, “Penerapan Algoritma Apriori Untuk Menemukan Pola Peminjaman Buku Di Perpustakaan,” Simetris, vol. 16, no. 1, pp. 17–23, 2022.

A. Ibezato Zalukhu, D. Sartika, and S. Wahyuni, “Penerapan Algoritma Apriori untuk Optimasi Strategi Penjualan Berdasarkan Analisis Pola Pembelian di Torsa Cafe,” Bull. Inf. Technol., vol. 5, no. 4, pp. 295–304, 2024, doi: 10.47065/bit.v5i2.1715.

D. Sitanggang, M. Kom, and A. Apriori, “Delima Sitanggang, M.Kom,” 2023.

N. A. Pradipta and R. D. H. Untari N, “Implementasi Algoritma Apriori Untuk Analisis Pola Pembelian Produk Donat Bolong,” Jutisi J. Ilm. Tek. Inform. dan Sist. Inf., vol. 13, no. 1, p. 268, 2024, doi: 10.35889/jutisi.v13i1.1778.

Alwendi, A. S. Mandopa, and E. A. Hasibuan, “Aplikasi Data Mining Untuk Menentukan Masa Studi Mahasiswa Menggunakan Metode Association Rule Data Mining Application to Determine Student Study Period Using Association Rule Method,” J. Pendidik. Dewantara, vol. 2, no. 1, pp. 1–6, 2023, [Online]. Available: https://jurnal.yagasi.or.id/index.php/dewantarahttp://dx.doi.org/10.58222/dewantara.v2i1.24

D. F. Ningtyas and N. Setiyawati, “Implementasi Flask Framework pada Pembangunan Aplikasi Purchasing Approval Request,” J. Janitra Inform. dan Sist. Inf., vol. 1, no. 1, pp. 19–34, 2021, doi: 10.25008/janitra.v1i1.120.

M. Afiksih, “Perancangan Aplikasi Pemesanan Makanan Berbasis Web di Kantin PT. Pegadaian Kanwil I Medan,” J. Comput. Sci. Informatics Eng., vol. 01, no. 2, pp. 66–77, 2022, doi: 10.55537/cosie.v1i2.61.

Y. Kurnia, Y. Isharianto, Y. C. Giap, A. Hermawan, and Riki, “Study of application of data mining market basket analysis for knowing sales pattern (association of items) at the O! Fish restaurant using apriori algorithm,” in Journal of Physics: Conference Series, 2019. doi: 10.1088/1742-6596/1175/1/012047.

U. Syach and S. W. M. Edi, “Perancangan Aplikasi Web Manajemen Data Produk Bisnis Perhiasan Berbasis Flask Dan Mongodb,” IT-Explore J. Penerapan Teknol. Inf. dan Komun., vol. 3, no. 2, pp. 162–176, 2024, doi: 10.24246/itexplore.v3i2.2024.pp162-176.