Perancangan Sistem Informasi Penjualan Produk Frozen Food Menggunakan Metode Waterfall Berbasis Web dan Xammp

Iin Parlina; Mesinta Sari

doi:10.47065/jussi.v5i3.9863

Iin Parlina * STIKOM Tunas Bangsa Pematangsiantar, Sumatera Utara, Indonesia
Mesinta Sari STIKOM Tunas Bangsa, Pematangsiantar, Sumatera Utara, Indonesia

(*) Corresponding Author

DOI: https://doi.org/10.47065/jussi.v5i3.9863

Keywords: Information System; Sale; Frozen Food; Website; Visual Studio Code

Abstract

This research was conducted to identify and analyze the problems occurring in UMKM regarding the processing of stock transactions, specifically in the business sector of frozen food products, which is still managed manually. This indicates that information technology optimization has not been thoroughly implemented by business actors in this field. Conventional recording processes frequently lead to errors in record-keeping, delays in report generation, and limitations in conveying product information to customers. Furthermore, the manual system poses challenges for business owners in monitoring stock in real-time, thereby hindering fast and accurate decision-making. Developing an information system for Frozen Food UMKM can help overcome these issues in processing frozen food product sales data, making it easier and more effective for system users to process or manage sales transactions. The research method used to build this information system is the Waterfall method, while data collection was carried out through direct observation by observing manual transaction processes directly and interview methods to obtain supporting information for this study. The result of this research is a system designed to provide convenience for UMKM the Frozen Food Product Sales Information System is implemented to process data effectively and efficiently. This system was designed using the PHP programming language with a MySQL database for database management, utilizing XAMPP for the MySQL database, and implemented using Visual Studio Code for the system interface. The research findings demonstrate that the developed system is capable of managing product data, sales transactions, and reports in a structured and integrated manner. The system also features data search functionalities, automated stock management, and faster, more accurate report generation. Consequently, the designed system can enhance operational efficiency and assist business operators in optimizing their business processes. Future research can achieve quality improvement and broader service coverage by developing a more complex system, integrating electronic payment functions, and system-based automatic notifications, alongside enhancing system security through routine software audits to achieve more efficient and beneficial performance.

References

A. A. S. M. Styaningrum, E.Setyawati, “Sistem Informasi Penjualan Berbasis Website Menggunakan Framework Codeigniter ( Studi Kasus : Msglow Banyumas ),” JOTIKA J. Manag. Anterpreneursh., vol. 4, no. 2, pp. 99–112, 2025, doi: https://doi.org/10.56445/jme.v4i2.177.

A. Wahyu, “Sistem Informasi Penjualan Berbasis Web untuk Toko Ritel,” Indones. J. Appl. Tecnol., vol. 1, no. 2, pp. 1–13, 2024, doi: https://doi.org/ 10.47134/ijat.v1i2.2485.

M. Y. L. Azzahra, “Metode K-Means Clustering Dalam Pengelompokan Penjualan Produk Frozen Food,” JIRSI, vol. 3, no. 1, pp. 1–10, 2024, doi: https://doi.org/10.70340/jirsi.v3i1.88.

H. Marfalino, “Perancangan Sistem Informasi Persediaan Stok Barang Dan Penjualan Padatoko Raja Sosis Menggunakan Bahasa Pemrograman PHP Dan Database MYSQL,” JTECH, vol. 2, no. 3, pp. 179–196, 2023, doi: https://rcf-indonesia.org/jurnal/index/.php/jtech.

N. W. K. E. Aldison Putra, “Sistem Informasi Penjualan Produk Frozen Food TR UMKM Berbasis WEB,” Melek IT, vol. 10, no. 2, pp. 193–204, 2024, doi: https://doi.org/10.30742/melekitjournal.v10i2.354.

D. S. C. Saputra, Hansen, “Perancangan Sistem Informasi Pembelian Dan Penjualan Berbasis Web Pada Toko Sumber Jaya Jurnal Manajemen Teknologi dan Sistem Informasi ( JMS ),” JMSJurnal Manaj. Teknol. dan Sist. Inf., vol. 4, no. September, pp. 723–731, 2024, doi: https://doi.org/10.33998/jms.v4i2.

M. D. Maria, P.Alam Jusia, “Perancangan Sistem Informasi Transaksi Pembelian Penjualan Jurnal Manajemen Teknologi dan Sistem Informasi ( JMS ),” JMSJurnal Manaj. Teknol. dan Sist. Inf., vol. 4, no. September, pp. 743–753, 2024, doi: https://doi.org/10.33998/jms.v4i2.

A. V. C. Christian, “Rancang Bangun Sistem Informasi Inventaris Berbasis Website,” JITET J. Inform. dan Tek. Elektro Terap., vol. 12, no. 2, pp. 1500–1509, 2024, doi: http://dx.doi.org/10.23960/jitet.v12i2.4259.

