Automatic Daily Scheduling System Using Cron Jobs for Handicraft Business Management
DOI:
https://doi.org/10.30812/corisindo.v1.5573Keywords:
Cron Job, Extreme Programming, Reorder Point, Shopee API, Twilio APIAbstract
Ensuring accurate stock information remains a challenge for handicraft business managers when sales data from physical stores and e-commerce platforms are not updated simultaneously. Previous studies have addressed stock synchronization but have yet to employ scheduling mechanisms for delivering daily stock summaries integrated with sales data from both sources. This study developed an automated scheduling system using a cron job to record and summarize daily stock movements, utilizing Shopee API integration to ensure data consistency between the physical store and the online platform. The Reorder Point concept was applied to determine restocking thresholds, while the Twilio API was used to send stock summaries to managers via WhatsApp. The system was implemented using the Extreme Programming method to accelerate adaptation to user requirements. The results indicated that the system consistently provided daily stock reports, maintained data consistency across platforms, and supported procurement decision-making. This approach offers a novelty by combining automated stock synchronization and scheduled stock report distribution within a single integrated system.
References
[1] N. K. Akmal and M. N. Dasaprawira, “Rancang Bangun Application Programming Interface (API) Menggunakan Gaya Arsitektur GraphQL untuk Pembuatan Sistem Informasi Pendataan Anggota Unit Kegiatan Mahasiswa (UKM) Studi Kasus UKM Starlabs,” SITECH Journal, vol. 5, no. 1, pp. 38–40, Jul. 2022. [Online]. Available: http://www.jurnal.umk.ac.id/sitech
[2] J. vom Brocke, A. Hevner, and A. Maedche, “Introduction to Design Science Research,” in Design Science Research. Lecture Notes in Information Systems and Organisation, Cham: Springer, 2020, pp. 1–13. doi: 10.1007/978-3-030-46781-4_1.
[3] V. T. Gumilang, “Perancangan Sistem Manajemen Stok Barang Berbasis Web pada PT X,” Jurnal Ilmu Komputer dan Sistem Informasi, 2023.
[4] C. Grob and A.-Schriftenreihe, “Inventory Management in Multi-Echelon Networks: On the Optimization of Reorder Points,” [Online]. Available: http://www.autouni.de
[5] Juwita and F. Rahmiyatun, “Penerapan Metode Economic Order Quantity (EOQ) dan Reorder Point (ROP) pada Pengendalian Persediaan Bahan Baku di UMKM Dapur Bunga Berbintang,” Jurnal Maneksi, vol. 12, no. 4, pp. 818–827, 2023.
[6] R. A. Bimantoro, A. S. Fitrani, and S. Busono, “Sistem WhatsApp sebagai Notifikasi pada UMSIDA Farm Store Berbasis Web,” Journal of Internet and Software Engineering, vol. 1, no. 1, pp. 14–21, Jan. 2024, doi: 10.47134/pjise.v1i1.2248.
[7] R. S. Pressman and B. R. Maxim, Software Engineering: A Practitioner’s Approach, 8th ed. New York: McGraw-Hill, 2014.
[8] S. M. Pratama and R. Jefri, “Analisis Sistem Akuntansi Persediaan Barang Dagang pada UMKM MiMa Frozen Food,” Jurnal Pundi, vol. 8, no. 2, pp. 125–135, Dec. 2024, doi: 10.31575/jp.v8i2.565.
[9] T. F. Rahmadanti, M. Jajuli, and I. Purnamasari, “Klasifikasi Pengguna Shopee Berdasarkan Promosi Menggunakan Naïve Bayes,” in Proc. Seminar Nasional Teknologi Informasi dan Komunikasi (SENTIKA), Yogyakarta, Indonesia, 2021, pp. 81–89.
[10] N. Saprido and R. Pahlevi, “Pengembangan Aplikasi Manajemen Stock Barang pada PT Pangkalan Gas Andika Mukti Berbasis Web,” Bulletin of Informatics (BIN), vol. 2, no. 1, pp. 67–77, Jul. 2024, ISSN: 3025-7417. [Online]. Available: https://ojs.jurnalmahasiswa.com/ojs/index.php/bin.
[11] D. Fatmawati and D. A. Megawaty, “Aplikasi Supervisi Dosen Berbasis Web di Universitas XYZ,” J. Informatika dan Rekayasa Perangkat Lunak (JATIKA), vol. 4, no. 3, pp. 270–283, 2023.
[12] A. D. Saputro and A. A. Narwastika, “Implementasi White Box Testing dengan Teknik Basis Path pada Pengujian Form Peminjaman Sistem Aplikasi Perpustakaan,” in Proc. Seminar Nasional Teknologi Informasi dan Bisnis (SENATIB), Surakarta, Indonesia, Jul. 2023, p. 406.
[13] D. Shenoy and R. Rosas, Problems and Solutions in Inventory Management. Cham: Springer International Publishing AG, 2018. doi: 10.1007/978-3-319-65696-0.
[14] S. Sundaramoorthy, UML Diagramming: A Case Study Approach. CRC Press, 2022.
[15] Safriza and H. Rohayani, “Implementation of Path Testing in White Box Testing for the National Public Transportation Driver Behavior and Competency Assessment System,” Lovelace Journal of Information System, Security, Education and Network Artificial Intelligence, vol. 2, pp. 1–16, 2024.
