Designing A Website-Based Transaction and Inventory Information System for Workshops (Case Study Sialogo Motor Workshop)

  • Suhandri S. (Corresponding Author) Universitas Sam Ratulangi
  • Benny Pinontoan
  • Wisard Kalengkongan
Keywords: Information Systems, Transactions, Workshop Inventory, Black Box Testing, Usability Testing

Abstract

Sialogo Motor Workshop is an automotive business whose day-to-day operations require the regular management of transaction data and stock records. Until now, the recording of data on goods, stock, sales transactions, service transactions and reports has been carried out manually, which has often led to recording errors, slow data retrieval, difficulties in monitoring stock levels, and inaccurate reports. The aim of this research is to design and develop a web-based Workshop Transaction and Inventory Information System for Sialogo Motor Workshop, in order to manage data on items, categories, incoming stock, outgoing stock, service transactions, sales transactions and reports in a more structured manner. The system was developed using the Waterfall methodology, employing the programming languages PHP, HTML and JavaScript, the CodeIgniter framework, Bootstrap and a MySQL database. System testing was carried out using two methods namely Black Box Testing and usability testing. The results of the Black Box Testing carried out on 37 scenarios showed that all the functions tested operated as expected. Meanwhile, the results of the usability testing carried out on the owner of Sialogo Motor Workshop as a system user showed a usability rating of 90 %, which falls into the ‘very good’ category. The results of this study indicate that the system is suitable for use, easy to operate, and can help Sialogo Motor Workshop to manage its transactions and stock more efficiently and accurately.

Downloads

Download data is not yet available.

References

R. S. Ramadhan, A. Voutama, and Hannie, “Rancang Bangun Sistem Informasi Penjualan Hybrid Berbasis Website (Studi Kasus: Toko Rizki Plastik),” JATI (Jurnal Mhs. Tek. Inform., vol. 8, no. 5, p. 55, 2023.

Hendri, Intan Permata, and Fachruddin, “Perancangan Sistem Informasi Penjualan Dan Jasa Perbaikan Mobil Pada Bengkel Alam Jaya,” J. Process., vol. 15, no. 1, pp. 30–42, 2020, doi: 10.33998/processor.2020.15.1.708.

F. Yunita and B. Rianto, “Sistem Informasi Bengkel Berbasis Web Studi,” Selodang Mayang J. Ilm. Badan Perenc. Pembang. Drh. Kabupaten Indragiri Hilir, vol. 8, no. 2, pp. 154–165, 2022.

S. Rusmawanti, W. Witanti, P. N. Sabrina, F. Sains, U. Jenderal, and A. Yani, “Sistem Informasi Manajemen Aset pada PT . Gamma Solusi Karya Nusantara,” pp. 25–29, 2020.

A. Wulandari, S. M. Sagita, and N. Dwitiyanti, “Perancangan Sistem Informasi Pelayanan Jasa pada Bengkel Las Listrik Mitra Baja Abadi,” J. Ris. dan Apl. Mhs. Inform., vol. 2, no. 03, pp. 389–396, 2021, doi: 10.30998/jrami.v2i03.1254.

I. Jaya, A. Pradipta, and M. H. Akbar, “Sistem Informasi Penjualan Sparepart Berbasis Web sebagai Solusi Digitalisasi di Bengkel Ajeng Ratu Motor,” vol. 1, no. 2, pp. 57–66, 2024.

B. Rohmah et al., “Perancangan Ssitem Informasi Servis Motor Pada Bengkel Arif Motor,” vol. 02, no. 01, pp. 68–75, 2021.

S. W. C. Ngangi, C. A. Jeffta Soewoeh, E. Alfonsius, D. Lapihu, and I. G. N. Aditya Putra, “Sistem Informasi Penjualan Sparepart Motor Berbasis Website (Studi Kasus Pada Bengkel Motorindo),” J. Inf. Technol. Softw. Eng. Comput. Sci., vol. 1, no. 2, pp. 75–83, Apr. 2023, doi: 10.58602/itsecs.v1i2.33.

R. Adiyanti, P. T. Sulaksana, Y. Syahidin, and M. Hidayati, “Perancangan Sistem Informasi Indeks Penyakit Rawat Inap Menggunakan Microsoft Visual Studio,” J. Teknol. dan Manaj. Inform., vol. 7, no. 1, pp. 10–19, 2021, doi: 10.26905/jtmi.v7i1.5977.

F. Sundawa, “Rancang Bangun Sistem Informasi Berbasis Web Pada Bengkel Try Motor Racing Menggunakan Metode Waterfall. Jurnal Informatika Dan Komputasi: Media Bahasan, Analisa Dan Aplikasi, 16(02), 64–73. https://doi.org/10.56956/jiki.v16i02.11,” J. Inform. dan Komputasi Media Bahasan, Anal. dan Apl., vol. 16, no. 02, pp. 64–73, 2022.

D. Madiania, I. A. Lubis, and A. T. A. A. Siahaan, “Pendaftaran Wasit Berbasis Website Menggunakan PHP Dan MYSQL Pada Kantor Dinas Pemuda Dan Olahraga Kota Medan,” JATI (Jurnal Mhs. Tek. Inform., vol. 8, no. 3, pp. 3216–3224, 2024.

S. Nurmiati and G. Al Hafidz, “Perancangan Sistem Pendaftaran Bengkel Untuk Pelayanan Home Service Berbasis Website,” J. Sist. Inf. Bisnis, vol. 2, no. 2, pp. 59–81, 2021, doi: 10.55122/junsibi.v2i2.307.

Hasanah, F. N. Untari, and R. Sri, Rekayasa Perangkat Ajar Lunak. 2020.

N. Raihan and A. Eviyanti, “PERANCANGAN SISTEM INFORMASI PENYEWAAN MOBIL BERBASIS WEB MENGGUNAKAN,” vol. 4, no. 1, pp. 31–41, 2022.

L. Kelen, “Implementasi Model-View-Controller (Mvc) Pada Ujian Online Melalui Penerapan Framework Codeigniter,” J. Pendidik. Teknol. Inf., vol. 1, no. 1, pp. 10–16, 2018, doi: 10.37792/jukanti.v1i1.5.

A. C. Praniffa, A. Syahri, F. Sandes, U. Fariha, and Q. A. Giansyah, “Pengujian Black Box dan White Box Sistem Informasi Parkir Berbasis Web,” J. Test. dan Implementasi Sist. Inf., vol. 1, no. 1, pp. 1–16, 2023.

M. T. Abdillah, I. Kurniastuti, F. A. Susanto, and F. Yudianto, “Implementasi Black Box Testing dan Usability Testing pada Website Sekolah MI Miftahul Ulum Warugunung Surabaya,” J. Comput. Sci. Vis. Commun. Des., vol. 8, no. 1, pp. 234–242, 2023, doi: 10.55732/jikdiskomvis.v8i1.897.

Published
2026-12-18
How to Cite
S., S., Benny Pinontoan, & Wisard Kalengkongan. (2026). Designing A Website-Based Transaction and Inventory Information System for Workshops (Case Study Sialogo Motor Workshop). Journal of Artificial Intelligence and Technology Information (JAITI), 4(4), 617-629. https://doi.org/10.58602/jaiti.v4i4.415