Design and Implementation of an Online Bookstore Management System Integrated with WhatsApp and Google Services First Author\[1\]\*, Second Author2 (Double Blind Review: Please do not type or edit anything here until final-camera ready submissions) *1First affiliation, City and Country (Please do not type or edit anything here, until final camera-ready paper submission)* *2Second affiliation, City and Country (Please do not type or edit anything here, until final camera-ready paper submission)*
ARTICLE INFO ABSTRACT

Article history:

Received XX Month 2024

Revised XX Month 2024

Accepted XX Month 2024

Online first

Published 1 September 2024

 Online bookstore management system integrated with WhatsApp and google services is a new approach of the web development project, especially for students to purchase and sell vast quantities of books, mainly used books. This approach helps students obtain books quicker and more cheaply. The proposed system was utilized the google Services such as email, google form and google spreadsheet. While, WhatsApp allows the communication between admin and users for any transaction made. Meanwhile, ToyyibPay payment gateway lets students purchase books online without cash. The proposed system was developed based on System Development Life Cycle (SDLC) as a methodology. Two experiments were conducted to evaluate the effectiveness of the system which is usability testing and network performance test. A usability testing was done with 30 respondents to assess the efficacy of the system by reviewing questionnaires, which was categorized into 4 categories included user interface satisfaction, usefulness and ease of use, usability of the system, and WhatsApp and google services integration. The findings indicated most respondents were satisfied and positively accepted the proposed system. Meanwhile, the result of network performance on the website speed test for mobile and desktop devices was satisfactory. Therefore, it is a practical, cost-effective, trustworthy option that can help students in book sales transactions and subsequently can generate additional income for students.

Keywords:

Bookstore Management System

WhatsApp

Google Services

SDLC

Usability testing

Network performance test

DOI:

10.24191/jcrinn.v9i2
# Introduction Technology integration into various aspects of daily life has dramatically transformed how individuals interact with their surroundings (Gołąb-Andrzejak, 2023; Loukili et al., 2023; Walek & Fajmon, 2023). One such area has seen significant technological advancements in the online retail industry (Lara & Wassick, 2023). The online retail industry has rapidly grown in recent years, and the introduction of online bookstore management systems has made it easier for individuals to purchase books from the comfort of their homes. Nowadays, there is a growing interest in web-based systems for managing bookstores. Furthermore, the books now sold in stores are very expensive because the outside seller makes a very large profit for the books they sell. Meanwhile, according to Dr. Merrial M. Chase (2016), when you open a bookstore online, you can offer better prices to your customers. Large chain bookstores mark up the prices of the book they sell to make a greater profit. Therefore, many universities and colleges worldwide have implemented online systems to provide students with a more convenient and efficient way to purchase and sell books. For instance, Ajiboye et al. (2022) focused on developing a web-based bookstore management system for a university in Nigeria. The system was designed to provide students with a convenient way to purchase and sell books online and manage the bookstore's inventory. The study found that the system was well-received by students and helped improve the bookstore's efficiency. Similarly, a study by Othman et al. (2014) aimed to develop a web-based bookstore management system for Malaysia Higher Institute, and the system was designed to provide students and lecturers with an easy and convenient way to purchase the books. The system was expected to enhance the university’s efficiency in delivering the learning process. Meanwhile, a group of researchers provide a systematically and safe medium for user to sell and buy used good items via an online and mobile-based management system which consist of interface and database (Kasim et al., 2017). The system provides a new way of selling used good items by providing three web applications, which is customer application, administrator application and seller application. The website is able to help students that want to buy cheaper items and also help students to make extra money by selling their used goods. Besides, the system provides a wider market and more interactive compared to the traditional methods, and it also save time and cost. These previous studies provide valuable insight into developing and implementing web-based bookstore management systems for universities. These systems can help improve the bookstore's efficiency and provide students with a convenient way to purchase and sell books. However, the present study takes these previous studies further by integrating the system with WhatsApp and google services. This integration aims to provide additional features and benefits for students and the bookstore staff. The purpose of this study was to evaluate the effectiveness of the web-based bookstore management system in meeting the needs of students. The study was based on thoroughly evaluating the system's functionality, usability, and user satisfaction. The results of this study provide valuable insights into the potential of web-based bookstore management systems in improving the online shopping experience for individuals and can serve as a reference for future developments in online retail. The web-based bookstore management system was developed using a combination of web development technologies, including HTML, JavaScript, PHP, and SQL, to create an online platform that is both user-friendly and efficient in managing book information and transactions. The integration of WhatsApp and google services into the system was crucial in enhancing the system's overall functionality, allowing for improved communication and information sharing between the bookstore and its customers. 2. # Methodology 1. ## Developing the System Architecture for an Online Bookstore Management System Fig. 1 shows the system architecture of an online bookstore management system is designed to provide a secure, efficient, and user-friendly platform for customers to purchase and sell books. The system comprises several components: the front-end design, back-end database, WhatsApp, google services, ToyyibPay payment gateway, and email verification. The system's front end is designed using HTML, CSS, and JavaScript and provides a user-friendly interface for customers to navigate and make transactions. The front end is accessible from desktop and mobile devices. The system's back end is based on a database that stores all relevant information, such as user data, book listings, and transaction records. The database is designed to be secure and scalable and is built using PHP and MySQL. The integration of WhatsApp enables real-time communication between the admin and customers. The WhatsApp enables the admin to send notifications to customers about the status of their refund requests and other important updates. Google forms and spreadsheets are integrated into the system to provide a secure and efficient means of collecting and tracking refund requests. Then, ToyyibPay payment gateway is integrated into the system to provide a secure and convenient means of making online payments. This enables customers to purchase books without the need for cash transactions. The system also includes an email verification feature to add an extra layer of security to transactions. This feature requires customers to verify their email addresses before making transactions. Therefore, the integration of WhatsApp, google services, email verification, and the ToyyibPay payment gateway ensured that transactions are fast, convenient, and secure. ![](667e8c47cd7e1_media/media/image1.png)![](667e8c47cd7e1_media/media/image2.png) ![](667e8c47cd7e1_media/media/image3.png) ![](667e8c47cd7e1_media/media/image4.png) Fig. 1. An Online Web-Based Bookstore Management System Architecture ## Model Used for the Developing of an Online Bookstore Management System The System Development Life Cycle (SDLC) was used to develop an online bookstore management system. SDLC is a project management tool used to describe overall processes and activities in a software development project. Besides, it also lists the responsibilities and activities carried out by web developers. The process is associated with the waterfall model (Bassil, 2012) which consisted of five phases such as analysis, design, implementation, testing and maintenance. The waterfall model is a systematic and sequential approach to software development. This model ensures that each stage of development is completed before moving on to the next stage, and it ensures that the final product meets all requirements and is of high quality. ### 3.2.1 Analysis The most important phase (Kazim, 2017) focused on gathering all information that needed for the project development. In this phase, all information, data, and problem statements were identified by reading articles, journals and theses from previous research. On top of that, the current technology was observed in order to understand how technology can be implemented during the project development. Furthermore, the activities included were the identification of hardware and software requirement, objectives, scope of project, schedule of activities such as gantt chart, and the total budget. The result of this phase is feasibility report and a logical system design. The project's analysis phase is where the requirements or tools used during development are found. In addition to identifying the necessary technologies, the planning process also covered the potential applications for all the data. According to the researcher's research, the greatest application that may be used in a web-based application is an online website transaction. Every requirement and tool must be specified and thoroughly identified to avoid failure. The primary criteria for this project are that they may be divided into two main categories: hardware and software. Tables 1 and 2 cover both requirements for the development process. Table 1. Hardware Requirement
HARDWARE SPECIFICATIONS
Laptop Asus Rog Strix

- Operating System Windows 10 Home Single Language 64-bit

- Processor AMD Ryzen 7 5800H with Radeon Graphics

- Motherboard Asustek COMPUTER INC.

- Graphic Card Nvidia GeForce RTX 3050

- RAM 32GB
Android Poco X3

- Processor Qualcomm® Snapdragon™ 732G.

- Operating system MIUI 12 for POCO, based on Android 10

- Storage 128 GB

- RAM 6GB
iPhone 12 Pro Max

- Processor Apple A14 Bionic (5 nm)