S. R. S. Binashirillah, T.Aulia, “Sistem Informasi Penjualan Pada Toko Buku Jendela Dunia Berbasis Web,” J. Penelit. Sist. Inf., vol. 1, no. 3, pp. 142–153, 2023, doi: https://doi.org/10.54066/jpsi.v1i3.675.

C. R. M Zein, “Perancangan Sistem Informasi Desa Tomuan Holbung Menggunakan Metode Waterfall,” JURIKOM (Jurnal Ris. Komputer), vol. 9, no. 2, pp. 274–280, 2022, doi: 10.30865/jurikom.v9i2.3986.

S.Sintaro, “Permodelan Sistem Informasi Pembelian dan Penjualan Berbasis Website,” JIMA-ILKOM J. Ilm. Inform. DAn ILMU Komput., vol. 1, no. 1, pp. 25–32, 2022, doi: DOI: https://doi.org/10.58602/jima-ilkom.v1i1.5.

Y. Mayanti, “Sistem Informasi Akuntasi pada Penjualan Online Frozen Food di Bandung ( Studi Kasus Penjualan Online Frozen Food Nepikabeku ),” Portofolio J. Ekon. Bisnis, Manajmen dan Akunt., vol. 18, no. 2, pp. 160–177, 2021, doi: https://doi.org/10.26874/portofolio.v18i2.215.

C. Nabilla, “Sistem Informasi POINT of SALE Berbasis Webpada Penjualan Frozen Food Dan Bahan Plastik,” J. Sist. Inf. Bisnis, vol. 6, no. 2, pp. 292–304, 2025, doi: https://doi.org/10.55122/junsibi.v6i2.1732.

D. M. S. Sanjaya, J.Agung, “Perancangan Sistem Informasi Stok Barang Berbasis Web Jurnal Manajemen Teknologi dan Sistem Informasi ( JMS ),” JMS J. Manaj. Teknol. dan Sist. Inf., vol. 1, no. April, pp. 120–129, 2022, doi: https://doi.org/10.47080/iftech.v5i2.2721.

N. Sutisna, “Implementasi Sistem Informasi dalam Mendukung Perilaku Pembelian Terhadap Keputusan Pembelian,” MENTARI Manaj. Pendidik. dan Teknol. Inf., vol. 2, no. 1, pp. 20–30, 2023.

A. F. M. Faitullah Akbar, “Application of Waterfall Method In Design Of Web-Based Library Information System Program Case Study at Elementary School Warungnangka Kabupaten Subang,” JTISJurnal Teknol. dan Open Source, vol. 6, no. 1, pp. 72–85, 2023, doi: 10.36378/jtos.v6i1.3065.

L. Made Wisnu Satyaningrat, “Perancangan Sistem Pergudangan Usaha Mikro Kecil ( UMK ) melalui Pemodelan Data Flow Diagram ( DFD ) dan Analisis MoSCoW,” Decod. Pendidik. Teknol. Inf., vol. 5, no. 3, pp. 873–887, 2025, doi: http://dx.doi.org/10.51454/decode.v5i3.1349.

N. N. I. Purnama Sari, A. Syahputra, “Perancangan Sistem Aplikasi Penjualan dan Layanan Jasa Laundry Sepatu Berbasis Website,” J. Tek., vol. 1, pp. 32–37, 2022, doi: http://jurnal.ilmubersama.com/index.php/blendsains.

E. Rosinta, “Implementasi Customer Relationship Management ( CRM ) Pada Aplikasi Penjualan Berbasis Web PT . Buana Telekomindo,” vol. VII, no. 1, pp. 8–14, 2018.

H. Rifqa, “Pemanfaatan Basis Data untuk Mendukung Keandalan dan Akurasi Sistem Informasi Akuntansi,” Ilmu Bisnis dan Ekon. Islam, vol. 2, pp. 46–61, 2025.

M. I. B. Audya, “Redudansi Data Pada Sistem Informasi Penjualan Analysis of the Implementation of Normalization and Reducing Data Redundancy in Sales Information Systems,” J. Pendidik. Ekon. Sos. dan Budaya, vol. 4, no. 2, pp. 281–295, 2026, doi: 10.66886/aslamiah-jpesb.v4i2.307Aslamiah: Jurnal Pendidikan, Ekonomi, Sosial dan BudayaVol. 4, No. 2, Juni 2026; 281-29510.66886/aslamiah-jpesb.v4i2.307.

M. U. D. A. Budi Santoso, “Digitalisasi UMKM untuk Optimalisasi Sistem Informasi dan Integrasi Layanan Aplikasi Website Transaksi Online di Masa Pandemi,” J. Abdimas, vol. 3, no. 1, pp. 198–205, 2022, doi: http://abdidas.org/index.php/abdidas.

Bila bermanfaat silahkan share artikel ini

Berikan Komentar Anda terhadap artikel Perancangan Sistem Informasi Penjualan Produk Frozen Food Menggunakan Metode Waterfall Berbasis Web dan Xammp