Implementation of a Web-Based Sales Information System for Culinary MSMEs: A Case Study of Bakmi Jogja and Mie Ayam Bangka
DOI:
https://doi.org/10.35870/ijsecs.v6i3.8352Keywords:
Sales Information System, Website, MSME, CodeIgniter 4, Prototype MethodAbstract
Micro, small, and medium enterprises (MSMEs) play a vital role in the local economy, yet many still rely on manual recording of sales transactions and financial reports, increasing the risk of calculation errors and delaying report preparation. This operational constraint was identified at Bakmi Jogja and Mie Ayam Bangka, a culinary MSME outlet in Cipinang Besar Selatan, East Jakarta, that offers two flagship menu lines within a single business establishment. This study aimed to design, implement, and evaluate a web-based sales information system to address these operational challenges. A descriptive qualitative case-study method was applied, with empirical data gathered through interviews, direct observation, and literature review. System development followed the Prototype model comprising communication, quick planning, modeling, prototype construction, and deployment with user feedback. The system was developed using the CodeIgniter 4 framework, a MySQL/MariaDB database, and the Midtrans payment gateway for QRIS-based digital payments, followed by deployment on commercial cloud hosting for actual operational adoption rather than offline simulation. Black box testing evaluating authentication, product management, transaction recording, payment integration, order-status tracking, promotional banner management, and financial reporting yielded valid results across all twelve test scenarios spanning seven functional modules. As early empirical evidence, the system logged five operational transactions over a seven-day observation window, four of which were completed with confirmed revenue of IDR 224,000, identifying Bakmi Jogja Godog Special as the top-selling menu item. These findings demonstrate that the system transitioned manual record-keeping to automated, database-backed transactions, accelerated financial report generation from approximately one week to an on-demand summary, and provided a digital storefront facilitating online ordering and marketing for the enterprise.
Downloads
References
Aldiansyah, M. Y., Rahma, N., Dahri, R., Asnawati, Yasril, M., & Hidayah, T. R. (2026). Analisis dampak sistem informasi penjualan produk berbasis web terhadap UMKM: Tinjauan literatur sistematis. Jurnal Bisnis Digital dan Teknologi (DIGITEK), 2(1).
Aryantoro, M. B., Widayanti, R., Ariessanti, H. D., & Laksana, R. P. (2025). Implementasi sistem informasi penjualan website sebagai strategi digitalisasi UMKM pada Rano Cake. Journal of Innovative and Creativity (JOECY), 5(3).
Dwiyanti, L., Ananta, M. J. C., & Hasibuan, T. H. (2025). Perancangan sistem informasi penjualan untuk usaha kuliner berbasis web di Warung Bunda. Jurnal Rekayasa Informasi Swadharma (JRIS), 5(1).
Hansen, Saputra, C., & Sandra, D. (2024). Perancangan sistem informasi pembelian dan penjualan berbasis web pada Toko Sumber Jaya. Jurnal Manajemen Teknologi dan Sistem Informasi (JMS), 4(2). https://doi.org/10.33998/jms.v4i2
Hibatullah, M. H., Tukino, & Hananto, A. L. (2025). Perancangan website e-commerce menggunakan metode waterfall pada penjualan alat komputer. SINTA Jurnal Sistem Informasi dan Teknologi Komputasi, 2(3). https://doi.org/10.61124/sinta.v2i3.61
Kilay, A. L., Simamora, B. H., & Putra, D. P. (2022). The influence of e-payment and e-commerce services on supply chain performance: Implications of open innovation and solutions for the digitalization of micro, small, and medium enterprises (MSMEs) in Indonesia. Journal of Open Innovation: Technology, Market, and Complexity, 8(3), Article 119. https://doi.org/10.3390/joitmc8030119
Mulyana, D. I., Kolbia, Nuradi, F., Sofia, A., Saputri, R., & Ummi. (2024). Rancang bangun aplikasi penjualan berbasis web pada UMKM HJM Garage Jonggol, Jawa Barat. AJAD Jurnal Pengabdian kepada Masyarakat, 4(1). https://doi.org/10.59431/ajad.v4i1.281
Parlina, I., & Sari, M. (2026). Perancangan sistem informasi penjualan produk frozen food menggunakan metode waterfall berbasis web dan xampp. Jurnal Sains dan Teknologi Informasi, 5(2). https://doi.org/10.47065/jussi.v5i3.9863
Permata, D. K., Sudarmaji, Anggoro, D., & Prabowo, D. J. (2024). Rancang bangun sistem informasi penjualan produk Panglong Kayu Anugerah Jaya berbasis web. JIKI (Jurnal Ilmu Komputer dan Informatika), 5(1).
Putra, A., & Sari, F. K. (2024). Pengembangan aplikasi sistem penjualan berbasis website pada Toko Kue Teratai. Jurnal Informatika Atma Jogja, 5(2).
Rojiyanti, H., Waluyo, A., & Fatich, E. V. L. N. (2025). Perancangan sistem informasi penjualan berbasis web di UMKM Towjo Innovation. Jurnal JASATEC, 5(1). https://doi.org/10.37339/jasatec.v5i1.2402
Samat, M. F., & Bashri, Z. A. A. (2025). The impact of cashless payment adoption on the performance of small and medium enterprises in Malaysia. GATR Global Journal of Business and Social Science Review, 13(1), 12–25. https://doi.org/10.35609/gjbssr.2025.13.1(2)
Sinaga, E., Al Farisyi, D. M., & Sinaga, L. G. (2026). Penerapan sistem informasi penjualan berbasis web untuk meningkatkan efisiensi operasional UMKM menggunakan bahasa pemrograman PHP. Jurnal Teknologi Sistem Informasi, 7(1). https://doi.org/10.35957/jtsi.v7i1.14142
Suprianto, A. W. S. (2024). Sistem informasi penjualan berbasis web untuk toko ritel. Indonesian Journal of Applied Technology, 1(2). https://doi.org/10.47134/ijat.v1i2.2485
Supriyono, S. (2020). Software testing with the approach of blackbox testing on the academic information system. International Journal of Information System & Technology (IJISTECH), 3(2), 227–233.
Waruwu, J., Harefa, Y. P., Laia, O., Gea, N. E., & Lase, D. C. (2024). Sistem informasi penjualan rumah berbasis web menggunakan database MySQL (Studi kasus CV. Rumah Impian). Jurnal Ilmiah Teknologi Informasi dan Komunikasi (JTIK), 15(2).
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Alya Kamila, Fatchurrachman Fatchurrachman, Mesra Betty Yel
This work is licensed under a Creative Commons Attribution 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.
