Web-Based Operational CRM System for Client Retention in Wedding Organizer MSMEs: Design and Black-Box Validation

Zeni Arya; Muhammad Amin; Indra Ramadona Harahap

doi:10.56427/jcbd.v5i3.1070

Authors

Zeni Arya Universitas Royal
Muhammad Amin Universitas Royal
Indra Ramadona Harahap Universitas Royal

DOI:

https://doi.org/10.56427/jcbd.v5i3.1070

Keywords:

Customer relationship management, Client retention, Web-based information system, Wedding organizer, Micro, small, and medium enterprises

Abstract

Elita Wedding Organizer, a wedding service micro, small, and medium enterprise (MSME) in Asahan Regency, Indonesia, faces markedly seasonal demand but records orders on paper and keeps no client database. This study designs, develops, and validates a web-based operational Customer Relationship Management (CRM) system to strengthen client relationships and retention. Requirements were elicited through semi-structured interviews with the owner, observation of service processes, and analysis of 2025 revenue records covering 168 service units, showing 65.5 per cent of revenue concentrated in 15.5 per cent of units. Development followed the waterfall model, with UML and ERD modelling and implementation in PHP and MySQL on an eighteen-table database. The system delivers twenty functions for three actors, mapped onto the acquire, enhance, and retain phases of CRM, including an online package catalogue, a structured price-negotiation module, two-way live chat, testimonials and ratings, tier-based membership vouchers, and transaction reporting. Black-box testing of thirteen scenarios across six functional groups achieved 100 per cent conformance to specification. The novelty lies in integrating structured price negotiation with tier-based membership vouchers, features not reported by four comparable wedding organizer systems. The effect of the system on client retention was not measured and is left for future research.

Downloads

Download data is not yet available.

References

[1] R. Sinaga and R. Ramadhana Sembiring, “Analisis Peluang Usaha Wedding Organizer Pada Kaum Millennial,” Journal of Millennial Community, vol. 3, no. 2, pp. 107–113, Sep. 2021, doi: 10.24114/jmic.v3i2.32346.

[2] T. A. R. Umri, Samsudin, and A. M. Harahap, “Sistem Informasi Pemesanan Nita Wedding Organizer Dengan Penerapan Customer Relationship Management Berbasis Web,” Journal of Science and Social Research, vol. 7, no. 2, pp. 573–580, May 2024, doi: 10.54314/jssr.v7i2.1875.

[3] V. Hikmatillah, “E-CRM Berbasis Web Pada Sistem Informasi Penjualan Toko Kue,” JATISI (Jurnal Teknik Informatika dan Sistem Informasi), vol. 9, no. 4, pp. 3108–3118, Dec. 2022, doi: 10.35957/jatisi.v9i4.2365.

[4] A. Rimbasari and L. Afandi, “Implementasi Customer Relationship Management dalam Meningkatkan Loyalitas Pelanggan pada UMKM Luqky Sablon Pekalongan,” Jurnal Bisnis Mahasiswa, vol. 5, no. 4, pp. 1710–1724, Jun. 2025, doi: 10.60036/jbm.699.

[5] S. Fauziyyah and K. Khusna, “Implementation Of Customer Relationship Management In Order To Build Customer Satisfaction And Loyalty,” Jurnal Manajemen Indonesia, vol. 22, no. 1, pp. 13–22, Apr. 2022, doi: 10.25124/jmi.v22i1.2802.

[6] K. D. Purnama and G. Manalu, “Evolution and Challenges of Customer Relationship Management (CRM) Implementation in the Digital Economy: A Systematic Review,” Journal of Management and Informatics, vol. 3, no. 1, pp. 71–86, Apr. 2024, doi: 10.51903/jmi.v3i1.40.

[7] A. Wulandari and V. A. Rahmi, “Analisis Strategi Customer Relationship Management dalam Membangun Loyalitas Pelanggan Pada Bisnis Dearly Cake,” Jurnal Lentera Bisnis, vol. 14, no. 1, pp. 39–49, Jan. 2025, doi: 10.34127/jrlab.v14i1.1289.

[8] D. Gunadi and Riki, “Analysis and Design of Web-Based Wedding Planner Applications Case Studies on Resta Wedding Organizers,” Journal Bit-Tech : Binary Digita; Technology, vol. 5, no. 1, pp. 13–24, Aug. 2022, doi: 10.32877/bt.v5i1.525.

[9] M. R. Baharsyah and I. R. I. Astutik, “Information System for Wedding Service Ordering Based on Web,” JOINCS (Journal of Informatics, Network, and Computer Science), vol. 4, no. 2, pp. 28–31, Nov. 2021, doi: 10.21070/joincs.v4i2.1590.

[10] A. M. Kurniawan and H. D. Ariessanti, “Perancangan Layanan Wedding Organizer Berbasis Web Terintegrasi Midtrans,” Jurnal Minfo Polgan, vol. 14, no. 2, pp. 2109–2115, Sep. 2025, doi: 10.33395/jmp.v14i2.15308.

[11] D. P. Ramadhani, H. Syafwan, and C. Latiffani, “Penerapan Metode E – CRM Pada Toko Wati Collection,” JATISI (Jurnal Teknik Informatika dan Sistem Informasi), vol. 9, no. 4, pp. 3503–3518, Dec. 2022, doi: 10.35957/jatisi.v9i4.2839.

[12] Prabowo, R. R. Harahap, and H. W. Dhany, “Rancang Bangun dan Implementasi Customer Relationship Management Sistem Informasi Berbasis Web Wedding Organizer (Studi Kasus Ina Wedding Organizer),” Jurnal Komputer Teknologi Informasi Sistem Komputer (JUKTISI), vol. 5, no. 2, pp. 1480–1489, Jul. 2026, doi: 10.62712/juktisi.v5i2.1379.

[13] R. Irawan and J. Aryanto, “Portal Wedding Organizer Untuk Inovasi Teknoligi Sebagai Solusi Digital Pelayanan Publik,” INTECOMS: Journal of Information Technology and Computer Science, vol. 7, no. 6, pp. 2363–2369, Dec. 2024, doi: 10.31539/intecoms.v8i1.12920.

[14] Mutia, I. Iskandar, and S. M. Tanjung, “Double Moving Average and Double Exponential Smoothing Method in Sales Forecasting,” Journal of Computers and Digital Business, vol. 3, no. 3, pp. 112–120, Sep. 2024, doi: 10.56427/jcbd.v3i3.599.

[15] V. M. Sushkov, P. Y. Leonov, O. S. Nadezhina, and I. Y. Blagova, “Integrating Data Mining Techniques for Fraud Detection in Financial Control Processes,” International Journal of Technology, vol. 14, no. 8, pp. 1675–1684, Sep. 2023, doi: 10.14716/ijtech.v14i8.6830.

[16] N. S. Yeop, N. H. Zakaria, and S. Suendri, “Enhancing the Effectiveness of Machine Learning-Based Phishing Email Detection via an Improved Pre-Processing Technique for Data Security,” Journal of Information and Communication Technology, vol. 24, no. 4, pp. 87–110, Oct. 2025, doi: 10.32890/jict2025.24.4.4.