Implementation of The Apriori Algorithm on X Cafe Sales Transactions for Product Bundling Package Recommendations

Halimah Tus Sadiah; Delta Hadi Purnama; Erniyati Erniyati

doi:10.46336/ijqrm.v6i1.882

Implementation of The Apriori Algorithm on X Cafe Sales Transactions for Product Bundling Package Recommendations

Halimah Tus Sadiah, Delta Hadi Purnama, Erniyati Erniyati

Abstract

Bundling packages are a marketing strategy in which several products are combined at a more attractive price than if purchased separately. This strategy effectively increases sales, attracts new customers, and levels up the average transaction value. Cafe X, located in Bogor, is a coffee shop that has not yet had a product bundling strategy package to increase product sales. This study aims to implement the Apriori algorithm on sales transactions at Cafe X to bundle product recommendations. The research stages consist of data collection, preprocessing, implementation of an apriori algorithm, and extracting association rules. In this study, a website-based apriori algorithm was implemented. Users can enter the minimum support value, minimum confidence value, and the recommended menu for product bundling. Based on the research results, it is produced for data input on the application with menu recommendations in the form of Tsuin Iced Coffee and Chicken Strips menus with a minimum support of 50% and a minimum Confidence of 90% can produce recommendations for 3 product bundling packages, including Package 1 recommendations are Tsuin Iced Coffee, Chicken Strips, Hot Barbeque Chicken. Package 2 recommendations are Tsuin Iced Coffee, Chicken Strips, and Nachos. Package 3 recommendations are Tsuin Iced Coffee, Chicken Strips, Hot BBQ chicken and Nachos.

Keywords

Keywords: algorithm, apriori, bundling product, coffee, sales transaction

Full Text:

PDF

References

Alma, E., Utami, E., & Wahyu Wibowo, F. (2020). Implementasi Algoritma Apriori untuk Rekomendasi Produk pada Toko Online Implementation of Apriori Algorithms for Product Recommendations at Online Stores. Citec Journal, 7(1).

Anggraini, D., Harliana, H., & Prabowo, T. (2023). Implementasi Association Rule Melalui Algoritma Apriori pada Analisis Data Transaksi Penjualan. ILKOMNIKA: Journal of Computer Science and Applied Informatics, 5(3), 200–208. https://doi.org/10.28926/ilkomnika.v5i3.589

Arief Wibowo, Vasthu Imaniar Ivanoti, & Megananda Hervita Permata Sari. (2023). Employee Education and Training Recommendations using the Apriori Algorithm. Jurnal RESTI (Rekayasa Sistem Dan Teknologi Informasi), 7(5), 1118–1131. https://doi.org/10.29207/resti.v7i5.4973

Fang, Y., Wang, R., Guo, M., & Hou, Y. (2022). Product bundling for online supermarkets by frequent itemset mining and optimization approach. Procedia Computer Science, 207, 4434–4441. https://doi.org/10.1016/j.procs.2022.09.507

Fathurrahman, H., Sunge, A. S., & Butsianto, S. (2024). Association Relationship Analysis in Finding Sales of Goods With Apriori Algorithm. Architecture and High Performance Computing, 6(3). https://doi.org/10.47709/cnapc.v6i3.4258

Fathurrozi, A., Masya, F., & Sugiyatno. (2023). Implementasi Algoritma Apriori Untuk Prediksi Transaksi Penjualan Produk Pada Aplikasi Point Of Sales. Technomedia Journal, 8(2), 70–81. https://doi.org/10.33050/tmj.v8i2.2004

Giovanni, A., Helsa Pane, D., Affandi, E., Studi Sistem Informasi, P., & Triguna Dharma, S. (n.d.). Implementasi Metode Association Rule Menggunakan Algoritma Apriori Pada Data Transaksi Penjualan. JURNAL SISTEM INFORMASI TGD, 1, 149–156. https://ojs.trigunadharma.ac.id/index.php/jsi

Guntur Alam, R., & Abdullah, D. (2024). Implementation Of Apriori Data Mining Algorithm to Increase Sales Of Caringin Shop. Jurnal Komputer, Informasi Dan Teknologi, 4(1), 1–14. https://doi.org/10.53697/jkomitek.v4i1.17

Haidar, I., & Hidayat, S. (n.d.). Implementasi Algoritma Apriori pada Transaksi Penjualan untuk Meningkatkan Minat Beli pada Restoran XYZ.

Ilmi, M., & Zulkarnain, C. A. (2023). Strategi Pemasaran Melalui Promosi, Harga Dan Kualitas Pelayanan Untuk Meningkatkan Kepuasan Konsumen Pada Pt Garuda Indonesia (PERSERO) TBK. Jurnal Ilmiah Manajemen Ekonomi Dan Akuntansi, 1(1), 66–73. https://doi.org/XX..XXXXX/Jimea

