Design and Implementation of a Web-Based Information System to Enhance Inventory and Service Management in Pet Retail Businesses
DOI:
https://doi.org/10.24036/javit.v5i2.230Keywords:
Petshop, Web-Based System, Information System, Admin Interface, User Interface, Business Process AutomationAbstract
The development of digital solutions for small and medium-sized enterprises (SMEs) is essential in supporting operational efficiency and customer engagement. This study presents the design and implementation of the Givan Petshop Information System, a web-based platform developed using a sequential linear methodology. The system aims to centralize and streamline business processes including inventory management, promotional campaigns, grooming service scheduling, and customer interactions. The development process encompassed thorough needs analysis, structured database modeling, and responsive user interface design for both admin and client users. Key features include real-time dashboards, dynamic product and service management, and integrated contact information access. The system was built using Visual Studio Code, MySQL, and XAMPP on a Windows-based environment and tested through interface simulations and functional evaluations. Results indicate that the system effectively supports business administration and improves the accessibility of information for users. While the system functions as intended in the development environment, limitations include the absence of real-user feedback and scalability testing. Future research is recommended to conduct usability testing in real-world settings, integrate mobile and cloud functionalities, and explore smart automation features to further enhance performance.
Downloads
References
G. U. Akpan et al., “Conclusions of the African Regional GIS Summit (2019): using geographic information systems for public health decision-making,” BMC Proc., vol. 16, no. 1, pp. 1–24, Apr. 2022, https://doi.org/10.1186/s12919-022-00233-y.
K. Aggarwal et al., “Marketing information system based on unsupervised visual data to manage transportation industry using signal processing,” Expert Syst., vol. 42, no. 1, p. e13384, Jan. 2023, https://doi.org/10.1111/exsy.13384.
M. Javaid, A. Haleem, R. P. Singh, and A. K. Sinha, “Digital economy to improve the culture of industry 4.0: A study on features, implementation and challenges,” Green Technol. Sustain., vol. 2, no. 2, p. 100083, May 2024, https://doi.org/10.1016/j.grets.2024.100083.
V. N. Annapareddy, “The Intersection of Big Data, Cybersecurity, and ERP Systems: A Deep Learning Perspective,” J. Artif. Intell. Big Data Discip., vol. 2, no. 1, pp. 45–53, Mar. 2025, https://doi.org/10.70179/Z385T072.
X. Li, Y. Tian, P. Ye, H. Duan, and F. Y. Wang, “A Novel Scenarios Engineering Methodology for Foundation Models in Metaverse,” IEEE Trans. Syst. Man, Cybern. Syst., vol. 53, no. 4, pp. 2148–2159, Apr. 2023, https://doi.org/10.1109/TSMC.2022.3228594.
L. D. Williams, “Concepts of Digital Economy and Industry 4.0 in Intelligent and information systems,” Int. J. Intell. Networks, vol. 2, pp. 122–129, Jan. 2021, https://doi.org/10.1016/j.ijin.2021.09.002.
A. Torab-Miandoab, T. Samad-Soltani, A. Jodati, and P. Rezaei-Hachesu, “Interoperability of heterogeneous health information systems: a systematic literature review,” BMC Med. Inform. Decis. Mak., vol. 23, no. 1, pp. 1–13, Dec. 2023, https://doi.org/10.1186/s12911-023-02115-5.
S. Huang and K. C. Desouza, “The new management logic of digital megaprojects: An agenda for information systems research,” J. Strateg. Inf. Syst., vol. 34, no. 3, p. 101911, Sep. 2025, https://doi.org/10.1016/J.JSIS.2025.101911.
K. Gupta, D. Oladimeji, C. Varol, A. Rasheed, and N. Shahshidhar, “A Comprehensive Survey on Artifact Recovery from Social Media Platforms: Approaches and Future Research Directions,” Inf., vol. 14, no. 12, p. 629, Nov. 2023, https://doi.org/10.3390/info14120629.
S. Hasan and S. Panda, “From Shelves to Servers: Revamping Collection Development Policies for a Digital-First Approach,” SSRN Electron. J., Apr. 2025, https://doi.org/10.2139/SSRN.5257996.
A. Aurelio and V. S. di Carlo, “Digital Demonstrators’ Development,” Eur. Green Deal Educ., pp. 109–123, Jan. 2024, https://doi.org/10.4324/9781003492597-10.
A. M. Shah, W. Muhammad, K. Lee, and R. A. Naqvi, “Examining different factors in web-based patients’ decision-making process: Systematic review on digital platforms for clinical decision support system,” Int. J. Environ. Res. Public Health, vol. 18, no. 21, p. 11226, Oct. 2021, https://doi.org/10.3390/ijerph182111226.
A. Kalinin, R. Rudnik, A. Tsvetov, K. Bondarenko, and A. Shuranova, “Emerging Markets Decoded 2024,” SSRN Electron. J., Jun. 2024, https://doi.org/10.2139/ssrn.4862785.
A. Durand-Morat, W. Mulimbi, and S. Bairagi, “International Rice Outlook_ International Rice Baseline Projectio,” AAES Res. Reports Res. Bull., no. May, May 2023, Accessed: Jul. 03, 2025. [Online]. Available: https://scholarworks.uark.edu/aaesrb/58.
D. Kretzschmann, G. Park, A. Berti, and W. M. P. van der Aalst, “Overstock Problems in a Purchase-to-Pay Process: An Object-Centric Process Mining Case Study,” Lect. Notes Bus. Inf. Process., vol. 521, pp. 347–359, 2024, https://doi.org/10.1007/978-3-031-61003-5_29.
D. O. Hassan and B. A. Hassan, “A comprehensive systematic review of machine learning in the retail industry: classifications, limitations, opportunities, and challenges,” Neural Comput. Appl., vol. 37, no. 4, pp. 2035–2070, Dec. 2024, https://doi.org/10.1007/s00521-024-10869-w.
F. E. Putra, M. Khasanah, and M. R. Anwar, “Optimizing Stock Accuracy with AI and Blockchain for Better Inventory Management,” ADI J. Recent Innov., vol. 6, no. 2, pp. 190–200, Mar. 2025, https://doi.org/10.34306/AJRI.V6I2.1200.
A. Ngoma and B. Getrude Mutono-Mwanza, “Evaluating the Effectiveness of Inventory Management Systems in Local Government: A Case Study of Nchelenge Town Council,” African J. Manag. Bus. Res., vol. 18, no. 1, pp. 167–180, Feb. 2025, https://doi.org/10.62154/AJMBR.2025.018.010574.
M. Paramesha, N. Rane, and J. Rane, “Big data analytics, artificial intelligence, machine learning, internet of things, and blockchain for enhanced business intelligence,” SSRN Electron. J., vol. 1, no. 2, pp. 110–133, Jul. 2024, https://doi.org/10.2139/ssrn.4855856.
T. Balaji, V. Hari, S. Lathifunnisa, P. Ganesh, and P. Arupya, “Optimizing Web-based Inventory Management system using QR code Technology,” Proc. Int. Conf. Circuit Power Comput. Technol. ICCPCT 2024, pp. 751–756, 2024, https://doi.org/10.1109/ICCPCT61902.2024.10673103.
F. Ugbebor, M. Adeteye, and J. Ugbebor, “Automated Inventory Management Systems with IoT Integration to Optimize Stock Levels and Reduce Carrying Costs for SMEs: A Comprehensive Review,” J. Artif. Intell. Gen. Sci. ISSN3006-4023, vol. 6, no. 1, pp. 306–340, Nov. 2024, https://doi.org/10.60087/JAIGS.V6I1.257.
C. K. Lim, “E-pet service apps for Kampar residential mobile application,” 2024.
C. A. Suárez, W. A. Guaño, C. C. Pérez, and H. Roa-López, “Multi-objective optimization for perishable product dispatch in a FEFO system for a food bank single warehouse,” Oper. Res. Perspect., vol. 12, p. 100304, Jun. 2024, https://doi.org/10.1016/j.orp.2024.100304.
A. dos S. Formiga and V. Silveira Júnior, “Effects of gaseous hydrogen peroxide on quality, shelf life and distribution management strategy F.E.F.O. (first expired, first out) of guavas cv. Pedro Sato,” Food Control, vol. 165, p. 110677, Nov. 2024, https://doi.org/10.1016/j.foodcont.2024.110677.
F. Pausan, “Designing a customizable product lifecycle management system for an SME to reach data singularity,” 2021.
T. Saharinen, “Success factors of digitalization and process optimization in indirect procurement categories : development of a stronger function,” 2025, Accessed: Jul. 03, 2025. [Online]. Available: https://lutpub.lut.fi/handle/10024/169270.
A. Mishra and Y. I. Alzoubi, “Structured software development versus agile software development: a comparative analysis,” Int. J. Syst. Assur. Eng. Manag., vol. 14, no. 4, pp. 1504–1522, Aug. 2023, https://doi.org/10.1007/s13198-023-01958-5.
J. Leong, K. May Yee, O. Baitsegi, L. Palanisamy, and R. K. Ramasamy, “Hybrid Project Management between Traditional Software Development Lifecycle and Agile Based Product Development for Future Sustainability,” Sustain., vol. 15, no. 2, p. 1121, Jan. 2023, https://doi.org/10.3390/su15021121.
S. Sotnik, V. Manakov, and V. Lyashenko, “Overview: PHP and MySQL Features for Creating Modern Web Projects,” International Journal of Academic Information Systems Research, vol. 7, no. 1. IJAISR, pp. 11–17, 2023. Accessed: Jul. 03, 2025. [Online]. Available: www.ijeais.org/ijaisr.
E. M. Arvanitou, A. Ampatzoglou, A. Chatzigeorgiou, and J. C. Carver, “Software engineering practices for scientific software development: A systematic mapping study,” J. Syst. Softw., vol. 172, p. 110848, Feb. 2021, https://doi.org/10.1016/j.jss.2020.110848.
C. Wu, F. Wu, Y. Huang, and X. Xie, “Personalized News Recommendation: Methods and Challenges,” ACM Trans. Inf. Syst., vol. 41, no. 1, Jan. 2023, https://doi.org/10.1145/3530257.
K. Shih, Y. Han, and L. Tan, “Recommendation System in Advertising and Streaming Media: Unsupervised Data Enhancement Sequence Suggestions,” Mar. 2025, Accessed: Jul. 03, 2025. [Online]. Available: http://arxiv.org/abs/2504.08740.
H. Xia, Z. Liu, M. Efremochkina, X. Liu, and C. Lin, “Study on city digital twin technologies for sustainable smart city design: A review and bibliometric analysis of geographic information system and building information modeling integration,” Sustain. Cities Soc., vol. 84, p. 104009, Sep. 2022, https://doi.org/10.1016/j.scs.2022.104009.
H. Kim, “Performance from building smart factories of small- and medium-sized enterprises: the moderating effects of product complexity and company size,” Int. J. Oper. Prod. Manag., vol. 42, no. 10, pp. 1497–1520, Sep. 2022, https://doi.org/10.1108/IJOPM-10-2021-0654.
A. Felix and G. D. Rembulan, “Analysis of Key Factors for Improved Customer Experience, Engagement, and Loyalty in the E-Commerce Industry in Indonesia,” APTISI Trans. Technopreneursh., vol. 5, no. 2Sp, pp. 196–208, Sep. 2023, https://doi.org/10.34306/att.v5i2sp.350.
T. T. Le, “Corporate social responsibility and SMEs’ performance: mediating role of corporate image, corporate reputation and customer loyalty,” Int. J. Emerg. Mark., vol. 18, no. 10, pp. 4565–4590, Nov. 2023, https://doi.org/10.1108/IJOEM-07-2021-1164.
R. K. Behera, P. K. Bala, and A. Ray, “Cognitive Chatbot for Personalised Contextual Customer Service: Behind the Scene and beyond the Hype,” Inf. Syst. Front., vol. 26, no. 3, pp. 899–919, Jul. 2024, https://doi.org/10.1007/s10796-021-10168-y.
B. Li, S. Mousa, J. R. R. Reinoso, H. M. Alzoubi, A. Ali, and A. D. Hoang, “The role of technology innovation, customer retention and business continuity on firm performance after post-pandemic era in China’s SMEs,” Econ. Anal. Policy, vol. 78, pp. 1209–1220, Jun. 2023, https://doi.org/10.1016/j.eap.2023.05.004.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Jefri Ramadi, A Walfajri fachriza, Dhifa Arifan Abadi, Rafael Oscar, Yogi Wahyu
This work is licensed under a Creative Commons Attribution 4.0 International License.
