Design of an E-Commerce Information System for Textile Material Sales Applying Customer Relationship Management (CRM)
Keywords:
E-commerce, Customer Relationship Management (CRM), information system, PHP, MySQLAbstract
The advancement of technology has transformed the way businesses interact with customers. An effective approach is to implement Customer Relationship Management (CRM) in e-commerce systems. Despite the growing body of literature on CRM and e-commerce integration, limited studies have addressed practical implementations for small-scale retail businesses in developing country contexts, particularly those operating textile material sales with fully manual legacy processes. This research aims to design and implement an e-commerce information system for Happy Abadi Store a textile material retailer by incorporating CRM methods grounded in the three core CRM objectives of customer identification, customer-centric program development, and coordinated service delivery as defined. The system is developed using PHP as the programming language and MySQL as the database management system. Using the Unified Modelling Language (UML) for system modeling, the design encompasses use case diagrams, class diagrams, activity diagrams, and sequence diagrams. The database consists of ten interrelated relational tables covering admin, customer, product, category, cart, transaction, bank account, proof of payment, courier, and voucher data. Functional testing results confirm that all twelve system modules operate as intended. The implementation of an e-commerce system with a CRM approach demonstrates potential to enhance customer interaction, optimize promotional activities, and improve overall business data management for small and medium-sized enterprises (SMEs).
References
Afifah, V., & Setyantoro, D. (2021). Rancangan Sistem Pemilihan dan Penetapan Harga dalam Proses Pengadaan Barang dan Jasa Logistik Berbasis Web. Jurnal IKRA-ITH INFORMATIKA, 5(2), 108–117.
Br Purba, Y. D., & Harahap, A. M. (2024). Customer relationship management strategy in mobile-based e-commerce platform development to increase purchase interest. Journal of Computer Networks, Architecture and High Performance Computing, 6(3), 1356–1367. https://doi.org/10.47709/cnahpc.v6i3.4365
Firmansyah, M. D., & Herman, H. (2023). Perancangan web e-commerce berbasis website pada Toko Ida Shoes. Journal of Information System and Technology, 4(1), 361–372. https://doi.org/10.37253/joint.v4i1.6330
Firmansyah, S. F. W., & H. (2021). Pengaruh Customer Relationship Management (CRM) Terhadap Kepuasan Pelanggan Produk Sepatu Converse. Jurnal Bisnis Dan Pemasaran, 11(1), 11.
Hasibuan, N. F., Putri, R. A., & Harahap, A. M. (2024). E-commerce application with web engineering method website based. Journal of Computer Networks, Architecture and High Performance Computing, 6(1), 179–190. https://doi.org/10.47709/cnahpc.v6i1.3353
Hikmatillah, V. (2022). E-CRM berbasis web pada sistem informasi penjualan toko kue. JATISI (Jurnal Teknik Informatika dan Sistem Informasi), 9(4), 3108–3118. https://doi.org/10.35957/jatisi.v9i4.2365
Jam'an. (2021). Customer relationship management (CRM) dalam dunia digital melalui sistem e-commerce. Jurnal Kelola: Jurnal Ilmu Sosial, 4(2), 15–23. https://doi.org/10.54783/jk.v4i2.488
Jayadi, E., Mulyawan, B., & Lauro, M. D. (2021). Implementasi Metode Collaborative Filtering Untuk Analisis Data Belanja Konsumen Berbasis Website. Jurnal Ilmu Komputer Dan Sistem Informasi, 9(1), 57. https://doi.org/10.24912/jiksi.v9i1.11559
Khair, A., Rosalina, V., & S, S. (2021). Rancang bangun sistem informasi e-commerce dengan penerapan customer relationship management berbasis web. PROSISKO: Jurnal Pengembangan Riset dan Observasi Sistem Komputer, 8(2), 60–85. https://doi.org/10.30656/prosisko.v8i2.3856
Laksana Agung, M. W., Akbar, A., Cahyadi, S., Riyanto, A., & Mukhlis, H. (2022). Pembuatan Aplikasi Pendampingan Dan Mentoring Bisnis UMKM (Studi Kasus: PLUT KUMKM Kabupaten Subang). Jurnal Ilmiah Indonesia, 7(5), 6892–6897.
Maulidina, C. M., & Nafiati, L. (2024). Penerapan sistem informasi akuntansi, digital marketing dan e-commerce untuk meningkatkan literasi digitalisasi dan kinerja UMKM. Jurnal Pembelajaran dan Pemberdayaan Masyarakat, 5(1), 187–199. https://doi.org/10.33474/jp2m.v5i1.21506
Novitasari, Y. S., Adrian, Q. J., & Kurnia, W. (2021). Rancang Bangun Sistem Informasi Media Pembelajaran Berbasis Website. Jurnal Teknologi Dan Sistem Informasi (JTSI), 2(3), 136–147.
Ramadhani, D. P., Syafwan, H., & Latiffani, C. (2022). Penerapan metode E-CRM pada Toko Wati Collection. JATISI (Jurnal Teknik Informatika dan Sistem Informasi), 9(4), 3503–3518. https://doi.org/10.35957/jatisi.v9i4.2839
Sartika, S., & Murdana, I. M. (2023). Customer relationship management. Yayasan Kita Menulis.
Siahaan, N. S., Siregar, I. K., & Latiffani, C. (2023). Implementasi E-CRM untuk meningkatkan penjualan obat-obatan dan pupuk di UD. Menara Tani Kecamatan Simpang Empat. Jurnal Teknik Informatika dan Sistem Informasi, 10(1), 241–251.
Sulastari, N., et al. (2021). Rekayasa Perangkat Lunak Berbasis Waterfall Model pada Pengembangan Sistem Informasi E-Commerce. Jurnal Informatika dan Rekayasa Elektronik, 4(2), 78–86.
Supandi, I., Yusuf, F., & F, F. (2018). Implementasi customer relationship management (CRM) pada sistem informasi penjualan ban di Toko Lingga Ban berbasis web. Nuansa Informatika, 12(1), 20–28.
Suradi. (2022). Sistem Manajemen Basis Data Relasional untuk Aplikasi E-Commerce. Jurnal Teknologi Informasi dan Komunikasi, 10(1), 23–31.
Syahnita, S., Nofriadi, N., & Sudarmin, S. (2022). Rancang bangun customer relationship management (CRM) dalam penjualan berbasis e-commerce. Building of Informatics, Technology and Science (BITS), 4(1), 18–27.
Syarif, M., & Nugraha, W. (2020). Pemodelan diagram UML sistem pembayaran tunai pada transaksi e-commerce. Jurnal Teknik Informatika Kaputama, 4(1), 70. http://jurnal.kaputama.ac.id/index.php/JTIK/article/view/240
Tarigan, J., Gultom, M., & Willay, T. (2024). Perancangan sistem informasi manajemen penjualan produk berbasis web pada PT Harapan Tani Permai. Jurnal Teknologi Sistem Informasi, 5(3). https://doi.org/10.35957/jtsi
Widyana, R., et al. (2021). Implementasi Customer Relationship Management (CRM) pada Sistem E-Commerce untuk Meningkatkan Loyalitas Pelanggan. Jurnal Sistem Informasi Bisnis, 11(2), 45–52.
Williandi, R., Sharipuddin, & Feranika, A. (2023). Perancangan aplikasi e-commerce penjualan peralatan pancing pada Toko Handoyo berbasis web. Jurnal Manajemen Teknologi dan Sistem Informasi (JMS), 3(1). https://doi.org/10.33998/jms.2023.3.1.799
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Aisyah Mutia Dawis, Agus Saepulloh, Fanny Septiani Bufra, Rika Yolanda Putri, Nabila Zahra

This work is licensed under a Creative Commons Attribution 4.0 International License.

