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.
Copyrights © 2026