Design and Implementation of a Web-Based E-CRM System for Customer Management in Muslim Fashion MSMEs

Indra Perdana; Jeperson Hutahaean; Parini

doi:10.56427/jcbd.v5i3.1051

Authors

Indra Perdana Universitas Royal
Jeperson Hutahaean Universitas Royal
Parini Universitas Royal

DOI:

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

Keywords:

Electronic Customer Relationship Management, Customer Management, Digital Marketing, Web-Based Information System, Muslim Fashion MSME

Abstract

Micro, small and medium enterprises (MSMEs) in the Muslim fashion sector compete through digital channels, yet many still record customer data manually and promote products generically. Toko Alya, a Muslim fashion retailer in Kisaran, North Sumatra, keeps paper-based transaction records, handles customer interaction across scattered messaging channels and manages an uneven stock of sixteen product items without an integrated view of its customers. This study designs and implements a web-based Electronic Customer Relationship Management (E-CRM) system that integrates customer management and marketing on a single e-commerce platform. Following a qualitative descriptive approach, data were collected through interviews with the owner, observation, a closed-ended questionnaire and a literature study. The system was modelled with the Unified Modeling Language and an Entity Relationship Diagram, built with PHP and MySQL, and verified through functional testing. It provides 28 interfaces organised around the acquire, enhance and retain phases of E-CRM, including a product catalogue, voucher module, order tracking, rating and review, member database and sales reporting. The system consolidates fragmented customer records, delivers targeted promotions to identified customers and supports on-demand reporting for managerial decisions. Its effect on customer loyalty, satisfaction and sales was not measured and is left for further research.

Downloads

Download data is not yet available.

References

[1] F. Fitriany and Yurisman Star, “Implementasi Customer Relationship Management (CRM) dalam Strategi Pemasaran UMKM Berbasis Digital,” MAMEN: Jurnal Manajemen, vol. 4, no. 4, pp. 805–817, Oct. 2025, doi: 10.55123/mamen.v4i4.6490.

[2] S. Manurung, M. A. Sembiring, and S. R. M. Azmi, “Penerapan E-CRM Dalam Strategi Pemasaran Online Barang Retail Rumah Tangga,” Jurnal Algoritma, vol. 22, no. 2, Nov. 2025, doi: 10.33364/algoritma/v.22-2.2651.

[3] P. Prasetya and R. Lubis, “Pembangunan Sistem Electronic Customer Relationship Management (E-CRM) PT. Farhan Surya Indah Development Of Electronic Customer Relationship Management System (E-CRM) PT. Farhan Surya Indah,” Jurnal Penelitian Mahasiswa Teknik dan Ilmu Komputer (JUPITER), vol. 1, no. 1, pp. 20–26, Aug. 2021, doi: 10.34010/jupiter.v1i1.5405.

[4] A. M. Ariska, N. Irawati, and A. Muhazir, “Penerapan Elektronik Customer Relationship Management (E-CRM) Dalam Penjualan Roti Berbasis Web,” Jurnal Media Informatika Budidarma, vol. 6, no. 2, p. 1090, Apr. 2022, doi: 10.30865/mib.v6i2.4002.

[5] A. N. Ilyas, L. L. Hin, J. Sutrisno, and R. Rusdah, “Implementasi Electronic Customer Relationship Management (E-CRM) untuk Meningkatkan Layanan Pelanggan Belig Coffee,” STRING (Satuan Tulisan Riset dan Inovasi Teknologi), vol. 9, no. 1, p. 13, Aug. 2024, doi: 10.30998/string.v9i1.20322.

[6] Rizky Rachmadiyanto, Setiawan Assegaff, and Beni Purnama, “Analisis Dan Perancangan Sistem Electronic Customer Relationship Management (E-Crm) Pada Otoxpert Jambi,” Jurnal Informatika Dan Rekayasa Komputer(JAKAKOM), vol. 5, no. 2, pp. 1546–1555, Sep. 2025, doi: 10.33998/jakakom.2025.5.2.2300.

[7] S. A. Rahma, H. Holipah, H. Al Rasyid, and F. Rahmayanti, “Hubungan Electronic Customer Relationship Management (E-Crm) Terhadap Loyalitas Pasien Di Rumah Sakit: Tinjauan Pustaka,” Jurnal Teknologi Informasi dan Ilmu Komputer, vol. 10, no. 3, Jul. 2023, doi: 10.25126/jtiik.2023106698.

[8] A. Solechan and H. Kusumo, “Strategi e-CRM Untuk Meningkatkan Kepuasan Konsumen : Sebuah Literatur Review,” Dinamika: Jurnal Manajemen Sosial Ekonomi, vol. 2, no. 1, pp. 64–74, May 2022, doi: 10.51903/dinamika.v2i1.142.

[9] Lidya Adriani Darma, Rini Sovia, and Heriyanto, “Penerapan E-Commerce Model Business To Customer D’Sruput Cabang Lubuk Begalung Berbasis Web,” Journal of Computers and Digital Business, vol. 1, no. 2, pp. 65–71, Sep. 2022, doi: 10.56427/jcbd.v1i2.14.

[10] Evy Nurmiati and Ainun Nashikha, “Optimalisasi E-CRM Pada Starup Digital Untuk Meningkatkan Retensi Pelanggan: Systematic Literature Review,” Jurnal Perangkat Lunak, vol. 7, no. 2, pp. 133–143, Jun. 2025, doi: 10.32520/jupel.v7i2.4126.

[11] M. S. Harlina, E. Susilowati, S. Suharni, M. S. Herawati, and M. F. Atsiilah, “Pemodelan Sistem Rancangan Website Toko Ummi Cookies Menggunakan Uml (Unified Modelling Language),” Jurnal Teknologi Dan Sistem Informasi Bisnis, vol. 7, no. 3, pp. 364–371, Jul. 2025, doi: 10.47233/jteksis.v7i3.1943.

[12] M. R. Wayahdi and F. Ruziq, “Pemodelan Sistem Penerimaan Anggota Baru dengan Unified Modeling Language (UML) (Studi Kasus: Programmer Association of Battuta),” Jurnal Minfo Polgan, vol. 12, no. 1, pp. 1514–1521, Aug. 2023, doi: 10.33395/jmp.v12i1.12870.

[13] P. Skavantzos and S. Link, “Entity/Relationship Graphs: Principled Design, Modeling, and Data Integrity Management of Graph Databases,” Proc. ACM Manag. Data, vol. 3, no. 1, Feb. 2025, doi: 10.1145/3709690.

[14] A. Fathi Farahat, A. Dewi Ambarwati, and A. Lestari, “Pengaruh E-Commerce, E-Crm, Dan Database Terhadap Sistem Informasi Penjualan (Literature Sistem Informasi Manajemen),” Jurnal Ilmu Multidisplin, vol. 1, no. 1, pp. 215–224, Jun. 2022, doi: 10.38035/jim.v1i1.31.

[15] H. Zahida, I. Febrilia, I. Febrilia, R. Rahmi, and R. Rahmi, “Pengaruh Customer Relationship Management (CRM) terhadap Customer Loyalty dengan Customer Satisfaction sebagai Variabel Intervening,” Jurnal Pemasaran Kompetitif, vol. 7, no. 1, Oct. 2023, doi: 10.32493/jpkpk.v7i1.32117.