- RAM: 6GB

- Storage: 512GB

- Operating System iOS 14
Table 2. Software Requirement | **SOFTWARE** | **DESCRIPTION** | | -------------------- | ---------------------------------------------------- | | Notepad++ | Develop the interface, function, HTML and PHP files. | | XAMPP | Used to create a self-contained Apache Server | | Web Hosting Services | Provides a secure place to store online content | | Adobe Photoshop | Design web image interface | ### 3.2.2 Design Since system design converts a logical design into a physical one, it is a crucial part of the system development life cycle. To ensure that the application is secure, reliable, and maintained, this step briefly outlines its functionality and features. The web-based application's initial design was based on data flow diagram (DFD), sitemap, and entity relationship diagram (ERD). The interface flow of the web-based application was represented using DFD, Sitemap, and ERD. On the other hand, the initial design of sitemap was deliverable, as shown in Fig. 2. > ![](667e8c47cd7e1_media/media/image5.png) Fig. 2. Sitemap of Web-Based Bookstore Management System ### 3.2.3 Implementation System implementation is the process flow project created, tested, and implemented in the SDLC. This phase also details how the program was run and how the PHP language was used. The proposed system was created utilizing a variety of software combinations, including Notepad++, a web hosting and domain server. Then this system integrated WhatsApp, ToyyibPay payment gateway, and google services such as email, google sheets, and google form. The proposed system will be carried out at this stage, and a connection to the database will be made. Information such as the specifics of the user detail, admin detail, book product, and other data will be recorded in the database. Users can view the information more interactively by integrating the interface and database. Fig. 3 shows the main page of the Web-based bookstore management system. There are six tabs: Book, Contact, Login, Register, Admin and Cart and each tab will redirect the user and admin to another page according to its tab’s name. ![](667e8c47cd7e1_media/media/image6.png) Fig. 3. Home Page for Web-Based Bookstore Management System ### 3.2.4 Testing To show that the web-based bookstore management system meets and conforms to the requirements that have been set, the testing process for the web-based application has been completed. To assess the application's usability and simplicity, usability testing was carried out. The learning process included usability testing, and after participants used the web application, an evaluation was recorded. After that, various factors, website speed tests for desktop and mobile, were used to assess the network performance of web hosting services and web-based applications. This test's goals were to increase system usability, ensure that participant or user actions and feedbacks are tracked and documented, and ensure that network performance testing across web hosting companies can be done successfully. ### 3.2.5 System Maintenance During the maintenance phase, new data is added to the system, backups are created, and any system issues are found. Therefore, by including this step, the system can keep running even if an error occurs later. 3. # Findings and Discussions 1. ## Usability Testing The usability testing of an online bookstore management system was conducted to assess its effectiveness and user experience. The test involved thirty (30) randomly selected respondents from the College of Computing, Informatics and Mathematics, UiTM Perlis. These respondents were chosen because they could provide accurate feedback on the system's interface and functionality. After testing the system, the participants were given a set of fifteen (15) questionnaires and categorized into four (4) parts to provide their feedback. The first part comprised of the user interface satisfaction. The second part focused on the usefulness and ease of use. The third part analyzed the usability of the system and finally, the fourth part investigated the integration of WhatsApp and google services. The data were analyzed using arithmetic mean technique based on ranking score value. The participants were required to rate the answer with the scale of 1 to 5, which was strongly disagree (1), disagree (2), neutral (3), agree (4), and strongly agree (5). Then, overall mean was calculated and classified into 3 categories, which is negative, neutral and positive based on the range of mean value in between zeros to five as shown in Table 3. Table 3. Range of mean value | **Category** | **Range of Mean** | | ------------ | ----------------- | | Negative | 0.00 - 1.66 | | Neutral | 1.67 – 3.33 | | Positive | 3.34 – 5.00 | From the results acquired, the total mean from all the categories calculated from the questionnaire was illustrated in Table 4. The results showed that the target respondents were satisfied and positively accepted all functionalities and features provided by the online bookstore management system. This can be proven when the total mean for each category was calculated above the point of 4.00. Furthermore, the integration of WhatsApp and google services obtained a score of 4.70, which indicated that the respondents were satisfied, and it can help them complete their task easier and faster. Besides, the overall total mean for usability testing is 4.66 which means positive feedback from the respondents. Based on the feedback received, it was determined that the entire an online bookstore management system was manageable, usable, and reached participants' targets. Table 4. The usability test results. | **No** | **Criteria** | **Mean** | **Mean Category** | | ---------------------------------------------------------------------- | -------------------------------------------------------------------------------------------- | -------- | ----------------- | | **PART 1: USER INTERFACE SATISFACTION** | | | | | 1 | The management system's user interface is easy-to-use and well-organized. | 4.60 | Positive | | 2 | The characters shown on the screen of this system are simple to understand and read. | 4.73 | Positive | | 3 | The navigation or connections are user-friendly. | 4.80 | Positive | | 4 | In this system, completing tasks is always uncomplicated. | 4.60 | Positive | | 5 | System error messages are informative and straightforward. | 4.40 | Positive | | | **TOTAL MEAN** | **4.63** | | | **PART 2: USEFULNESS AND EASE OF USE** | | | | | 6 | This system eliminates the requirement for I to visit a physical bookshop to purchase books. | 4.73 | Positive | | 7 | Learning how to run the system would be simple for me. | 4.60 | Positive | | 8 | By using the system, I was able to avoid crowded bookstores while purchasing books. | 4.80 | Positive | | | **TOTAL MEAN** | **4.71** | | | **PART 3: USABILITY OF THE SYSTEM** | | | | | 9 | I am satisfied with the system's user-friendliness. | 4.60 | Positive | | 10 | The system provides functions relating to online bookshop payment. | 4.70 | Positive | | 11 | The technology makes it simple to choose and get the books I need. | 4.73 | Positive | | 12 | I found the system's functionalities to be well together integrated. | 4.60 | Positive | | | **TOTAL MEAN** | **4.70** | | | **PART 4: INTEGRATION WITH WHATSAPP AND GOOGLE SERVICES** | | | | | 13 | Integration with email and Google services is useful for this system. | 4.63 | Positive | | 14 | I found that integrating email and Google services in this system is beneficial to users. | 4.63 | Positive | | 15 | I am pleased with how this system works. | 4.70 | Positive | | | **TOTAL MEAN** | **4.70** | | | | **OVERALL TOTAL MEAN** | **4.66** | **Positive** | ## Network Performance Test The website speed test tool was used to evaluate the network performance of an online bookstore management system. The tool performs a full-page speed test and returns the results in requests, content size, and loading time, as well as providing a detailed breakdown of each asset's timings and HTTP headers. The speed test was conducted on desktop and mobile devices, and the results were recorded and analyzed. Tables 3 and 4 show the result after testing the website speed test for desktop and mobile devices about five times repeatedly. The results showed that the website's performance was better when tested on a desktop than on a mobile device. The website speed test results helped identify areas where the system can be improved to ensure optimal performance. Table 3 Website speed test using desktop device | Number of Tests | Website Speed Test Using Desktop Device (S) | | --------------- | ------------------------------------------- | | 1 | 1.6 | | 2 | 1.0 | | 3 | 1.0 | | 4 | 1.0 | | 5 | 1.1 | | Average | **1.14** | Table 4 Website speed test using mobile device | Number of Tests | Website Speed Test Using Mobile Device (S) | | --------------- | ------------------------------------------ | | 1 | 4.9 | | 2 | 3.3 | | 3 | 3.3 | | 4 | 3.3 | | 5 | 2.2 | | Average | **3.4** | # Conclusion This paper successfully presents a solution and the potential use of an online bookstore management system integrated with WhatsApp and google services as a major center for buying and selling books. The system was designed to provide a secure, efficient, and user-friendly platform for customers to purchase and sell books. This approach was created to save time and effort for customers by allowing them to purchase books online. Admins and users have different roles inside the system which the admin may access the system's control panel with a verified login. This website's admin tool allows for the addition, editing, deletion, printing, and replying to messages, as well as managing profiles, books, categories, customers, users, orders, and sales. Meanwhile, users can access profile management, password changing, order cancellation, order repayment, and message sending. The user may also edit their profile and monitor the status of their orders. Request refund capabilities are also available, and they work with google forms and sheets. Meanwhile, WhatsApp technology enhance the communication between users for the transaction that has been made. To measure the effectiveness of the proposed system, usability testing was applied to the proposed system by evaluating the system's performance using a questionnaire based on test cases. Thirty (30) respondents took part in the usability testing. The effectiveness of the proposed system was evaluated, and the majority of the respondents were satisfied, appreciated, and well received with the proposed system. Meanwhile, the website speed test was also used to evaluate the online bookstore management system's network performance on mobile and desktop devices. The result has shown that the website speed for each device was improved when tried repeatedly. Therefore, the outcomes of the system evaluation reveal that users generally approve of all available options. Besides, the overall proposed system was measured to be positively accepted by the users. Hence, it was able to assist, enhance and enrich the buying and selling process of books using the current technology such as web based, WhatsApp and google services. Furthermore, an online bookstore management system that integrates WhatsApp and google services is the most practical, cost-effective, and trustworthy option. In conclusion, an online bookstore management system integrated with WhatsApp and google services is a prime example of how technology can be leveraged to enhance the online shopping experience. The integration of various technologies and the utilization of user-centered design principles have resulted in a system that meets the needs of students and provides a convenient and efficient platform for buying and selling books online. This study contributes to the ongoing discourse on integrating technology into the online retail industry and highlights the potential of an online bookstore management system in improving the online shopping experience for individuals. # Acknowledgements/Funding (DOUBLE-BLIND reviewing. Leave the section as is. Only include Acknowledgements text in the final submission paper) # Conflict of interest statement DOUBLE-BLIND reviewing. Leave the section as is. Only include CONFLICT OF INTERESTS text in the final submission paper) # Authors’ contributions ***(Double Blind Review: Leave this section blank until final camera-ready submission)*:** # References Ajiboye, O. O., Asiru, M. A., & Ogunlade, T. E. (2022). Design and Implementation of an Online Bookstore: The Case of University of Ilorin (UNILORIN) Bookshop. *Ournal of Library Services and Technologies*, *4*(2).Bassil, Y. (2012). A Simulation Model for the Waterfall Software Development Life Cycle. *International Journal of Engineering and Technology*, *2*(5), 1–3.Dr. Merriel, M. C. (2016, November 1). *5 Advantages of Opening an Online Bookstore*. https://connect2local.com/l/159688/c/195193/5-advantages-of-opening-an-online-bookstoreGołąb-Andrzejak, E. (2023). AI-Powered Digital Transformation: Tools, Benefits and Challenges for Marketers – Case Study of LPP. *Procedia Computer Science*, *219*, 397–404. https://doi.org/10.1016/j.procs.2023.01.305Kasim, S., Shahrizan, I., Hafit, H., Shahrizan, I., Abdullah, R., & Alyani, A. (2017). Mobile-Based Management System For Online UTHM Used Goods (Shop1uthm). *Acta Electronica Malaysia (AEM)*, *1*(2), 10–12.Kazim, A. (2017). *A Study of Software Development Life Cycle Process Models*. *8*(1), 15–23.Lara, C. L., & Wassick, J. (2023). The Future of Supply Chain—A Perspective From the Process and Online Retail Industries. *Computers & Chemical Engineering*, *179*, 108401. https://doi.org/10.1016/j.compchemeng.2023.108401Loukili, M., Messaoudi, F., & Ghazi, M. E. (2023). Machine Learning Based Recommender System for E-Commerce. *IAES International Journal of Artificial Intelligence (IJ-AI)*, *12*(4), 1803. https://doi.org/10.11591/ijai.v12.i4.pp1803-1811Othman, Z., Hasnan, M., & Hasnan, N. (2014). *Online Ordering Book System: A case Study in Malaysia Higher Institute*. 621–631. http://stmlportal.net/ictom04/TOC.htmlWalek, B., & Fajmon, P. (2023). A Hybrid Recommender System for an Online Store using A Fuzzy Expert System. *Expert Systems with Applications*, *212*, 118565. https://doi.org/10.1016/j.eswa.2022.118565 1. \* Corresponding author. *E-mail address*: (Add the e-mail in the final camera-ready submission)