Journal of Artificial Intelligence and Engineering Applications (JAIEA)
Vol. 5 No. 3 (2026): June 2026

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

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



Article Info

Publish Date
15 Jun 2026

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.

Copyrights © 2026






Journal Info

Abbrev

JAIEA

Publisher

Subject

Automotive Engineering Computer Science & IT Control & Systems Engineering

Description

The Journal of Artificial Intelligence and Engineering Applications (JAIEA) is a peer-reviewed journal. The JAIEA welcomes papers on broad aspects of Artificial Intelligence and Engineering which is an always hot topic to study, but not limited to, cognition and AI applications, engineering ...