ESP32-Based Inventory Tracker for Goods Recording with Barcode Identification
Manual inventory recording remains vulnerable to delayed updates, transcription errors, and repeated reconciliation, particularly in warehouse units that still rely on spreadsheet-based data entry. This study aims to design and evaluate a Smart Inventory Tracker for recording goods at the PT Berkah Industri Mesin Angkat Site Kendari by integrating barcode scanning, ESP32-based edge processing, and cloud-based storage. The prototype used an ESP32 development board, a GM66 barcode scanner communicating through a Universal Asynchronous Receiver-Transmitter (UART) interface, a thin-film transistor (TFT) display driven through the Serial Peripheral Interface (SPI) protocol, a 12 V DC power supply with step-down regulation, a JSON reference database hosted on GitHub, and a Google Apps Script endpoint for writing validated transactions to Google Spreadsheets. The evaluation followed an engineering research approach covering hardware assembly, software integration, database matching, transaction logging, and functional testing. System performance was assessed through barcode readability distance testing, registered and unregistered barcode validation, end-to-end response-time measurement, and paired comparison with manual Google Sheets recording. Barcode reading was reliable at 3.7-16.4 cm, while scans at 3.6 cm and 16.5 cm failed outside the empirically verified optical working range. Ten registered barcode samples were successfully displayed and recorded, with an average end-to-end cloud logging time of 4.58 s per item. Manual recording required 45.57 s per item on average; therefore, the automated method reduced the observed recording duration by 40.99 s per item, equivalent to an 89.94% time reduction. Unregistered barcodes were rejected and were not appended to the spreadsheet. These findings indicate that the architecture supports faster and more consistent recording for small- to medium-sized warehouse operations. However, component-level latency logging, offline buffering, and broader network-condition testing remain necessary before large-scale commercial deployment.
Keywords: Inventory management, ESP32, Barcode identification, Internet of Things (IoT), Google spreadsheets.
Atzori, L., Iera, A., & Morabito, G. (2010). The Internet of Things: A survey. Computer Networks, 54(15), 2787–2805. https://doi.org/10.1016/j.comnet.2010.05.010
Ben-Daya, M., Hassini, E., & Bahroun, Z. (2019). Internet of things and supply chain management: A literature review. International Journal of Production Research, 57(15–16), 4719–4742. https://doi.org/10.1080/00207543.2017.1402140
Espressif Systems. (2024). ESP32 technical reference manual (Version 5.2). https://www.espressif.com/sites/default/files/documentation/esp32_technical_reference_manual_en.pdf
Espressif Systems. (n.d.-a). SPI master driver—ESP32—ESP-IDF programming guide v6.0.2 documentation. Retrieved July 14, 2026, from https://docs.espressif.com/projects/esp-idf/en/stable/esp32/api-reference/peripherals/spi_master.html
Espressif Systems. (n.d.-b). SPIFFS filesystem—ESP32—ESP-IDF programming guide v6.0.2 documentation. Retrieved July 14, 2026, from https://docs.espressif.com/projects/esp-idf/en/stable/esp32/api-reference/storage/spiffs.html
GitHub. (n.d.). GitHub REST API documentation. Retrieved July 14, 2026, from https://docs.github.com/en/rest
Google. (n.d.). Google Sheets API overview. Google for Developers. Retrieved July 14, 2026, from https://developers.google.com/workspace/sheets/api/guides/concepts
Gubbi, J., Buyya, R., Marusic, S., & Palaniswami, M. (2013). Internet of Things (IoT): A vision, architectural elements, and future directions. Future Generation Computer Systems, 29(7), 1645–1660. https://doi.org/10.1016/j.future.2013.01.010
Hercog, D., Lerher, T., Truntič, M., & Težak, O. (2023). Design and implementation of ESP32-based IoT devices. Sensors, 23(15), Article 6739. https://doi.org/10.3390/s23156739
Hofmann, E., & Rüsch, M. (2017). Industry 4.0 and the current status as well as future prospects on logistics. Computers in Industry, 89, 23–34. https://doi.org/10.1016/j.compind.2017.04.002
Jarašūnienė, A., Čižiūnienė, K., & Čereška, A. (2023). Research on impact of IoT on warehouse management. Sensors, 23(4), Article 2213. https://doi.org/10.3390/s23042213
Khan, M. G., Huda, N. U., & Zaman, U. K. U. (2022). Smart warehouse management system: Architecture, real-time implementation and prototype design. Machines, 10(2), Article 150. https://doi.org/10.3390/machines10020150
Lasi, H., Fettke, P., Kemper, H. G., Feld, T., & Hoffmann, M. (2014). Industry 4.0. Business & Information Systems Engineering, 6(4), 239–242. https://doi.org/10.1007/s12599-014-0334-4
Lee, I., & Lee, K. (2015). The Internet of Things (IoT): Applications, investments, and challenges for enterprises. Business Horizons, 58(4), 431–440. https://doi.org/10.1016/j.bushor.2015.03.008
Li, Z., Guo, H., Xu, W., & Chen, B. (2023). Serverless computing: State-of-the-art, challenges and opportunities. IEEE Transactions on Services Computing, 16(2), 1522–1539. https://doi.org/10.1109/TSC.2022.3166553
Melo, G. C. G., Torres, I. C., de Araújo, I. B. Q., Brito, D. B., & Barboza, E. A. (2021). A low-cost IoT system for real-time monitoring of climatic variables and photovoltaic generation for smart grid application. Sensors, 21(9), Article 3293. https://doi.org/10.3390/s21093293
Nico, J. A. N. (2024). Rancang bangun prototipe inventaris barang berbasis IoT menggunakan mikrokontroler ESP32 dan sensor radio frequency identification [Undergraduate thesis, Universitas Islam Balitar]. Universitas Islam Balitar Repository. https://repository.unisbablitar.ac.id
Nižetić, S., Šolić, P., López-de-Ipiña González-de-Artaza, D., & Patrono, L. (2020). Internet of Things (IoT): Opportunities, issues and challenges towards a smart and sustainable future. Journal of Cleaner Production, 274, Article 122877. https://doi.org/10.1016/j.jclepro.2020.122877
Patil, K. A., & Kale, N. R. (2016). A model for smart agriculture using IoT. 2016 International Conference on Global Trends in Signal Processing, Information Computing and Communication (ICGTSPICC), 543–545. https://doi.org/10.1109/ICGTSPICC.2016.7955360
Pratama, S. A. P., Hidayat, H., Rahim, W. G. E., & Nugraha, M. A. (2025). IoT-based barcode scanning system implementation using ESP32 for enhancing warehouse stock opname efficiency. International Journal of Research and Applied Technology (INJURATECH), 5(1), 268–276. https://ojs.unikom.ac.id/index.php/injuratech/article/view/19200
Ray, P. P. (2018). A survey on Internet of Things architectures. Journal of King Saud University – Computer and Information Sciences, 30(3), 291–319. https://doi.org/10.1016/j.jksuci.2016.10.003
Rejeb, A., Simske, S., Rejeb, K., Treiblmaier, H., & Zailani, S. (2020). Internet of Things research in supply chain management and logistics: A bibliometric analysis. Internet of Things, 12, Article 100318. https://doi.org/10.1016/j.iot.2020.100318
Santosa, S. H., Hidayat, A. P., Siskandar, R., & Husyairi, K. A. (2024). IoT-based barcode scanning system for production and warehouse management. Batrisya: Journal of Electrical Engineering and Computer Science, 2(1), 45–58. https://batrisyaedu.com/journal/index.php/batrisya/article/view/18
Sarac, A., Absi, N., & Dauzère-Pérès, S. (2010). A literature review on the impact of RFID technologies on supply chain management. International Journal of Production Economics, 128(1), 77–95. https://doi.org/10.1016/j.ijpe.2010.07.039
Szymańska, O., Adamczak, M., & Cyplik, P. (2017). Logistics 4.0—A new paradigm or set of known solutions? Research in Logistics & Production, 7(4), 299–310. https://doi.org/10.21008/j.2083-4950.2017.7.4.2
Tubis, A. A., & Rohman, J. (2023). Intelligent warehouse in Industry 4.0—Systematic literature review. Sensors, 23(8), Article 4105. https://doi.org/10.3390/s23084105
Unhelkar, B., Joshi, S., Sharma, M., Prakash, S., Mani, A. K., & Prasad, M. (2022). Enhancing supply chain performance using RFID technology and decision support systems in the Industry 4.0—A systematic literature review. International Journal of Information Management Data Insights, 2(2), Article 100084. https://doi.org/10.1016/j.jjimei.2022.100084
Wen, Y., & Zhu, Q. (2022). An improved network time protocol for industrial Internet of Things. Sensors, 22(13), Article 5021. https://doi.org/10.3390/s22135021
Widoretno, S., Hadi, A., & Zuhair, A. (2025). Implementasi pemilah barang paket ekspedisi menggunakan QR Code dengan ESP32 yang terintegrasi dengan Google Spreadsheet untuk manajemen data [Implementation of expedition package sorting using QR Code with ESP32 integrated with Google Spreadsheet for data management]. Jurnal Qua Teknika, 15(2), 119–124. https://doi.org/10.35457/quateknika.v15i02.5083
Winkelhaus, S., & Grosse, E. H. (2020). Logistics 4.0: A systematic review towards a new logistics system. International Journal of Production Research, 58(1), 18–43. https://doi.org/10.1080/00207543.2019.1612964
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