Sales Data Clustering Using the K-Means Algorithm to Determine Retail Product Needs
DOI:
https://doi.org/10.35870/ijsecs.v5i1.4090Keywords:
Data Mining, Clustering Techniques, K-Means Algorithm, Sales Analytics, Retail Product DemandAbstract
Sales data is a systematic record of transactional behavior with goods or services distributed over time boundaries and furnishes primary key business metrics for evaluating and planning. Using the K-Means clustering algorithm, this research segments retail product demand by differences attributes to identify demand patterns. The iterative process of clustering ended at the fifth cycle after the division of objects in each cluster stabilized, which can serve as a sign that we arrive at an optimal solution. Results showed that the first cluster located at a centroid 94, 6 contains 100 data items belonging in a primary set and similarly fifth cluster (same centroid) had also same number of products. The automated approach of Collaboratory also differs from the manual method where there are not pre-defined cluster initial values in our preliminary setup. Despite this procedural difference, there is a remarkable concision in the results which demonstrates the strength of the method when implemented using different ingrained constructions. These results offer some refined results on product classification, which is essential to solve the problem that retail ranks may vary during inventory management and sales optimization.
Downloads
References
Agussalim, A. (2023). Sales product clustering using RFM calculation model and K-Means algorithm on Primskystore. Technium: Romanian Journal of Applied Sciences and Technology, 16, 176-182. https://doi.org/10.47577/technium.v16i.9978
Astuti, J., & Yuniarti, T. (2023). Data mining modeling in clustering car products sales data in the automotive industry in Indonesia. Jurnal Manajemen Industri dan Logistik, 7(2), 261-281. https://doi.org/10.30988/jmil.v7i2.1258
Basuki, A. T. A., Paramastri, Z. P., Rachmayanti, D. F., Chan, D. A., & Aldo, D. (2024). Penerapan algoritma K-Means untuk pengelompokan pola penjualan oleh-oleh khas Medan. In Proceedings of the National Conference on Electrical Engineering, Informatics, Industrial Technology, and Creative Media (Vol. 4, No. 1, pp. 1194-1200).
Bilgiç, E., Çakır, Ö., Kantardzic, M., Duan, Y., & Cao, G. (2021). Retail analytics: Store segmentation using rule-based purchasing behavior analysis. The International Review of Retail, Distribution and Consumer Research, 31(4), 457-480. https://doi.org/10.1080/09593969.2021.1915847
Darmi, Y. D., & Setiawan, A. (2017). Penerapan metode clustering K-Means dalam pengelompokan penjualan produk. Jurnal Media Infotama, 12(2). https://doi.org/10.37676/jmi.v12i2.418
Dolega, L., Reynolds, J., Singleton, A., & Pavlis, M. (2019). Beyond retail: New ways of classifying UK shopping and consumption spaces. Environment and Planning B: Urban Analytics and City Science, 48(1), 132-150. https://doi.org/10.1177/2399808319840666
Firdausi, F., Afrianto, E., & Wiranto, F. (2023). Pastry sales data clustering with K-Means clustering approach for product grouping. Inside, 1(1), 36-41. https://doi.org/10.31967/inside.v1i1.887
Firman, F., Wulandari, N., & Irawan, A. (2020). Perancangan sistem informasi jurnal mengajar dosen berbasis web pada Fakultas Keguruan dan Ilmu Pendidikan Universitas Pendidikan Muhammadiyah Sorong. Jurnal Petisi (Pendidikan Teknologi Informasi), 1(1), 33-43. https://doi.org/10.36232/jurnalpetisi.v1i1.386
Hariyanto, A. (2020). Computer-based test dengan PHP MySQL dan Bootstrap. Yogyakarta: Loko Media.
Lestari, S., Nazila, R., Ulhar, L. A., & Zidane, M. (2024). Implementasi data mining dalam menentukan penjualan alat perabot dengan menggunakan metode K-Means clustering pada PT. XYZ. Jurnal Sistem Informasi dan Ilmu Komputer, 2(1), 271-278. https://doi.org/10.59581/jusiik-widyakarya.v2i1.2824
Nofriansyah, D., & Widi, G. (2015). Algoritma data mining dan pengujian. Yogyakarta: CV Budi Utama.
Raharjo, B. (2021). Pemrograman web. Bandung: Modula.
Ramadhan, R. F., Wijoyo, S. H., & Saputra, M. C. (2023). Penerapan metode K-Means clustering pada ulasan perumahan PT XYZ di Google Maps untuk formulasi strategi bisnis dengan analisis SWOT. Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, 7(6), 2879-2888.
Rosa, A. S., & M. S. (2016). Rekayasa perangkat lunak. Bandung: Informatika.
Rosidi, R. P. M., & Setiawan, K. (2024). Implementasi algoritma Naïve Bayes terhadap data penjualan untuk mengetahui pola pembelian konsumen pada kantin. Jurnal Indonesia: Manajemen Informatika dan Komunikasi, 5(1), 120-126. https://doi.org/10.35870/jimik.v5i1.407
Setiawan, M., & Rino, R. (2022). Design and application of K-Means method to predict sales at Arya Elektrik stores. Bit-Tech, 5(2), 67-76. https://doi.org/10.32877/bt.v5i2.562
Setyo, W. N., Wardhana, S., Informatika, J. T., & Komputer, F. I. (2019). Implementasi data mining pada penjualan produk di CV Cahaya Setya menggunakan algoritma FP-Growth. Vol, 12, 54-63.
Suyanto. (2017). Data mining. Yogyakarta: Informatika.
Vulandari, R. T. (2020). Data mining. Yogyakarta: Gava Media.
Widodo, E., & Hadikristanto, W. (2023). Pengelompokan untuk penjualan obat dengan menggunakan algoritma K-Means. Bulletin of Information Technology (BIT), 4(3), 408-413. https://doi.org/10.47065/bit.v4i3.848
Yahya, A., & Kurniawan, R. (2025). Implementation of K-Means algorithm for clustering sales data based on sales patterns. Malcom, 5(1), 350-358. https://journal.irpi.or.id/index.php/malcom.
Downloads
Published
Issue
Section
Categories
License
Copyright (c) 2025 Riwan Irosucipto Manarung, Edy Widodo, Anggi Muhammad Rifai
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
