Development of Integrated Warehouse Application for Retail Business with Multi-Echelon Demand using Open-source ERP System
Keywords:
Integrated Warehouse Application; Odoo; Retail Business; Retail; SMEs
Abstract
The Integrated Warehouse Application (IWA) is a platform that combines inventory management, order management, warehouse operations, shipping, logistics, and reporting and analysis. It helps users manage their inventory to meet supply and demand requirements. Although many large companies use IWA to increase their operational efficiency, its complexity, technology, and customization requirements make it too expensive for small and medium-sized enterprises (SMEs). Our study focuses on SMEs in the retail business, where fast and accurate order processing is important for customer satisfaction and loyalty. We researched how to accommodate multi-echelon demand for the retail industry. To address these challenges, we used an Open-source ERP System called Odoo to create the IWA. Our findings show that implementing an integrated warehouse inventory system like the one provided by Odoo can offer real-time visibility into inventory levels, orders, and shipments. Automating manual processes enhances speed and accuracy, which improves customer service and business performance.
Downloads
Download data is not yet available.
References
Alaskari, O., Pinedo-Cuenca, R., and Ahmad, M. M. 2021. “Framework for Implementation of Enterprise Resource Planning (ERP) Systems in Small and Medium Enterprises (SMEs): A Case Study,” Procedia Manufacturing (55), pp. 424–430. (https://doi.org/10.1016/j.promfg.2021.10.058).
Alghazali, A. M., and Ageeli, U. M. 2020. “The Role of ERP Information to Support Decision Making Process: Field Study on Panda Retail Company (Mobile Inventory Management System),” International Journal of Interactive Mobile Technologies (IJIM) (14:16), p. 133. (https://doi.org/10.3991/ijim.v14i16.16943).
AlMuhayfith, S., and Shaiti, H. 2020. “The Impact of Enterprise Resource Planning on Business Performance: With the Discussion on Its Relationship with Open Innovation,” Journal of Open Innovation: Technology, Market, and Complexity (6:3), p. 87. (https://doi.org/10.3390/joitmc6030087).
Antari, D. D., Sukarsa, I. M., and Bayupati, I. P. A. 2014. “Implementasi Proses Bisnis pada Perusahaan Retail Menggunakan Software Adempiere,” Jurnal Ilmiah Merpati (2:1). (https://ojs.unud.ac.id/index.php/merpati/article/view/17821).
Bakhri, S. 2019. “Evaluasi Faktor-Faktor Yang Mempengaruhi Performa Implementasi SAP ERP Di Industri Retail,” Walisongo Journal of Information Technology (1:2), p. 111. (https://doi.org/10.21580/wjit.2019.1.2.4528).
Davyn Limited. 2023. “The Retailer’s Roadmap: Why Do I Need ERP,” Davyn, , April 3. (https://davyntt.com/the-retailers-roadmap-why-do-i-need-erp, accessed May 27, 2023).
Hansen, H. F., Haddara, M., and Langseth, M. 2023. “Investigating ERP System Customization: A Focus on Cloud-ERP,” Procedia Computer Science (219), pp. 915–923. (https://doi.org/10.1016/j.procs.2023.01.367).
Hasegawa, T., and Tani, S. 2022. “Indonesia’s Small Shops Attract Big Interests amid Digital Wave,” Asia Nikkei, , March 27. (https://asia.nikkei.com, accessed May 29, 2023).
Hustad, E., and Stensholt, J. 2023. “Customizing ERP-Systems: A Framework to Support the Decision-Making Process,” Procedia Computer Science (219), pp. 789–796. (https://doi.org/10.1016/j.procs.2023.01.352).
Ibrahim, M. F., Yogantara Setya Dharmawan, and Ngatini. 2022. “Implementation of Open-Source ERP-Based Fleet Management System on SMEs Transportation Service Provider,” Jurnal RESTI (Rekayasa Sistem Dan Teknologi Informasi) (6:5), pp. 883–890. (https://doi.org/10.29207/resti.v6i5.4538).
ILO-PROMISE IMPACT project. 2019. Financing Small Businesses in Indonesia: Challenges and Opportunities, ILO. (https://www.ilo.org/jakarta/whatwedo/publications/WCMS_695134/lang--en/index.htm).
Malhotra, R., and Temponi, C. 2010. “Critical Decisions for ERP Integration: Small Business Issues,” International Journal of Information Management (30:1), pp. 28–37. (https://doi.org/10.1016/j.ijinfomgt.2009.03.001).
Pérez Estébanez, R. 2021. “Assessing the Benefits of an ERP Implementation in SMEs. An Approach from The,” Scientific Annals of Economics and Business (68:1), pp. 63–73. (https://doi.org/10.47743/saeb-2021-0006).
Putri Navalina, I. L., Ludfi Djajanto, and Ari Kamayanti. 2021. “Designing Accounting Information Systems for Primary Cash Receipts and Expenditures in Open ERP-Based Retail Units (ODOO),” Open Access Indonesia Journal of Social Sciences (4:2), pp. 199–208. (https://doi.org/10.37275/oaijss.v4i2.48).
Quona Capital. 2021. “Reinventing the Way Small Shops across Indonesia Get Their Inventory,” Quona Capital, , March 18. (https://quona-capital.medium.com/., accessed May 28, 2023).
Retnasari, T. 2021. “Pemodelan Enterprise Resource Planning Pada Perusahaan Ritel,” Informatik : Jurnal Ilmu Komputer (17:1), p. 17. (https://doi.org/10.52958/iftk.v17i1.2657).
Rupčić, N. 2021. “Implementing Enterprise Resource Planning in SMEs: The Consultants’ Perspective,” International Journal of Business Information Systems (37:4), p. 467. (https://doi.org/10.1504/IJBIS.2021.117001).
Suryantoro, E. H. 2021. “Faktor Keberhasilan Dan Kegagalan Implementasi ERP-SAP Pada Industri Retail Di Indonesia,” Jurnal Teknologi Informasi (6:2), pp. 130–138. (https://doi.org/10.52643/jti.v6i2.1142).
Suryo, D. A., Abdullah, S., and Siswanto, T. 2021. “Odoo ERP Implementation Point of Sale Module at Mc Cake,” Intelmatics (1:1). (https://doi.org/10.25105/itm.v1i1.7769).
Tambovcevs, A., and Tambovceva, T. 2022. “ERP System Implementation: Benefits and Economic Effectiveness,” International Journal of Systems Applications, Engineering & Development (16), pp. 14–20. (https://doi.org/10.46300/91015.2022.16.3).
Tongsuksai, S., Mathrani, S., and Weerasinghe, K. 2022. “Cloud ERP Adoption in SMEs of New Zealand Retail Industry: Exploring CSFs and Risks,” in 2022 IEEE Asia-Pacific Conference on Computer Science and Data Engineering (CSDE), Gold Coast, Australia: IEEE, December 18, pp. 1–8. (https://doi.org/10.1109/CSDE56538.2022.10089346).
Yulianto, N., Anon, M., Prabowo, H., and Hidayanto, A. N. 2020. “ERP System Selection for Small Medium Enterprises (SMEs): A Systematic Literature Review,” INTERNATIONAL JOURNAL OF MECHANICAL ENGINEERING AND TECHNOLOGY (IJMET) (11:12). (https://doi.org/10.34218/IJMET.11.12.2020.001).
Alghazali, A. M., and Ageeli, U. M. 2020. “The Role of ERP Information to Support Decision Making Process: Field Study on Panda Retail Company (Mobile Inventory Management System),” International Journal of Interactive Mobile Technologies (IJIM) (14:16), p. 133. (https://doi.org/10.3991/ijim.v14i16.16943).
AlMuhayfith, S., and Shaiti, H. 2020. “The Impact of Enterprise Resource Planning on Business Performance: With the Discussion on Its Relationship with Open Innovation,” Journal of Open Innovation: Technology, Market, and Complexity (6:3), p. 87. (https://doi.org/10.3390/joitmc6030087).
Antari, D. D., Sukarsa, I. M., and Bayupati, I. P. A. 2014. “Implementasi Proses Bisnis pada Perusahaan Retail Menggunakan Software Adempiere,” Jurnal Ilmiah Merpati (2:1). (https://ojs.unud.ac.id/index.php/merpati/article/view/17821).
Bakhri, S. 2019. “Evaluasi Faktor-Faktor Yang Mempengaruhi Performa Implementasi SAP ERP Di Industri Retail,” Walisongo Journal of Information Technology (1:2), p. 111. (https://doi.org/10.21580/wjit.2019.1.2.4528).
Davyn Limited. 2023. “The Retailer’s Roadmap: Why Do I Need ERP,” Davyn, , April 3. (https://davyntt.com/the-retailers-roadmap-why-do-i-need-erp, accessed May 27, 2023).
Hansen, H. F., Haddara, M., and Langseth, M. 2023. “Investigating ERP System Customization: A Focus on Cloud-ERP,” Procedia Computer Science (219), pp. 915–923. (https://doi.org/10.1016/j.procs.2023.01.367).
Hasegawa, T., and Tani, S. 2022. “Indonesia’s Small Shops Attract Big Interests amid Digital Wave,” Asia Nikkei, , March 27. (https://asia.nikkei.com, accessed May 29, 2023).
Hustad, E., and Stensholt, J. 2023. “Customizing ERP-Systems: A Framework to Support the Decision-Making Process,” Procedia Computer Science (219), pp. 789–796. (https://doi.org/10.1016/j.procs.2023.01.352).
Ibrahim, M. F., Yogantara Setya Dharmawan, and Ngatini. 2022. “Implementation of Open-Source ERP-Based Fleet Management System on SMEs Transportation Service Provider,” Jurnal RESTI (Rekayasa Sistem Dan Teknologi Informasi) (6:5), pp. 883–890. (https://doi.org/10.29207/resti.v6i5.4538).
ILO-PROMISE IMPACT project. 2019. Financing Small Businesses in Indonesia: Challenges and Opportunities, ILO. (https://www.ilo.org/jakarta/whatwedo/publications/WCMS_695134/lang--en/index.htm).
Malhotra, R., and Temponi, C. 2010. “Critical Decisions for ERP Integration: Small Business Issues,” International Journal of Information Management (30:1), pp. 28–37. (https://doi.org/10.1016/j.ijinfomgt.2009.03.001).
Pérez Estébanez, R. 2021. “Assessing the Benefits of an ERP Implementation in SMEs. An Approach from The,” Scientific Annals of Economics and Business (68:1), pp. 63–73. (https://doi.org/10.47743/saeb-2021-0006).
Putri Navalina, I. L., Ludfi Djajanto, and Ari Kamayanti. 2021. “Designing Accounting Information Systems for Primary Cash Receipts and Expenditures in Open ERP-Based Retail Units (ODOO),” Open Access Indonesia Journal of Social Sciences (4:2), pp. 199–208. (https://doi.org/10.37275/oaijss.v4i2.48).
Quona Capital. 2021. “Reinventing the Way Small Shops across Indonesia Get Their Inventory,” Quona Capital, , March 18. (https://quona-capital.medium.com/., accessed May 28, 2023).
Retnasari, T. 2021. “Pemodelan Enterprise Resource Planning Pada Perusahaan Ritel,” Informatik : Jurnal Ilmu Komputer (17:1), p. 17. (https://doi.org/10.52958/iftk.v17i1.2657).
Rupčić, N. 2021. “Implementing Enterprise Resource Planning in SMEs: The Consultants’ Perspective,” International Journal of Business Information Systems (37:4), p. 467. (https://doi.org/10.1504/IJBIS.2021.117001).
Suryantoro, E. H. 2021. “Faktor Keberhasilan Dan Kegagalan Implementasi ERP-SAP Pada Industri Retail Di Indonesia,” Jurnal Teknologi Informasi (6:2), pp. 130–138. (https://doi.org/10.52643/jti.v6i2.1142).
Suryo, D. A., Abdullah, S., and Siswanto, T. 2021. “Odoo ERP Implementation Point of Sale Module at Mc Cake,” Intelmatics (1:1). (https://doi.org/10.25105/itm.v1i1.7769).
Tambovcevs, A., and Tambovceva, T. 2022. “ERP System Implementation: Benefits and Economic Effectiveness,” International Journal of Systems Applications, Engineering & Development (16), pp. 14–20. (https://doi.org/10.46300/91015.2022.16.3).
Tongsuksai, S., Mathrani, S., and Weerasinghe, K. 2022. “Cloud ERP Adoption in SMEs of New Zealand Retail Industry: Exploring CSFs and Risks,” in 2022 IEEE Asia-Pacific Conference on Computer Science and Data Engineering (CSDE), Gold Coast, Australia: IEEE, December 18, pp. 1–8. (https://doi.org/10.1109/CSDE56538.2022.10089346).
Yulianto, N., Anon, M., Prabowo, H., and Hidayanto, A. N. 2020. “ERP System Selection for Small Medium Enterprises (SMEs): A Systematic Literature Review,” INTERNATIONAL JOURNAL OF MECHANICAL ENGINEERING AND TECHNOLOGY (IJMET) (11:12). (https://doi.org/10.34218/IJMET.11.12.2020.001).
Published
2023-10-11
How to Cite
Meilanitasari, P., & Ibrahim, M. F. (2023). Development of Integrated Warehouse Application for Retail Business with Multi-Echelon Demand using Open-source ERP System. Jurnal Sistem Informasi, 19(2), 48-60. https://doi.org/10.21609/jsi.v19i2.1294
Section
Articles
Copyright (c) 2023 Jurnal Sistem Informasi
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
