Implementation of a Web-Based Smart Water Ordering System with Telegram Notification and Monitoring Dashboard for Olivia MSME
DOI:
https://doi.org/10.35870/ijsecs.v6i3.8155Keywords:
Smart Water Ordering System, Qris Payment, Telegram Bot Notification, Monitoring Dashboard, Waterfall MethodAbstract
Many micro, small, and medium enterprises (MSMEs) selling refillable drinking water still manage customer orders manually through phone calls and instant messaging, resulting in scattered transaction records, delayed responses, and limited operational monitoring. This study aimed to design, implement, and evaluate a web-based Smart Water Ordering System for Olivia MSME by integrating Quick Response Code Indonesian Standard (QRIS) payment, Telegram Bot notifications, and a centralized monitoring dashboard. The system was developed using the Waterfall Software Development Life Cycle (SDLC), encompassing requirement analysis, Unified Modeling Language (UML)-based system design, implementation using PHP and MySQL, and comprehensive system testing. The platform incorporates customer order placement, coordinate-based shipping-distance calculation, cashless transaction processing, and a moderated customer feedback mechanism. Functional validation through Black Box Testing confirmed that all core modules executed successfully without functional discrepancies, with the asynchronous Telegram webhook delivering order alerts in under two seconds. User Acceptance Testing involving 23 respondents (one administrator and twenty-two customers) yielded average satisfaction scores ranging from 4.7 to 4.9 out of 5, demonstrating high user acceptance across usability, interface clarity, feature suitability, information accessibility, and operational support. Practically, the system replaced conventional phone-based communication by centralizing transaction records, automating payment verification workflows, and providing real-time sales analytics through an integrated dashboard. These findings indicate that unifying transactional, payment, instant alert, and administrative monitoring components into a single web application effectively improves operational efficiency and accelerates the digital transformation of small-scale water-refill enterprises.
Downloads
References
Alfiana, A., Sintesa, N., Dwihandoko, T. H., Lestari, E. B., & Nersiwad, N. (2025). Analisis penerimaan QRIS di kalangan UMKM. Jurnal Lentera Bisnis, 14(2). https://doi.org/10.34127/jrlab.v14i2.1528
Angel, R., Agustina, W., Nurhasanah, N., Mauluddin, A. C., & Handayani, R. N. (2025). Pengembangan platform e-commerce UMKM berbasis Laravel dengan Blackbox Testing dan metode Waterfall. Jurnal Pendidikan dan Teknologi Indonesia, 5(2), 521–546. https://doi.org/10.52436/1.jpti.684
Anggara, N. A. A., Hutahaean, J., & Iqbal, M. (2022). Penerapan customer relationship management (CRM) dalam sistem informasi penjualan kosmetik berbasis web. Building of Informatics, Technology and Science (BITS), 3(4), 480–488. https://doi.org/10.47065/bits.v3i4.1440
Aryantoro, M. B., Widayanti, R., Ariessanti, H. D., & Laksana, R. P. (2025). Implementasi sistem informasi penjualan berbasis website sebagai strategi digitalisasi UMKM pada Rano Cake. Journal of Innovative and Creativity, 5(3), 30224–30235. https://doi.org/10.31004/joecy.v5i3.4499
Devansyah, S., Samala, A. D., Zaus, M. A., & Putra, R. (2025). Rancang bangun sistem informasi pemesanan air minum isi ulang berbasis framework Laravel. Jurnal Pendidikan Tambusai, 9(2). https://doi.org/10.31004/jptam.v9i2.27883
Fahrudin, & Isnaini, P. L. (2023). Pengaruh penggunaan Quick Response Code Indonesian Standard (QRIS) oleh UMKM terhadap pendapatan usaha. Jurnal Manajemen Strategi dan Simulasi Bisnis (JMASSBI), 4(1), 1–12. https://doi.org/10.25077/mssb.4.1.1-12.2023
Fakih, I. A., Ramadhan, F., & Saputra, R. (2025). Implementasi sistem point of sales berbasis website untuk meningkatkan efisiensi penjualan pada UMKM BruleeBites di Jakarta Timur. Jurnal Intelektual Cita.
Febriani, N. K. D., Utami, N. W., & Putri, I. G. A. P. D. (2023). Analisis behavioral intention dan use behavior Quick Response Code Indonesian Standard (QRIS) pada UMKM dengan metode UTAUT 2 di Kota Denpasar. Jurnal Ilmiah Teknologi Informasi Asia, 17(1). https://doi.org/10.32815/jitika.v17i1.890
Hibatullah, M. H., Tukino, T., & Hananto, A. L. (2025). Perancangan website e-commerce menggunakan metode Waterfall pada penjualan alat komputer. Jurnal SINTA: Sistem Informasi dan Teknologi Komputasi, 2(3), 116–124. https://doi.org/10.61124/sinta.v2i3.61
Indriani, A., Pramudito, D. K., & Suherman. (2024). An agile development method of employee co-op shop web-based sales information system. Jurnal Informasi dan Teknologi, 6(2), 123–132. https://doi.org/10.60083/jidt.v6i2.538
Ismail, S. N., Septian, F., Arisantoso, A., & Setiyani, H. (2026). Pengembangan sistem dashboard penjualan pada UMKM berbasis website (Studi kasus: Toko Wyloz). JRIS: Jurnal Rekayasa Informasi Swadharma, 6(1), 30–37. https://doi.org/10.56486/jris.vol6no1.953
Khairunnisa, D. Z., Falah, M., Vandera, A., Viwinanda, Z. S., Fathurrahman, M. D., & Septian, F. R. (2026). Perancangan sistem informasi dan analisis penjualan depot galon dengan proses RO berbasis web menggunakan metode Incremental. Jurnal Pendidikan Tambusai, 10(1). https://doi.org/10.31004/jptam.v10i1.37870
Kusumawati, E. D., & Kartikasari, D. (2025). Optimalisasi kinerja keuangan usaha kuliner melalui implementasi QRIS. Owner: Riset dan Jurnal Akuntansi, 9(1), 399–410. https://doi.org/10.33395/owner.v9i1.2572
Natsir, K., Bangun, N., Attan, M. B., & Landias, J. S. (2023). Penggunaan QRIS sebagai alat pembayaran digital untuk meningkatkan produktivitas UMKM. Jurnal Serina Abdimas, 1(3). https://doi.org/10.24912/jsa.v1i3.26208
Poerwandono, E., Nabilah, L., Azzizah, P. S. D., & Maharani, D. (2025). Implementasi sistem informasi presensi berbasis web di TK Nailus Sa'adah. INFORMASI: Jurnal Informatika dan Sistem Informasi, 17(1). https://doi.org/10.37424/informasi.v17i1.355
Pranatawijaya, V. H. (2022). Analisis dan desain penerapan Location Based Service (LBS) untuk layanan pengiriman katering di Kota Palangka Raya. Jurnal Teknologi Informasi: Jurnal Keilmuan dan Aplikasi Bidang Teknik Informatika, 11(2). https://doi.org/10.47111/jti.v11i2.654
Puriati, N. M., Sugiartana, I. W., & Mertaningrum, N. P. E. (2023). Efektivitas penerapan sistem pembayaran Quick Response Code Indonesia Standard (QRIS) pada UMKM di Kabupaten Karangasem. Jurnal Ilmiah Akuntansi dan Humanika, 13(3). https://doi.org/10.23887/jiah.v13i3.70942
Rizal, M., Setiaji, G. G., & Zaman, B. (2026). Rancang bangun sistem informasi pemesanan air galon berbasis web menggunakan metode RAD. TIN: Terapan Informatika Nusantara, 7(1), 208–218. https://doi.org/10.47065/tin.v7i1.10069
Saputra, D., Pakpahan, H. S., & Andriawan, D. (2025). Analisis dan perancangan sistem informasi penjual pada Toko Serba 35 Palangka Raya berbasis web. Jurnal Sistem Informasi, Manajemen dan Teknologi Informasi (SIMTEK), 3(2). https://doi.org/10.33020/jsimtek.v3i2.838
Saputra, D., Setiawan, H., Suyanto, S., & Audrik, A. (2025). Digitalisasi pemasaran UMKM kuliner olahan kacang Beantien Tanjungpinang melalui sistem informasi penjualan berbasis website. Batara Wisnu: Indonesian Journal of Community Services, 5(3), 1092–1107. https://doi.org/10.53363/bw.v5i3.468
Sari, N. Y., Hematang, F. R. H., & Rifai, M. (2023). Perancangan sistem informasi pemasaran dan penjualan depot air minum isi ulang "Amary Water" berbasis web. Scientia Sacra: Jurnal Sains, Teknologi dan Masyarakat, 3(2).
Sholihah, E., & Nurhapsari, R. (2023). Percepatan implementasi digital payment pada UMKM: Intensi pengguna QRIS berdasarkan Technology Acceptance Model. Nominal: Barometer Riset Akuntansi dan Manajemen, 12(1). https://doi.org/10.21831/nominal.v12i1.52480
Sumampow, R. F., Ibrahim, I., & Capah, D. A. H. (2023). Dashboard monitoring data penjualan menggunakan metode star schema. Jurnal Ilmiah FIFO, 15(2), 123–134. https://doi.org/10.22441/fifo.2023.v15i2.006
Tibyani, T. (2021). Pemanfaatan teknologi notifikasi BOT Telegram dalam pengembangan sistem customer reminder berbasis web (Studi kasus: PT Astra International Tbk-TSO Cabang Sukun, Malang). Jurnal Sistem Informasi, Teknologi Informasi, dan Edukasi Sistem Informasi, 2(2), 64–73. https://doi.org/10.25126/justsi.v2i2.21
Wahyudi, T., Sahay, A. S., & Sylviana, F. (2022). Perancangan sistem informasi penjualan air galon isi ulang di Kota Palangka Raya berbasis web. Journal of Information Technology and Computer Science (JOINTECOMS), 2(2). https://doi.org/10.47111/jointecoms.v2i2.8851
Widiyanto, R. A., & Wicaksono, B. S. (2022). Perancangan sistem informasi monitoring laporan penjualan multi cabang berbasis web dengan metode prototype (Studi kasus: Toko King Cellular). Biner: Jurnal Ilmiah Informatika dan Komputer, 1(1), 26–33. https://doi.org/10.32699/biner.v1i1.2450
Yudhistira, O. E., & Suharjo, I. (2025). Prototype pendeteksi kebakaran multiruang menggunakan NodeMCU ESP8266 dengan notifikasi Bot Telegram. Jurnal Informatika dan Teknik Elektro Terapan (JITET), 13(1). https://doi.org/10.23960/jitet.v13i1.5992
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Ropindo Pelix Pane, Mesra Betty Yel, Edhy Poerwandono
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.
