Proactive Retail Intelligence: Integrating Apriori Algorithm and Telegram API for Product Inventory Optimization
Keywords:
Market Basket Analysis, Apriori Algorithm, Predictive Business Intelligence, Telegram Bot API, Retail Decision SupportAbstract
The development of digitalization in the micro, small, and medium enterprise (MSME) sector has resulted in an increase in the volume of transaction data stored through Point of Sales (POS) systems. However, most of this data is still used as historical archives and has not been optimally utilized to support business decision-making. This condition often causes business actors to experience delays in recognizing consumer purchasing patterns that have the potential to be used to optimize sales strategies and inventory management. This study aims to design and implement a Proactive Business Intelligence system that can transform transaction data analysis results into operational recommendations automatically and in real-time. The method used is Market Basket Analysis with the Apriori algorithm to extract association patterns between products based on support, confidence, and lift ratio values. The research dataset consists of retail transaction data transformed using the One-Hot Encoding technique so that it can be processed in the form of a binary matrix. Association rules that meet the threshold of confidence ≥ 0.80 and lift ratio > 1.20 are then processed by the filtering engine and sent to users through the Telegram Bot API integration. The results showed that the system successfully identified a strong complementary relationship between Ground Coffee and Palm Sugar products with a confidence value of 0.88 and a lift ratio of 1.33. Furthermore, black-box testing showed that the entire process, from data reading to notification delivery, only took an average of 1.48 seconds. These findings demonstrate that the integration of the Apriori algorithm and the Telegram Bot API can support faster, more proactive, and more efficient decision-making for micro and medium-sized retail businesses.
Downloads
References
[1] E. Sulistiyawati and A. Widayani, “Marketplace Shopee Sebagai Media Promosi Penjualan UMKM di Kota Blitar,” J. Pemasar. Kompetitif, 2020, doi: 10.32493/JPKPK.V4I1.7087.
[2] B. Setiawan and A. Fadillah, “Pendampingan Penerapan Strategi Promosi Berbasis Digital Bagi UMKM Di Wilayah Kota Bogor,” 2020. doi: 10.37641/jadkes.v1i1.320.
[3] C. A. Putra, N. N. Aprilia, A. E. N. Sari, R. M. Wijdan, and A. R. Putri, “Pendampingan Pembuatan Nomor Induk Berusaha (NIB) untuk Pengembangan UMKM di Kelurahan Tlumpu Melalui Online Single Submission (OSS),” I-Com Indones. Community J., 2022, doi: 10.33379/icom.v2i2.1397.
[4] L. Zhang, Y. Lin, X. Yang, T. Chen, X. Cheng, and W. Cheng, “From Sample Poverty to Rich Feature Learning: A New Metric Learning Method for Few-Shot Classification,” IEEE Access, vol. 12, pp. 124990–125002, 2024, doi: 10.1109/ACCESS.2024.3444483.
[5] R. Wu, L. A. Richards, A. Roshan, and D. A. Polya, “Artificial Intelligence Modelling to Support the Groundwater Chemistry-Dependent Selection of Groundwater Arsenic Remediation Approaches in Bangladesh,” Water (Switzerland), vol. 15, no. 20, 2023, doi: 10.3390/w15203539.
[6] A. S. Barb and C.-R. Shyu, “Visual-semantic modeling in content-based geospatial information retrieval using associative mining techniques,” IEEE Geosci. Remote Sens. Lett., vol. 7, no. 1, pp. 38–42, 2010, doi: 10.1109/LGRS.2009.2017214.
[7] Prof. Yogesh Mali, Nilay Sawant, Suhas Patil, Sonali Kumari, and Sonali Kumari, “Smart Helmet for Coal Mining,” 2023. doi: 10.48175/ijarsct-8064.
[8] Z. Alizadeh Zakaria, H. Ebadi, and F. Farnood Ahmadi, “Investigation of the application of geospatial artificial intelligence for integration of earthquake precursors extracted from remotely sensed SAR and thermal images for earthquake prediction,” Multimed. Tools Appl., vol. 82, no. 15, pp. 22853–22870, 2023, doi: 10.1007/s11042-023-14611-x.
[9] G. Tang, A. W. Wood, A. J. Newman, P. E. Kirstetter, C. Mueller, and C. Frans, “High-resolution ensemble precipitation and temperature datasets for CONUS based on a probabilistic geospatial estimation approach,” J. Hydrol., vol. 666, 2026, doi: 10.1016/j.jhydrol.2025.134761.
[10] N. Al-Hanbali, R. Al-Kharouf, and M. B. Al-Zoubi, “Integration of school mapping modelling for an Educational Decision Support System: Jordan case study,” Model. Meas. Control C, vol. 68, no. 3–4, pp. 13–34, 2007, [Online]. Available: https://www.scopus.com/pages/publications/48449103250?origin=resultslist
[11] J. Yang et al., “Knowledge-guided graph machine learning improves corn yield mapping in the U.S. Midwest,” Remote Sens. Environ., vol. 335, 2026, doi: 10.1016/j.rse.2026.115287.
[12] G. G. Zalzalah, F. Farhan, N. Ratnaningrum, and ..., “Pengembangan UMKM Batik Damai Langit Melalui Program Manajemen Bisnis,” … Altifani Penelit. Dan …, 2024, [Online]. Available: https://www.altifani.org/index.php/altifani/article/view/558
[13] M. Hidayatullah, M. Arifin, and ..., “Pengembangan Sistem Informasi Berbasis Web untuk Manajemen Pesanan, Produksi, dan Stok Pada UMKM Kripik Pisang Ibu Ira Bangkal Sumenep,” … Ilmu Komput. dan …, 2025, [Online]. Available: https://ilkomedia.akb.ac.id/index.php/ilkomedia/article/view/69
[14] F. P. E. Putra, R. W. Efendi, A. B. Tamam, and W. A. Pramadi, “Tren dan Praktik Terbaik dalam Pengembangan Web Berbasis API : Kajian Literatur terhadap Framework Laravel dan React,” Infomatek, vol. 27, no. 1, pp. 165–178, 2025, doi: 10.23969/infomatek.v27i1.25122.
[15] F. P. E. Putra, R. W. Efendi, A. B. Tamam, and W. A. Pramadi, “Trends and Best Practices in API-Based Web Development Using Laravel and React,” Brill. Res. Artif. Intell., vol. 5, no. 1, pp. 223–233, 2025, doi: 10.47709/brilliance.v5i1.5971.
[16] G. Alfian, M. Syafrudin, I. Fahrurrozi, N. L. Fitriyani, and ..., “Predicting breast cancer from risk factors using SVM and extra-trees-based feature selection method,” 2022, mdpi.com. [Online]. Available: https://www.mdpi.com/2073-431X/11/9/136
[17] M. Yusup, R. Hermawan, and S. D. Handayani, “Aplikasi Android Pengucapan Huruf Abjad sebagai Media Pembelajaran Membaca Cepat Tanpa Mengeja Menggunakan Flutter,” 2025, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v6i01.10607.
[18] A. Zulfiansyah, R. Edward, and U. Pauziah, “Perancangan Sistem Informasi Data Inventaris dan Karyawan pada PT. Rotaryana Berbasis Java,” 2023, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v4i02.5792.
[19] A. Yahadi, A. T. Hapsari, and A. T. W, “Sistem Pakar Diagnosa Kerusakan pada Motor Karburator dengan Metode Certainty Factor,” 2025, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v6i01.9023.
[20] M. D. Yanti, F. A. Mustika, and H. Dhika, “Sistem Informasi Penjualan pada Koperasi Zam Zam Berbasis Java,” 2024, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v5i4.8094.
[21] A. Widianto, A. Shobikah, N. D. Kurniasari, T. B. Rohman, and G. Triono, “Implementasi Sistem Registrasi Wisuda Terintegrasi dengan Validasi Kehadiran Dual-Mode Berbasis QR Code,” 2025, Institut Teknologi Adhi Tama Surabaya. doi: 10.31284/j.kernel.2025.v6i2.8423.
[22] Yuwono Fitri Widodo, “Analisis Perubahan Bentuk Pola Suara Serak Sebagai Indikator Kondisi Kesehatan,” 2025, Nusa Putra University. doi: 10.52005/restikom.v7i2.469.
[23] W. Widyanto, F. A. R. Saputra, and A. Rachman, “Perancangan Program Perhitungan Solusi Numerik Menggunakan Metode Bolzano pada Bahasa Python,” 2022, Institut Teknologi Adhi Tama Surabaya. doi: 10.31284/j.kernel.2022.v3i1.2557.
[24] D. WULANDARI, “Analisa Sosialisasi Netiket dalam Berkomunikasi di Aplikasi Pesan Instan dan Media Sosial,” 2023, Nusa Putra University. doi: 10.52005/restikom.v5i1.103.
[25] A. H. Wijaya, A. Vandaningtyas, and R. K. Hapsari, “Penentuan Destinasi Wisata Favorit di Yogyakarta dengan Menggunakan Algoritma Decision Tree,” 2023, Institut Teknologi Adhi Tama Surabaya. doi: 10.31284/j.kernel.2023.v4i2.7473.
[26] N. Wiliani, M. A. Supatra, and H. Wahyono, “Ultra-Micro Lending Eligibility Support System With Exponential Comparison Method (MPE),” 2023, Kresnamedia Publisher. doi: 10.34288/jri.v5i3.240.
[27] Witri Hartati, “Perancangan Sistem Aplikasi Pemesanan Lapangan Berbasis Web Pada Mutiara Futsal,” 2024, Nusa Putra University. doi: 10.52005/restikom.v6i2.278.
[28] D. Zahra, M. Sonny, and N. Nurfidah, “Perancangan Sistem Aplikasi Jasa Grooming dan Penjualan pada Family Pet Shop,” 2023, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v4i03.7303.
[29] F. P. E. Putra, U. Ubaidi, A. Hamzah, W. A. Pramadi, and A. Nuraini, “Systematic Literature Review: Security Gap Detection On Websites Using Owasp Zap,” Brill. Res. Artif. Intell., vol. 4, no. 1, pp. 348–355, 2024, doi: 10.47709/brilliance.v4i1.4227.
[30] F. P. E. Putra, M. Dafid, and I. Syafi’i, “Firewall Implementation as a Computer Network Security Strategy for Data Protection,” Brill. Res. Artif. Intell., vol. 5, no. 1, pp. 291–297, 2025, doi: 10.47709/brilliance.v5i1.6162.
[31] F. P. E. Putra, A. B. Tamam, R. W. Efendi, and Z. Muim, “Optimasi Keamanan DNS_ Eksplorasi Optimal dengan Implementasi DNS Security Extensions (DNSSEC),” Ris. dan E-Jurnal Manaj. Inform. Komput., vol. 8, no. 1, pp. 349–358, 2024, [Online]. Available: https://jurnal.polgan.ac.id/index.php/remik/article/view/13398%0Ahttps://jurnal.polgan.ac.id/index.php/remik/article/download/13398/2325
[32] N. H. Hari, F. P. E. Putra, M. N. Arifin, M. Y. Zain, and ..., “Desain dan Perancangan Smart Campus berbasis ZigBee Wireless Sensor Network,” J. Inov. Tek. …, 2021, [Online]. Available: https://www.academia.edu/download/107654513/2098.pdf
[33] S. Arifin, N. P. Dewi, M. N. Arifin, and ..., “Aplikasi Pengolahan Data Mahasiswa KKN pada Universitas Madura,” … Inf. Sci. …, 2023, [Online]. Available: http://ejournal.unira.ac.id/index.php/insand_comtech/article/view/2085
[34] F. P. E. Putra, Pengembangan sumberdaya pembelajaran terbuka pada matakuliah jaringan komputer di lingkungan Universitas Madura. repository.um.ac.id, 2024. [Online]. Available: https://repository.um.ac.id/349870/
[35] F. P. E. Putra, M. Surur, M. Mahendra, and G. Arifin, “Internet Network QOS Analysis at Yala Kopitiam pamekasan Using Wireshak,” Brill. Res. Artif. Intell., vol. 5, no. 1, pp. 190–200, 2025, doi: 10.47709/brilliance.v5i1.5940.
[36] F. P. E. Putra and M. M. Umar, “Jaringan Komputer Untuk Pemula,” PT. Literasi Nusant. Abadi Grup Perumah. Puncak …, 2023.
[37] F. P. E. Putra, U. Ubaidi, M. Mahendra, M. Surur, and A. Rizki, “4G LTE Network Performance Analysis Provider 3 In Pamekasan Using The G-Nettrack Application,” Brill. Res. Artif. Intell., vol. 4, no. 1, pp. 427–433, 2024, doi: 10.47709/brilliance.v4i1.4376.
[38] F. P. E. Putra, A. Zulfikri, A. Rohman, and ..., “Analysis Comparative of Performance Optimization Techniques for PHP Framework Testing: Laravel, CodeIgniter, Symfony: Analisis Perbandingan Teknik Optimasi …,” Brill. Res. …, 2025, [Online]. Available: https://itscience-indexing.com/jurnal/index.php/brilliance/article/view/5989
[39] F. P. E. Putra, D. T. Agustina, T. S. K. Khotimah, and ..., “Analisis Kinerja Jaringan 5G dalam Meningkatkan Konektivitas Internet of Things (IoT),” J. Inform. Dan …, 2025, [Online]. Available: https://www.researchgate.net/profile/Fauzan-Eka-Putra-2/publication/392420839_Analisis_Kinerja_Jaringan_5G_dalam_Meningkatkan_Konektivitas_Internet_of_Things_IoT/links/6848f86cdf0e3f544f5e49e9/Analisis-Kinerja-Jaringan-5G-dalam-Meningkatkan-Konektivitas-Internet-of-Things-IoT.pdf
[40] F. P. E. Putra, D. E. Arissandi, A. Rofiqi, and ..., “Pemanfaatan Mikrotik Dalam Manajemen Bandwidth Pada Jaringan Sekolah,” J. Inform. dan …, 2025, [Online]. Available: https://www.researchgate.net/profile/Fauzan-Eka-Putra-2/publication/392420575_Pemanfaatan_Mikrotik_Dalam_Manajemen_Bandwidth_Pada_Jaringan_Sekolah/links/6848fab46b5a287c304a61ca/Pemanfaatan-Mikrotik-Dalam-Manajemen-Bandwidth-Pada-Jaringan-Sekolah.pdf
[41] L. Widianingrum, “Implementasi Sistem Administrasi pada PT MSH Niaga Telecom Berbasis Desktop,” 2022, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v3i03.3616.
[42] N. Yulyanti, Y. Yulianingsih, and B. D. Theodora, “Perancangan Sistem Informasi Penjualan Kopi pada Kedai Soyu Berbasis Java,” 2023, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v4i04.5194.
[43] F. Yudoyono, I. Agus, and T. Handayani, “Perancangan Aplikasi Kepegawaian pada Yayasan Darul Arqam Studio Berbasis Desktop,” 2024, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v5i4.7283.
[44] E. M. Wijaya and P. D. Mardika, “Penerapan Sistem Informasi Manajemen Purnabakti Pegawai UPTD SDN Kemirimuka 3 Menggunakan Metode Scrum,” 2024, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v5i2.10778.
[45] R. D. P. Winoto and W. Rahayu, “Perancangan Aplikasi Penyewaan Lapangan Futsal Berbasis Java Netbeans pada JR Futsal Bekasi,” 2022, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v3i02.3718.
[46] T. Yuwono and M. Hermawati, “Sistem Informasi Tagihan Sarana Air Bersih Badan Usaha Milik Masjid Nurul Hidayah,” 2024, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v5i3.11115.
[47] M. R. Zenuddin, Z. Niswati, and E. Sulistyaniningsih, “Aplikasi Pendataan Iuran Warga dan Penggajian Petugas pada Perumahan Griya Tajurhalang Berbasis Java Netbeans,” 2025, Universitas Indraprasta PGRI. doi: 10.30998/jrami.v6i03.5578.
[48] Z. Y. Huang, C. C. Chiang, J. H. Chen, Y. C. Chen, and ..., “A study on computer vision for facial emotion recognition,” 2023, nature.com. [Online]. Available: https://www.nature.com/articles/s41598-023-35446-4
[49] T. Dupont et al., “The FEniCS Project,” Simula SpringerBriefs Comput., 2026, doi: 10.1007/978-3-032-17396-6.
[50] Z. Fan et al., “Large Spatial Model: End-to-end Unposed Images to Semantic 3D,” ArXiv, 2024, doi: 10.48550/arXiv.2410.18956.
[51] U. R. Jannah1, F. P. E. Putra, A. Rofiq, and H. B. Hafsi, SEKOLAH INKLUSI DENGAN PEMANFAATAN MEDIA VISUAL SCRATCH DAN ALAT. pdfs.semanticscholar.org, 2021. [Online]. Available: https://pdfs.semanticscholar.org/e373/775c36def1b7f6498b395140b1411e43877c.pdf
{BIBLIOGRAPHY
Downloads
Published
Issue
Section
License
Copyright (c) 2026 ANISA TRIYANA, AURA ILLA SARI (Penulis)
This work is licensed under a Creative Commons Attribution 4.0 International License.