Laila Safitry, D., Rosianti, N., Divayaning, E., Zidan, H., Jane Arnecia, Z., Paryudi, I., Veritawati, I., Rezeki Candra Nursari, S., Srengseng Sawah, J., Selatan, J., & Jakarta, D. (2025). Analisis Pola Pembelian Konsumen Menggunakan Algoritma Apriori Untuk Menentukan Strategi Pemasaran Produk Di Toko RetaiL X. In Jurnal Mahasiswa Teknik Informatika) (Vol. 9, Issue 1).

Lestari, A. F., & Hafiz, M. (n.d.). Penerapan Algoritma Apriori Pada Data Penjualan Barbar Warehouse. 5(1), 2020.

Mandiri, J. A., Ismail, Y. L., & Ramlan Amir Isa. (2024). Pengaruh Produk Bundling dan Diskon terhadap Keputusan Pembelian pada Pengguna Produk Skincare The Originote di Kota Gorontalo. Economic Reviews Journal, 3(2). https://doi.org/10.56709/mrj.v3i2.242

Mutasar, M., & Niesa, C. (2021). Analisis Transaksi Konsumen Bidang Data Mining Menggunakan Algoritma Apriori Untuk Rekomendasi Bundling Produk Pada 212 Mart Kota Lhokseumawe. JURNAL TIKA, 6(02), 92–98. https://doi.org/10.51179/tika.v6i02.463

Nindya Saraswati, & Yeyen Pratika. (2024). Brand Image Moderation On Impulsive Buying Behavior: Exploring The Role Of Social Media Advertising And Product Bundling In Coffee Shop. Jurnal Manajemen Dan Bisnis Performa, 21(1), 71–79. https://doi.org/10.29313/performa.v21i1.3566

Nindyya, I. S., Gusmelia Testiana, & Irfan Dwi Jaya. (2023). Implementasi Algoritma Apriori dan ECLAT (Equivalence Class Transformation) Pada Data Transaksi Penjualan. Jurnal CoSciTech (Computer Science and Information Technology), 4(2), 525–533. https://doi.org/10.37859/coscitech.v4i2.5444

Oktafia Lingga Wijaya, H., & Yuliansyah, C. (2022). Implementasi Asosiasi Rule Mining Pada Data Transaksi Penjualan Menggunakan Algoritma Apriori. In Technologia (Vol. 13, Issue 1).

Oktory, H. D., & Hadiwandra, T. Y. (2024). Penerapan Algoritma Apriori untuk Penentuan Pola Pembelian Kacamata pada Optik Indah Optikal. MALCOM: Indonesian Journal of Machine Learning and Computer Science, 4(4), 1275–1281. https://doi.org/10.57152/malcom.v4i4.1353

Purnomo, I., Mulyani Sekolah Tinggi Teknologi Indonesia, H., & Sistem Informasi, J. (n.d.). Implementasi Algoritma Apriori Pada Transaksi Penjualan Barang (Studi Kasus: Toko Isna Kabupaten Bintan).

Ratna, N., Purba, S., & Riandari, F. (2021). Implementasi Data Mining Menggunakan Algoritma Apriori Untuk Analisis Keranjang Belanja Transaksi Penjualan Pada PT Madu Kembang Joyo. Jurnal Nasional Komputasi Dan Teknologi Informasi, 4(1).

Salman Al Faridzi, M., & Rahman Prehanto, D. (2022). Implementasi Algoritma Apriori pada Transaksi Penjualan dan Pembelian di Toko Bangunan Berbasis Website.

Santoso, M. H. (2021). Application of Association Rule Method Using Apriori Algorithm to Find Sales Patterns Case Study of Indomaret Tanjung Anom. Brilliance: Research of Artificial Intelligence, 1(2), 54–66. https://doi.org/10.47709/brilliance.v1i2.1228

Shely Amalia, F., & Darwis, D. (2021). Analisis Data Penjualan Handphone Dan Elektronik Menggunakan Algoritma Apriori (Studi Kasus : Cv Rey Gasendra) (Vol. 2, Issue 1).

Sukron, S. M., & Windyarti. (2021). Program Bundling Produk SWB2P dalam Perspektif Syariah(Studi Kasus BMT UGT Sidogiri CAPEM Cibitung). Jurnal Ekonomi Syariah Pelita Bangsa, 6(01), 30–39. https://doi.org/10.37366/jespb.v6i01.174

Widodo, K. D., & Lemantara, A. P. (2023). Analysis and Implementation of the Apriori Algorithm for Strategies to Increase Sales at Sakinah Mart (Vol. 11, Issue 2).

DOI: https://doi.org/10.46336/ijqrm.v6i1.882