ESP32-Based Inventory Tracker for Goods Recording with Barcode Identification
Manual inventory management is prone to various challenges, including recording errors, delays in data updates, and time- and labor-intensive stock reconciliation processes. PT Berkah Industri Mesin Angkat Site Kendari experiences these issues in managing its warehouse inventory. This study proposes a Smart Inventory Tracker, an ESP32 microcontroller–based barcode matching system integrated with Google Spreadsheets via Google Apps Script as a Web API. The system scans barcodes using a GM66 barcode scanner, matches them against an online JSON database, displays item information on a TFT screen, and records the results in real time. The research method follows an engineering research approach, encompassing hardware and software design, system integration, and testing. Performance evaluation includes scanning distance, response time, accuracy, handling of unregistered barcodes, and a comparison with manual recording methods. The results show that the device operates optimally at scanning distances between 3.7 cm and 16.4 cm, with an average response time of 4.58 seconds. The system accurately records data, rejects unregistered barcodes, and achieves 89.94% efficiency improvement over manual methods, saving 40.99 seconds per item.
Adafruit Industries. (n.d.). Interfacing SPI TFT display with microcontrollers for IoT application. Retrieved from https://www.researchgate.net
Albahari, & Albahari. (2020). Performance evaluation of JSON and XML data formats for data exchange in IoT. International Journal of Computer Applications, 175(45), 33344. Retrieved from https://www.ijcaonline.org/archives/volume175/number45/33344-33344-20201224.pdf
Atzori, Iera, & Morabito. (2022). Alat pendeteksi stok barang berbasis IoT untuk UMKM dengan sensor ultrasonik dan inframerah. Jurnal Sistem Informasi. Retrieved from https://journal.maranatha.edu/index.php/jis/article/view
Bansod, & Kulkarni. (2021). Designing ESP32 base shield board for IoT application. Journal of Engineering Technology. Retrieved from https://app.mypolycc.edu.my/journal
Coursera Staff. (n.d.). How to use the Google Sheets API. Retrieved from https://www.coursera.org/articles/google-sheets-api
Design and implementation of a regulated DC power supply for microcontroller systems. (2025). International Journal of Engineering Research & Technology. Retrieved from https://www.ijert.org/research/design-and-implementation-of-a-regulated-dc-power-supply-for-microcontroller-systems-IJERTV11IS060188.pdf
Espressif. (n.d.). Analysis of Xtensa LX6 microprocessor for neural network applications ESP32. Retrieved from https://es.wikipedia.org
Farooq, Waseem, Mazhar, Khairi, & Kamal. (2021). A review on Internet of Things (IoT). International Journal of Computer Applications. Retrieved from https://ijarsct.co.in/Paper3145.pdf
Google Developers. (n.d.-a). Google Apps Script overview. Retrieved from https://developers.google.com/apps-script
Google Developers. (n.d.-b). Google Sheets API overview: RESTful interface for reading, writing, and modifying data in Google Sheets. Retrieved from https://developers.google.com/workspace/sheets/api/guides/concepts
Hakim, Ramadhan, & Lestari. (2024). Implementasi teknologi RFID dan barcode dalam optimalisasi manajemen inventaris barang di sektor logistik. Journal of Applied Engineering and Management. Retrieved from https://researchhub.id/index.php/jaem/article
Hamid, Zainal, & Kassim. (n.d.). Automated inventory management systems with IoT integration to optimize stock levels and reduce carrying costs for SMEs. Retrieved from https://www.researchgate.net
Handayani, & Hartono. (2021). Peran manajemen administrasi IT inventory bagi kinerja perusahaan di bidang kepabeanan: Studi kasus di PT Samwon Busana Indonesia. PMJ. Retrieved from https://ojs3.lppmuis.org/index.php/PMJ/article/view
Jafari, Habibzadeh, & Zhang. (2024). Agile, IoT, and AI: Revolutionizing warehouse tracking and inventory management in supply chain operations. JPSCM. Retrieved from https://gprjournals.org/journals/index.php/jpscm/article
Khan, et al. (2022). Smart warehouse management system: Architecture, real-time data collection, and automation using IoT. Retrieved from https://www.mdpi.com
Nico, J. A. (2024). Rancang bangun prototipe inventaris barang berbasis IoT menggunakan mikrokontroler ESP32 dan sensor radio frequency identification. Retrieved from https://repository.unisbablitar.ac.id/id/eprint/786/2/Abstract.pdf
Purnomo, & Wardhana. (2020). Penerapan barcode scanner system dalam proses pengujian ban di laboratorium uji PT XYZ. Retrieved from http://download.garuda.kemdikbud.go.id
Rahman, & Fitri. (n.d.). Penerapan teknologi aplikasi rumah pintar berbasis web menggunakan microcontroller ESP32. Retrieved from https://www.researchgate.net/publication
Ramadhan, M. I. (2022). Rancang bangun barcode scanner berbasis Arduino UNO untuk manajemen peminjaman alat laboratorium. Retrieved from https://repository.unej.ac.id/bitstream/handle/123456789/88104/Moch.Iqbal%20Ramadhan-141903102016%20Sdh.pdf
Refbacks
- There are currently no refbacks.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
The copyright is reserved to Research in Education, Technology, and Multiculture that is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Address:
CV. IMRECS: Jalan Gagak I, Kecamatan Larangan, Kota Tangerang. Postal Code: 15155
STKIP Al Islam Tunas Bangsa: Jalan Z.A. Pagar Alam No. 41 Gedong Meneng Bandar Lampung