Design and Construction of a Web-Based Sales Information System (Case study of a simple coffee shop business)

Authors

  • Mila Ariati Informatics Engineering Study Program, Faculty of Engineering, Pahlawan Tuanku Tambusai University, Indonesia
  • Hidayati Rusnedy Informatics Engineering Study Program, Faculty of Engineering, Pahlawan Tuanku Tambusai University, Indonesia
  • Joko Musridho Informatics Engineering Study Program, Faculty of Engineering, Pahlawan Tuanku Tambusai University, Indonesia

Keywords:

Information System, Sales, Web, Laravel, FAST

Abstract

Sales transactions at Kedai Kopi Sederhana are still carried out manually through handwritten order records, cash payments, and daily sales reports without digital support. This manual process leads to several issues, including recording errors, inaccurate orders, data loss risks, and delays in generating sales reports. This study aims to design and develop a web-based sales information system to improve operational efficiency and data accuracy. The FAST (Framework for the Application of Systems Thinking) method was used, consisting of scope definition, problem analysis, requirements analysis, logical and physical design, system construction, and testing. The system was developed using PHP with the Laravel framework and MySQL database. The results show that the system successfully automates ordering, payment validation, menu management, and real-time sales reporting. Black Box testing indicates that all features function properly according to user requirements. Therefore, the system enhances business efficiency, reduces recording errors, and enables the business owner to monitor sales performance more effectively.

References

Abdillah, R. (2021). UML Modeling for Party Equipment Rental Information Systems. Jurnal Fasilkom, 11(2), 79–86. https://doi.org/10.37859/jf.v11i2.2673

Aldo, D., Habibie, DR, & Susie, S. (2021). The FAST Method for Inventory System Development. INOVTEK Polbeng - Informatics Series, 6(2), 211. https://doi.org/10.35314/isi.v6i2.2080

Ardhana, VYP (2024). Designing a Coffee Shop Information System Using the Rapid Application Development (RAD) Method. JDMIS: Journal of Data Mining and Information Systems, 2(1), 43–49. https://doi.org/10.54259/jdmis.v2i1.2422

Halim, RMN (2020). Sales Information System at TB Harmonis Using the FAST Method. Sisfokom Journal (Information and Computer Systems), 9(2), 203–207. https://doi.org/10.32736/sisfokom.v9i2.868

Hermiati, R., Asnawati, A., & Kanedi, I. (2021). Creating an E-Commerce Platform on Raja Komputer Using the PHP Programming Language and MySQL Database. Jurnal Media Infotama, 17(1), 54–66. https://doi.org/10.37676/jmi.v17i1.1317

Hidayat, A., Rosdiana, A., Raditya, FY, & ... (2022). Coffee Sales Information System Design (Case Study: Saya Kopinuansa). … And Business (JIKB), XIII(2). https://www.stmikdharmapalariau.ac.id/ojs/index.php/jikb/article/view/374%0Ahttps://www.stmikdharmapalariau.ac.id/ojs/index.php/jikb/article/view/374/255

Ilmi, FA, Sasmoko, D., Suasana, IS, Sulartopo, & Adi Putra, TW (2024). Saturnus: Journal of Technology and Information Systems. Saturnus, 2(3), 95–105. https://doi.org/10.61132/saturnus.v2i3.186

Irfan, M., Siregar, H., & Handoko, JT (2023). Development and Integration of PC Production Failure Prediction Application Using Triple Exponential Smoothing Method in Production Application System at PT Tera Data Indonusa, Tbk. Proceedings of Darmajaya National Seminar, 1(November 2015), 80–96.

Jhonny, ZA and Hadiwinata, SN (2024). Design and Construction of a Coffee Sales Management Information System at a Konamu Coffee Shop Using a Point of Sale System. IKRA-ITH Informatika: Journal of Computers and Informatics, 8(2), 1–10. https://doi.org/10.37817/ikraith-informatika.v8i2.2951

Mahdalena, D., Sari, VN, Qurniati, N., & Prahasti, P. (2023). Designing a Sales Information System at the Luwak Coffee Shop in Bengkulu Using the PHP Programming Language and MySQL Database. Digital Transformation Technology, 3(2), 609–617. https://doi.org/10.47709/digitech.v3i2.3094

Maulani, MR, & Santoso. (2021). Design and Construction of a Web-Based Computer Based Test Application at Smpn 1 Katapang, South Bandung Regency. Journal of Informatics Engineering, 13(2), 17–22.

Novianti, A., & Sari, RP (2022). Designing a Material Warehouse System Using the FAST Method at PT. Samcon. Journal of Technology and Information, 12(1), 93–105.https://doi.org/10.34010/jati.v12i1.6574

Nugroho, MRA, Zaidiah, A., & Afrizal, S. (2021). Designing a Sales Information System at Pujangga Coffee Shop Using the Web-Based Waterfall Method. Senamika, September, 371–382. https://conference.upnvj.ac.id/index.php/senamika/article/view/1570%0Ahttps://conference.upnvj.ac.id/index.php/senamika/article/download/1570/1360

Nurrahman, AA (2019). Design of a Finished Goods Warehouse Information System at PT Remaja Rosdakarya. ETHOS (Journal of Research and Community Service), 7(1), 143–150.https://doi.org/10.29313/ethos.v7i1.4284

Rahmi, E.R., Yumami, E., & Hidayasari, N. (2023). Analysis of Website-Based Information System Development Methods: Systematic Literature Review. Remik, 7(1), 821–834. https://doi.org/10.33395/remik.v7i1.12177

Ramdany, S. (2024). Application of UML Class Diagrams in Designing Web-Based Library Information Systems. Journal of Industrial and Engineering System, 5(1). https://doi.org/10.31599/2e9afp31

Septarina, L., Hakim, L., Marshella Febriani, O., & Azim, F. (2023). Website Creation Training for Marketing MSME Products in Ceringin Asri Village. NEAR: Journal of Community Service, 2(2), 150–153.https://doi.org/10.32877/nr.v2i2.747

Setyabudhi, AL, Syofiawan, D., & Sulityo, EA (2021). Designing a Personnel Information System Using the Fast Method at Hang Nadim Airport Business Entity, Batam. Engineering And Technology International Journal, 3(2), 110–124.https://doi.org/10.55642/eatij.v3i02

Shadiq, J., Safei, A., & Loly, RWR (2021). Testing an Office Operational Vehicle Lending Application Using Black Box Testing. Information Management For Educators And Professionals: Journal of Information Management, 5(2), 97.https://doi.org/10.51211/imbi.v5i2.1561

Simatupang, J., & Sianturi, S. (2019). Design of an Ordering Information System. Intra-Tech Journal, 3(2).

Sinaga, GRU, & Samsudin, S. (2021). Implementation of the Laravel Framework in the Reservation System at the Cindelaras Restaurant in Medan City. Janitra Journal of Informatics and Information Systems, 1(2), 73–84. https://doi.org/10.25008/janitra.v1i2.131

Downloads

Published

2026-03-10

How to Cite

Ariati, M., Rusnedy, H., & Musridho, J. (2026). Design and Construction of a Web-Based Sales Information System (Case study of a simple coffee shop business). Journal of Engineering Science and Technology Management (JES-TM), 6(1), 101–112. Retrieved from https://jes-tm.org/index.php/jestm/article/view/360

Issue

Section

Articles

Most read articles by the same author(s)