Perancangan Sistem Informasi E-Commerce Berbasis Web pada UMKM Stretto Pizza

Theresia Rosyelani Nena; Ferdinandus Lidang Witi; Elvira Esperanza Sala

doi:10.61132/merkurius.v4i2.1581

Authors

Theresia Rosyelani Nena Universitas Flores
Ferdinandus Lidang Witi Universitas Flores
Elvira Esperanza Sala Universitas Flores

DOI:

https://doi.org/10.61132/merkurius.v4i2.1581

Keywords:

E-Commerce, Information System, MSMEs, Waterfall Method, Website

Abstract

Advances in information technology have brought significant changes to how Micro, Small, and Medium Enterprises (MSMEs) conduct their business operations, particularly in the areas of marketing and sales. However, Stretto Pizza MSME still relies on manual processes for ordering and transaction recording, which results in limited marketing reach, suboptimal data management, and an increased risk of errors in recording. This study aims to develop a web-based e-commerce information system that can integrate sales processes and data management more effectively. System development was conducted using the Waterfall method, which includes the stages of requirements analysis, design, implementation, testing, and maintenance. The system was built using the PHP programming language with MySQL database support. System testing was performed using the Black-Box Testing method to ensure that every feature functions according to user needs. The research results show that the designed system is capable of supporting product ordering processes, customer data management, sales transactions, and report generation more efficiently. With this system, it is hoped that the Stretto Piza SME can improve its operations while expanding its marketing reach through the use of digital technology.

References

Angellin, K., Oetama, R., & Amri, M. (2023). Web-based inventory and sales information system: Indonesian micro small medium enterprise case study. Journal of Information System, 8(1), 57–66.

APJII. (2024). Asosiasi Penyelenggara Jasa Internet Indonesia, “Jumlah Pengguna Internet Indonesia tembus 221 juta orang.” 7 February.

Ardiansyah, T., & Belakang, A. L. (2020). MODEL PLATFORM e-COMMERCE DALAM MENDUKUNG. 1(1), 1–12.

Azhar, A. A., Hadiwijoyo, S. S., & Nau, N. U. W. (2023). MELALUI PENGELOLAAN FOOD LOSS AND WASTE DI INDONESIA Contact : 2(4), 56–75.

Caswito, A., Sayidah, N., & Adi, S. U. (2024). Faktor Penggunaan E-Commerce Terhadap Pengambilan Keputusan melalui Perilaku Konsumen ( Kajian Studi Literatur Review ). 13, 1–8.

Christian, Y., Wibowo, T., & Winata, P. A. (2023). Perancangan Sistem E-Commerce Berbasis Web dengan Metode System Development Life Cycle untuk Usaha Mikro Kecil dan Menengah Pakaian di Kota Batam. 4(3), 1271–1281. https://doi.org/10.30865/klik.v4i3.1408

Edison, E. D., Putri, N. E., Juwita, A., & Darmawan, M. E. (2026). Development of a web-based point of sales system as a financial digitalization solution for MSMEs. Asian Journal of Applied Research for Community Development and Empowerment, 10(1), 78–83.

Elim, Y. V., Nugraha, M., Umar, Z., & Modena, A. R. (2024). Dampak Digital Marketing Terhadap Kinerja UMKM Di Kota Kupang Pada Masa Pandemi Covid-19. 17(1), 97–110.

Harjono, W., & Tute, K. J. (2022). Perancangan Sistem Informasi Perpustakaan Berbasis Web Menggunakkan Metode Waterfall. 2(1), 47–51. https://doi.org/10.54259/satesi.v2i1.773

Info, A. (2023). Perancangan sistem informasi manajemen pada balai diklat keagamaan medan. 2(1), 11–18.

Mafirah, D., Hary, A., Annisa, L., & Informasi, T. (2026). Evaluasi Strategi Pemodelan Basis Data melalui Entity Relationship Diagram ( ERD ) dalam Perspektif Akademik dan Praktik Industri : Literature Review. 10, 3935–3943.

Nugroho, F. E. (2016). Perancangan Sistem Informasi Penjualan Online Studi Kasus Tokoku. 7(2), 717–724.

Nurjanah, Y. S., Wibisono, T., & Sari, A. N. I. (2026). Sales data management effectiveness through a web-based information system in culinary MSMEs. Brilliance: Journal of Applied Science, 6(1), n.p.

Peluang, D., Kadja, A., Zega, Y. K., Komputer, T., & Kupang, P. N. (2026). Jurnal Ilmiah Multidisiplin Tinjauan Literatur Sistem Informasi Pelayanan Publik Berbasis Website. 3(1), 1–14. https://doi.org/10.62282/juilmu.v3i1.1-14

Putriyani, I., Sugiharto, B. B., & Ramadhan, F. (2024). Analisis Literatur Tentang Peran Sistem Informasi Akademik dalam Meningkatkan Efisiensi Administrasi di Institusi Perguruan Tinggi. 4(1), 2283–2289.

Selay, A., Andgha, G. D., Alfarizi, M. A., Bintang, M. I., Falah, M. N., Encep, M., & Khaira, M. (2023). SISTEM INFORMASI PENJUALAN. 2, 232–237.

Shofi Ayudiana. (2024). Keenko-UKM: 25,5 juta UMKM telah go digital. Jakarta.

Sripanji, D., Ujianto, N. T., Sripanji, D., & Pemalang, K. (2025). Analisis Portal Layanan Berbasis Website Untuk Organisasi Pemerintah Daerah Bagian Kesejahteraan Rakyat Kabupaten Pemalang. 3(7), 5492–5501.

Trulline, P. (2021). Pemasaran produk UMKM melalui media sosial dan e-commerce Marketing of MSME products through social media and e-commerce. 5(2), 259–279.

Zakirasli, A., Setiawan, C. N., Nathanael, C., & Rizal, F. (2024). Pengaruh E-Commerce Terhadap Minat Masyarakat Dalam Berwirausaha. 4, 1–10.