Acta Informatica Pragensia 2022, 11(3), 309-323 | DOI: 10.18267/j.aip.1964616
Data Analytics Approach for Short-term Sales Forecasts Using Limited Information in E-commerce Marketplace
- 1 Faculty of Computer Science and Information Technology, Universiti Malaysia Sarawak, Kota Samarahan, Malaysia
- 2 Karuna (Sarawak) Enterprise Sdn. Bhd., Malaysia
E-commerce has become very important in our daily lives. Many business transactions are made easier on this platform. Sellers and consumers are the two main parties that gain a lot of benefits from it. Although many sellers are attracted to set up their businesses on this online platform, it also causes challenges such as a highly competitive business environment and unpredictable sales. Thus, we propose a data analytics approach for short-term sales forecasts using limited information in the e-commerce marketplace. Product details are scraped from the e-commerce marketplace using a content scraping tool. Since the information in the e-commerce marketplace is limited and essential, scraped product details are pre-processed and constructed into meaningful data. These data are used in the computation of the forecasting methods. Three types of quantitative forecasting methods are computed and compared. These are simple moving average, dynamic linear regression and exponential smoothing. Three different evaluation metrics, namely mean absolute deviation, mean absolute percentage error and mean squared error, are used for the performance evaluation in order to determine the most suitable forecasting method. In our experiment, we found that the simple moving average has the best forecasting accuracy among other forecasting methods. Therefore, the application of the simple moving average forecasting method is suitable and can be used in the e-commerce marketplace for sales forecasting.
Keywords: Electronic commerce; Data analytics; Sales forecast; Simple moving average; Regression.
Received: July 26, 2022; Revised: October 4, 2022; Accepted: October 18, 2022; Prepublished online: November 1, 2022; Published: December 26, 2022 Show citation
ACS | AIP | APA | ASA | Harvard | Chicago | Chicago Notes | IEEE | ISO690 | MLA | NLM | Turabian | Vancouver |
References
- Aini, A. N., Purbaningtyas, R., & Adityo, R. D. (2017). Forecasting Sales 3kg LPG using Single Exponential Smoothing Method. Journal of Electrical Engineering and Computer Sciences, 2(2), 281-286.
Go to original source...
- Awal, M. A., Rabbi, J., Hossain, S. I., & Hashem, M. M. (2016). Using Linear Regression to Forecast Future Trends in Crime of Bangladesh. In 2016 5th International Conference on Informatics, Electronics and Vision (pp. 333-338). IEEE. https://doi.org/10.1109/ICIEV.2016.7760021
Go to original source...
- Bach, C., & Alessa, A. (2014). Data Mining and Knowledge Management for Marketing. International Journal of Innovation and Scientific Research, 2(2), 321-328.
- Cheriyan, A., & Tamilarasi, D. S. (2019). A Study on the Influence of Mobile Accessories Purchased Impulsively, with Special Reference to Chennai City. International Journal of Advanced Science and Technology, 28(17), 780-790.
- Hanggara, F. D. (2021). Forecasting Car Demand in Indonesia with Moving Average Method. Journal of Engineering Science and Technology Management, 1(1), 1-6.
Go to original source...
- International Trade Administration. (n.d.). Malaysia - eCommerce. https://www.privacyshield.gov/article?id=Malaysia-E-Commerce
- Kambal, E., Osman, I., Taha, M., Mohammed, N., & Mohammed, S. (2013). Credit Scoring Using Data Mining Techniques with Particular Reference to Sudanese Banks. In 2013 International Conference on Computing, Electrical and Electronic Engineering (ICCEEE) (pp. 378-383). IEEE. https://doi.org/10.1109/ICCEEE.2013.6633966
Go to original source...
- Ke, J., Zheng, H., Yang, H., & Chen, X. (Michael). (2017). Short-term forecasting of passenger demand under on-demand ride services: A spatio-temporal deep learning approach. Transportation Research Part C: Emerging Technologies, 85, 591-608. https://doi.org/10.1016/j.trc.2017.10.016
Go to original source...
- Khair, U., Fahmi, H., Hakim, S. A., & Rahim, R. (2017). Forecasting Error Calculation with Mean Absolute Deviation and Mean Absolute Percentage Error. Journal of Physics: Conference Series, 930, Article no. 012002. https://doi.org/10.1088/1742-6596/930/1/012002
Go to original source...
- Kilimci, Z. H., Akyuz, A. O., Uysal, M., Akyokus, S., Uysal, M. O., Atak Bulbul, B., & Ekmis, M. A. (2019). An Improved Demand Forecasting Model Using Deep Learning Approach and Proposed Decision Integration Strategy for Supply Chain. Complexity, 2019, 1-15. https://doi.org/10.1155/2019/9067367
Go to original source...
- Nadhira, A. T., Gadisku, C. A., & Peranginangin, S. M. (2021). Demand Forecasting Comparison of Softex 1400-M using Single Moving Average Method and Single Exponential Smoothing Method. In Proceedings of the International Conference on Industrial Engineering and Operations Management, (pp. 452-459). IEOM Society International.
Go to original source...
- Najmi, E., Hashmi, K., Malik, Z., Rezgui, A., & Khan, H. U. (2015). CAPRA: a comprehensive approach to product ranking using customer reviews. Computing, 97(8), 843-867. https://doi.org/10.1007/s00607-015-0439-8
Go to original source...
- Naseri, R. N., Hussin, H., Esa, M. M., Aziz, N. E., & Nordin, M. N. (2021). What is a Population in Online Shopping Research? A perspective from Malaysia. Turkish Journal of Computer and Mathematics Education, 12(4), 654-658. https://doi.org/10.17762/turcomat.v12i4.549
Go to original source...
- Pataropura, A., Riki, R., & Saputra, A. (2019). Sales Analysis Using the Forecasting Method. Bit-Tech, 1(3), 146-149. https://doi.org/10.32877/bt.v1i3.79
Go to original source...
- Raudys, A., & Pabarskaite, Z. (2018). Optimising the Smoothness and Accuracy of Moving Average for Stock Price Data. Technological and Economic Development of Economy, 24(3), 984-1003. https://doi.org/10.3846/20294913.2016.1216906
Go to original source...
- Ren, S., Chan, H.-L., & Siqin, T. (2020). Demand forecasting in retail operations for fashionable products: methods, practices, and real case study. Annals of Operations Research, 291, 761-777. https://doi.org/10.1007/s10479-019-03148-8
Go to original source...
- Sinaga, H. D., & Irawati, N. (2020). A Medical Disposable Supply Demand Forecasting By Moving Average and Exponential Smoothing Method. In Proceedings of the 2nd Workshop on Multidisciplinary and Applications (WMA). EAI. https://doi.org/10.4108/eai.24-1-2018.2292378
Go to original source...
- Zhao, K., & Wang, C. (2017). Sales Forecast in e-Commerce using Convolutional Neural Network. arXiv:1708.07946v1. https://doi.org/10.48550/arXiv.1708.07946
Go to original source...
This is an open access article distributed under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits use, distribution, and reproduction in any medium, provided the original publication is properly cited. No use, distribution or reproduction is permitted which does not comply with these terms.