E-CRM MYSAFFANA FOR OPTIMIZING CUSTOMER AND TRANSACTION DATA AT SAFFANA BOUTIQUE

Nurul Masytha Siagian; Maulana Dwi Sena; Febby Madonna Yuma

doi:10.33330/jurteksi.v12i2.4435

Nurul Masytha Siagian Universitas Royal
Maulana Dwi Sena Universitas Royal
Febby Madonna Yuma Universitas Royal

DOI: https://doi.org/10.33330/jurteksi.v12i2.4435

Keywords: boutique, customer data management, customer profiling, E-CRM

Abstract

Abstract: The development of information technology encourages retail businesses to manage customer and transaction data more effectively. However, many small-scale retailers still rely on manual record-keeping, resulting in unintegrated data and limited decision-making support. This study aims to design and implement a web-based Electronic Customer Relationship Management (E-CRM) system called MySaffana for Saffana Gallery Boutique to optimize customer and transaction data management. The research method includes requirement analysis, system design using UML, implementation using PHP and MySQL, and system testing using black box testing. The results show that the MySaffana system is able to manage customer data, products, transactions, and sales reports in an integrated and efficient manner. System testing indicates that all main features function properly and meet user requirements. Therefore, the developed E-CRM system provides an effective and practical solution for strengthening data-driven decision-making in small-scale retail businesses.

Keywords: boutique; customer data management; customer profiling; E-CRM.

Abstrak: Perkembangan teknologi informasi mendorong usaha ritel untuk mengelola data pelanggan dan transaksi secara lebih efektif. Namun, banyak usaha ritel skala kecil masih melakukan pencatatan secara manual sehingga data tidak terintegrasi dan kurang optimal dalam mendukung keputusan. Penelitian ini bertujuan untuk merancang dan mengimplementasikan sistem Electronic Customer Relationship Management (E-CRM) berbasis web bernama MySaffana pada Butik Saffana Gallery yang dapat mengoptimalkan pengelolaan data pelanggan dan transaksi. Metode penelitian meliputi analisis kebutuhan, perancangan sistem menggunakan UML, implementasi dengan PHP dan MySQL, serta pengujian menggunakan metode black box testing. Hasil penelitian menunjukkan bahwa sistem MySaffana mampu mengelola data pelanggan, produk, transaksi, dan laporan penjualan secara terintegrasi dan efisien. Pengujian sistem membuktikan seluruh fitur berjalan sesuai fungsi dan kebutuhan pengguna. Dengan demikian, sistem E-CRM berbasis web ini dapat menjadi solusi yang efektif dalam mendukung pengelolaan data dan pengambilan keputusan berbasis data bagi usaha ritel skala kecil.

Kata kunci: butik; E-CRM; profil pelanggan; pengelolaan data pelanggan.

References

M. Chaidir and D. Irawan, “Strategi Pemasaran Digital: Memahami Perjalanan Konsumen Di Era Digital,” CITIZEN: Jurnal Ilmiah Multidisiplin Indonesia, vol. 4, no. 4, 2024, doi: 10.53866/jimi.v4i4.650.

J. Manajemen and S. Ekonomi, “Strategi e-CRM Untuk Meningkatkan Kepuasan Konsumen : Sebuah Literatur Review,” 2022. [Online]. Available: http://journal.stiestekom.ac.id/index.php/dinamikapage64

R. Alshurideh, M. Al-Dmour, and B. Masa’deh, “The role of digital customer relationship management in enhancing customer engagement and loyalty,” IInternational Journal of Data and Network Science, vol. 6, no. 4, pp. 1231–1242, 2022.

J. Nicolas, N. Sri, and E. Adriana, “Peran e-CRM dalam Bisnis di Era Digital,” vol. 4, pp. 78–90, 2024.

M. A. Al-Dmour, R. Alshurideh, and B. Masa’deh, “The impact of electronic customer relationship management on customer retention: The mediating role of customer satisfaction,” IInternational Journal of Data and Network Science, vol. 6, no. 3, pp. 843–856, 2022.

A. K. S. Alshurideh, B. Kurdi, and M. Alhamad, “The role of information systems in enhancing organizational performance: A systematic review,” IInternational Journal of Information Management Data Insights, vol. 3, no. 1, pp. 1–12, 2023.

S. Gupta and R. Misra, “Information systems integration and organizational efficiency: A contemporary review,” Journal of Enterprise Information Management, vol. 36, no. 2, pp. 455–472, 2023.

L. I. A. Irma Hartiwi And H. Rokhayati, “Analisis Kualitas Sistem, Kualitas Informasi Dan Kualitas Layanan Terhadap Kepuasan Pengguna Pada Sistem Aplikasi Keuangan Tingkat Instansi Satuan Kerja,” Jurnal Manajemen, vol. 20, no. 1, Jan. 2024, doi: 10.25170/jm.v20i1.4457.

H. Alzoubi and R. Yanamandra, “Data quality and decision-making effectiveness in digital business environments,” International Journal of Information Management Data Insights, vol. 2, no. 2, pp. 100–123, 2022.

N. Made et al., “Universitas Ngurah Rai (Sunari) Menggunakan Metode Delone And Mclean,” Jurnal Ilmu Komputer Indonesia (JIK), vol. 7, no. 2, 2022.

A. Muslih, “Sistem Informasi Akuntansi Yang Berkualitas Dan Dampaknya Terhadap Kualitas Informasi Akuntansi”.

S. Alshamaila, S. Papagiannidis, and F. Li, “Information systems development and business process alignment: A contemporary review,” Journal of Enterprise Information Management, vol. 35, no. 4, pp. 1025–1043, 2022.

M. A. Hossain, M. S. Hossain, and R. Ahmed, “Applied research in information systems: Bridging theory and practical implementation,” IInternational Journal of Information Management Data Insights, vol. 2, no. 2, pp. 1–10, 2022.