Integrasi REST API Laravel-MySQL untuk Sinkronisasi Stok Toko Sembako Mbah Wiro

Daniar Galang Setya Putra; Indrawan Ady Saputro

doi:10.20961/jaht.v5i1.3341

Authors

Daniar Galang Setya Putra Program Studi S1 Informatika, STMIK Amikom Surakarta, Sukoharjo, Indonesia
Indrawan Ady Saputro Program Studi S1 Informatika, STMIK Amikom Surakarta, Sukoharjo, Indonesia

DOI:

https://doi.org/10.20961/jaht.v5i1.3341

Keywords:

laravel; mysql; rest api; stock synchronization; sales transaction

Abstract

Micro, Small, and Medium Enterprises (MSMEs) urgently require an accurate information system for stock management and sales transactions. The main problem faced by the Toko Sembako Mbah Wiro grocery store, as the case study in this research, is stock discrepancy caused by conventional ledger-based manual recording. This study aims to implement a web service-based system that integrates the Laravel framework and MySQL database utilizing a REST API architecture with stateless authentication for automated data synchronization. The system development employs the linear sequential model (Waterfall), which is tailored to the internal kinship-based governance of the store. The testing results indicate that the system is capable of synchronizing stock updates in real-time through a Database Transaction mechanism, thereby eliminating recording errors due to transaction failures. Furthermore, the REST API generates structured JSON data output that is ready for direct integration into the thermal receipt printer module. The implementation of this system has proven effective in improving the efficiency of stock management and sales transactions at Toko Sembako Mbah Wiro.

References

[1] H. Elmi, A. Ambiyar, N. Jalinus, R. Abdullah, dan F. Fadhilah, “Hubungan Ketersediaan Layanan Informasi Dan Kepuasan Pengguna Terhadap Kualitas Sistem Informasi,” J. SAINTIKOM J. Sains Manaj. Inform. Dan Komput., vol. 22, no. 1, hlm. 81, Feb 2023, doi: 10.53513/jis.v22i1.7570.

[2] Muhammad Afif Dzaky Khairullah, E. Rohaini, dan Yovi Pratama, “Perancangan Sistem Informasi Persediaan Pada Reklame Afia Berbasis Web,” J. Inform. Dan Rekayasa KomputerJAKAKOM, vol. 3, no. 2, hlm. 581–590, Sep 2023, doi: 10.33998/jakakom.2023.3.2.851.

[3] R. M. A. Harahap dan R. S. Herdinata, “Sistem Informasi Inventory Barang Berbasis Web Dengan Menggunakanmetode Waterfall Studi Kasus (Butik Lubis Collection),” J-SISKO TECH J. Teknol. Sist. Inf. Dan Sist. Komput. TGD, vol. 6, no. 2, hlm. 500, Jul 2023, doi: 10.53513/jsk.v6i2.8226.

[4] H. F. Herdiyatmoko, “Desain Sistem Backend Berbasis Rest Api Menggunakan Framework Laravel 7,” SKANIKA, vol. 5, no. 2, hlm. 136–144, Jul 2022, doi: 10.36080/skanika.v5i2.2947.

[5] K. Gowell dan Suprihadi, “Perancangan Web Service REST API Menggunakan PHP dan Framework Laravel di Tenta Tour Salatiga,” J. JTIK J. Teknol. Inf. Dan Komun., vol. 8, no. 1, hlm. 49–57, Jan 2024, doi: 10.35870/jtik.v8i1.1269.

[6] B. Baharuddin, H. Wakkang, dan B. Irianto, “Implementasi Web Service Dengan Metode Rest Api Untuk Integrasi Data Covid 19 Di Sulawesi Selatan,” J. Sintaks Log., vol. 2, no. 1, hlm. 236–241, Feb 2022, doi: 10.31850/jsilog.v2i1.1035.

[7] D. Purnama Sari dan R. Wijanarko, “Implementasi Framework Laravel pada Sistem Informasi Penyewaan Kamera (Studi Kasus di Rumah Kamera Semarang),” J. Inform. Dan Rekayasa Perangkat Lunak, vol. 2, no. 1, hlm. 32, Mar 2020, doi: 10.36499/jinrpl.v2i1.3190.

[8] U. Ma’sum, D. Rahmawati, dan S. Muryanah, “Rancang Bangun Sistem Informasi E-Gudang Pada PT.XYZ Berbasis Website Dengan Framework Laravel,” J. Ilm. Fak. Tek., vol. 3, no. 1, hlm. 51–61, Okt 2023, doi: 10.33592/jimtek.v3i1.3793.

[9] “Sistem Inventori Persediaan Produk Berbasis Web di Toko Nanik Tri Menggunakan Framework Laravel,” J. Ilm. Komputasi, vol. 24, no. 3, Sep 2025, doi: 10.32409/jikstik.24.3.3834.

[10] A. B. Saputra dan J. Kasih, “Rancang Bangun Sistem Informasi Persediaan Barang Menggunakan Framework Laravel dengan Metode Waterfall: Studi Kasus Toko Amora Computer,” DBESTI J. Digit. Bus. Technol. Innov., vol. 3, no. 1, hlm. 108–115, Mei 2026, doi: 10.54914/dbesti.v3i1.2088.

[11] A. I. Ramadhan dan P. A. R. Devi, “Implementasi Sistem Manajemen Inventori dan Aset REA TEHNIK Berbasis Web Menggunakan Framework Laravel,” J. Ilm. Sist. Inf., vol. 5, no. 2, hlm. 416–428, Apr 2026, doi: 10.51903/mpwjt966.

[12] Y. E. Achyani dan S. Saumi, “Penerapan Metode Waterfall Pada Sistem Informasi Manajemen Buku Perpustakaan Berbasis Web,” J. SAINTEKOM, vol. 9, no. 1, hlm. 83–94, Mar 2019, doi: 10.33020/saintekom.v9i1.84.

[13] S. N. Fatonatur Rohma dan O. A. Opoku, “Design Get Up System Information Inventory Goods Based Web Using the Waterfall Method at CV. Tekno Maju Jaya,” J. Bus. Soc. Technol., vol. 6, no. 2, hlm. 93–101, Feb 2026, doi: 10.59261/jbt.v6i2.567.

[14] H. F. Herdiyatmoko dan Y. D. Pratama, “Rest Api Pada Toko Kelontong Untuk Transaksi Penjualan Menggunakan Framework Laravel,” IDEALIS Indones. J. Inf. Syst., vol. 7, no. 1, hlm. 118–127, Jan 2024, doi: 10.36080/idealis.v7i1.3113.

[15] L. S. Saputra dan H. Fery Herdiyatmoko, “Implementasi Rest Api Pada Sistem Pendataan Kapal Menggunakan Laravel 9 Dan Nuxtjs,” J. Comput. Technol., vol. 2, no. 1, hlm. 10–21, Jul 2024, doi: 10.69916/comtechno.v2i1.138.

[16] S. Nidhra, “Black Box and White Box Testing Techniques - A Literature Review,” Int. J. Embed. Syst. Appl., vol. 2, no. 2, hlm. 29–50, Jun 2012, doi: 10.5121/ijesa.2012.2204.

[17] S. Saifudin, “Penerapan Model Waterfall Dan Blackbox Testing Dalam Pembuatan Sistem Informasi E-Aset Desa Berbasis Web,” Inform. Comput. Eng. J., vol. 1, no. 2, hlm. 14–18, Jul 2021, doi: 10.31294/icej.v1i2.445.