Implementation of an e-Commerce System for the Automation and Improvement of Commercial Management at a Business Level

At present micro and small businesses engaged in the production and marketing of products and have a single means of sale, whether stalls or physical stores, have been affected by the current crisis that is happening due to the pandemic, which came in early 2020 to Europe and different countries in Latin America, which is causing terrible damage to the economy of enterprises, since it does not have a means of virtual sales, where they can offer and market their products so that trade continues to operate during the pandemic. In this way, we designed a prototype e-commerce system meeting the requirements required by the organizations. Where it was based on the Scrum methodology as an agile development framework for the realization of the project. The use of the Marvel design tool allowed the creation of web platform prototypes. Obtaining as a result, prototypes according to an e-commerce system complying with the development procedures established by the Scrum team, which gives you a novel proposal and a productive approach to start implementing e-commerce within the sales processes of each business area. Therefore, this e-commerce system prototype proposal can be implemented by the different micro companies that wish to have a new online sales method and improve their commercial area process, allowing the increase of their client portfolio, as well as their production. Keywords—Agile development; e-commerce; scrum methodology; prototype; system


I. INTRODUCTION
Currently, e-commerce is becoming a technological solution for the various problems that arise within companies in relation to their sales processes or business management. e-Commerce is a growing phenomenon in Latin America and the world, so the study of its technological acceptance is high [1]. Having a virtual business tool favors and gives you a series of advantages such as: having access from any geographical area, being accessible 24 hours a day, having a favorable increase of customers and start to be competitive in the market, having information and control of customers accessing the system, in addition to reducing costs and minimizing service times and product deliveries.
For small and micro-enterprises, the use of the Internet and the development of e-commerce is an opportunity because it allows them to increase their capacity to disseminate products, make distance sales and make their cost structure more flexible [2]. e-Commerce drives advances in security and payment systems, marketing strategies and advertising, media distribution, business-to-business commerce and retailing [3]. People today use e-commerce constantly to make purchases of all kinds and rely on the security they offer when making an online transaction or payment. Businesses also have the ability to be more connected with their shoppers [4].
With the development of the Internet and other technologies, the efficiency of transactions will constantly improve [5]. Therefore, companies need to implement an e-commerce system to improve and automate the commercial management and can undertake a new business direction and provide a solution to their problems. It requires a system that provides a catalog of the company's products, has a reliable database to store the information that is generated from a customer purchase. All this opens you to have new sales opportunities and obtain new customers and therefore more production and sales. However, you will be able to manage a record of customers and sales made, have updated products and also with an adequate control.
The objective of the research work is to implement an e-commerce system that allows to automate and improve the processes of commercial management at the enterprise level, where companies have and count with new business opportunities.
The structure of the article consists of five sections: in Section II is the literature review, Section III details the methodology of the research study, in Section IV the case study will be visualized, in Section V, will consist of the results and discussions; finally in Section VI the conclusions are mentioned.

II. REVIEW LITERATURE
The development of technology and information has spread to various sectors, especially to the sector of product marketing and product transactions. The presence of e-commerce brings new changes in the world of production and business marketing [6]. This situation undoubtedly contributes to the optimization of processes and expands opportunities for companies in ecommerce. Clear and concise communication between the company and the consumer provides security and allows the identification of needs that, when met in a timely manner, enhance service and efficiency in the management and design of information [7]. The new information and communication technologies have revolutionized at the international level broad sectors of knowledge and human activities, fostering the emergence of new ways of doing business [8]. In this regard, it should be noted that the implementation of e-commerce and payment by credit card or cell phone via the Internet is vital for Guinea-Bissau's development.
Globalization requires countries and producers to innovate their ways of marketing in order to remain competitive in the market [9]. One alternative is to incorporate producers and micro and medium-sized enterprises into e-commerce successfully and analyze the results they have obtained by applying it, with the objective of improving their income. To this end, it is necessary to formulate models for the adoption of this form of business, which will allow agroindustrial companies to incorporate it into their daily activities so that they can be more productive. e-Commerce in the level of sales of micro, small and medium-sized enterprises (MSMEs) of some key sectors of the city of Ibagué (Industry, Commerce and Services), for which we seek to know the current status of e-commerce and its importance, the causes of its use and non-use, and the positioning it has in the strategic plans of these organizations [10].

A. Scrum
The Scrum methodology is an iterative process and evokes moments of feedback in a systematic way [11]. Accordingly, it was decided to develop the research work with the Scrum methodology. The technical framework of scrum, is formed by a set of practices and rules that respond to the following agile development principles: Evolutionary product management, instead of the traditional or predictive [12].
Scrum is an agile, lightweight framework that provides steps to manage and control the software and product development process [13]. Quality of the result based on the tacit knowledge of people, rather than on the explicit knowledge of the processes and technology used. Incremental development strategy through iterations (Sprint). scrum methodology is much more than group work. Therefore, it is encouraged to work according to their personal interests [14]. As shown in Fig. 1, the Scrum process scheme was made, which under its work techniques will execute the research development through the daylin scrum, retrospective, sprint review and taking into account the creation of the product backlog, sprint backlog and finally have a release.
1) Phase 1: Start: In this first phase, the project objectives will be analyzed to obtain product requirements and from there create the user stories.
2) Phase 2: Planning: In this phase the planning of the deliverables (Sprint) will be established, where sets of tasks to be performed by the development team will be established and meetings will be held to determine and discuss.

3) Phase 3: Implementation:
The sprint is planned by means of a GANT diagram, where start and end dates of its development are established. In this phase, sprint retrospective meetings will be held to evaluate and discuss the sprint performed, taking into account the internal evaluation of the team's work.

5) Phase 5: Launch:
This phase is the final part of the whole process where the complete and functional deliverables are reported for release.

B. Prototype Tool
The development of prototypes is the design vision of the system and how it is required to implement it in the future applying the requirements established by the client, that is why the following software will be used for the development.

1) Marvel:
This tool allows you to develop or shape your design ideas through its work platform and generate design prototypes quickly.

IV. CASE STUDY
In this section the research study was developed applying the methodology processes, fulfilling all the development of the prototype by executing the phases mentioned above.
1) Phase 1: Start: a) Requirements: The requirements are part of the requirements established by the product owner who is in charge of collecting as much information as possible about how the system is intended to work and how it is visualized. Table I, shows the requirements that were made and that are functional. The system must be able to display the company's product catalog 2 The system should allow you to manage the shopping cart, add products, delete products and cancel shopping cart 3 The system must allow the customer to purchase the products added to the shopping cart 4 The System must allow to register the information of the clients as natural person or company 5 The system shall allow adding new products, modifying and deleting existing products 6 The system must allow to display a sales report. The data to be displayed are: date, sale number, customer name, product code, product name, product quantity, unit price, total Soles (IJACSA) International Journal of Advanced Computer Science and Applications, Vol. 12, No. 1, 2021 b) Backlog Product: The backlog is the ordered list of all the requirements previously established by the customer. In Table II, we observe the functional user stories and also the estimation and priority that helps to evaluate each user story. c) Estimate -Planning Poker: The planning poker was used to estimate the user stories and determine the effort it will take to develop each one, depending on its difficulty, which is why it was decided to use this technique. As shown in Table  III. 2) Phase 2: Planning: a) Sprint Planning: The necessary activities were carried out to develop a new version of the product (Increment) of functional type, according to the specifications for the Sprint [15]. It was determined what will be the Sprint (Deliverables), by means of a tactical planning of work it was decided that it will be 4 sprint, for this work the sprint counted with two stories of users fully identified previously, as it is shown in Table IV. b) Product Roadmap: In this section the Product Roadmap is established, which is a high-level plan that allows us to see how our product will evolve by launching the deliverables that were established, it is like our roadmap, which allows you to describe how to achieve the objectives or vision of the product to be delivered. All this can be seen in Fig. 2.

3) Phase 3: Implementation:
a) Sprint Planning Meeting: In this section the development of the tasks was organized based on a sprint chronogram where the dates of each deliverable were determined. It will help the work team to maintain an order when developing the H1 As a user, I want to see the catalog of the products in the system H2 As a user, As a user, I want to see the product catalog in the system 1 Sprint 2 H3 As a user, I want to register to the system as a natural person or company H4 As a user, I want to enter the system through a login 2 Sprint 3 H5 As an administrator, I want to enter the administrator module through a login H6 As an administrator, I want to add new products, modify and delete existing products 3 Sprint 4 H7 As an area manager, I would like to see the sales reports for the day.

4) Phase 4: Review and Retrospective:
a) Daily Scrum: All the people involved in the project will meet daily to review the sprint and determine if there is any inconvenience that can be improved or solved. The people involved in the meetings rotated daily every day, with the sole purpose of ensuring that the objective was met and developed normally and without problems. They analyzed what was done wrong, what was done right and what difficulties were encountered that did not allow the project to continue as planned [16].

5) Phase 5: Launch:
www.ijacsa.thesai.org It is based on the first deliverable of the system, where the company's product catalog is displayed, and apart from that, the shopping cart is displayed, which will serve to complete the system's purchase flow. These two are important functionalities for the management of the e-Commerce, that is why it was determined to be the first deliverable because it provides value and functionality to the system, as shown in Fig. 4, the user will be able to visualize the product catalog, then the product will have a main window, where the main characteristics will be shown and also the item can be added to the cart, all this is shown in Fig. 5. Then, we have the shopping cart interface where it will detail how the purchase will be made and what will be the type of payment to be made, as shown in Fig. 6. b) Sprint 2: This is the second deliverable of the system, it consists of two interfaces that will be used for the user to log in to the system after he/she has registered, therefore, an interface for the creation of new users was also created, as shown in Fig. 7. The user registration prototype was also added, where new clients who are interested in having some interaction with the web system can be registered (Fig.  8). c) Sprint 3: It is the third deliverable of the system, it is about the interfaces to the access of the administrator module as shown in Fig. 9, so that the administrator can enter the module, before he must log in, previously registered in the system and have the user data registered in the database, then, he must fill in the fields shown in the interface of email and password, then he will be directed to the administrator module shown in Fig. 10. Where he can manage the products according to the criteria of the company, in sum, he will have administrator permissions to different actions such as deleting, viewing and updating the product. d) Sprint 4: It is the fourth deliverable of the system, the interface was made to show all the reports of the sales that are made daily, where the area manager can view the items that were part of the purchase of customers, also showing the name and image of the product that was purchased. The area manager can also perform different actions on the product, as shown in Fig. 11.

A. About the Case Study
The main objective of the study is to develop an ecommerce web system, which is capable of allowing companies to have new sales opportunities through internet com- It is a good way to take advantage of new technologies and be able to solve the problems that arise in organizations. The development of the prototypes presented was elaborated by a tool called Marvel, it is a web tool that allows you to transform your design ideas into digital products, which gives you a series of components that facilitate the creation of it, apart from being unique. Eight prototypes were made within this tool, each one with different functionalities which will be 1) Sprint 1: Sprint 1, has the development of 3 prototypes which are: Product catalog prototype, is the face of the web system, not to say, the presentation and the first thing the user will see, therefore, components were implemented which will make it look interesting and novel. The shopping cart prototype was developed with the functionality to start the purchase flow starting from the product selection. The shopping cart prototype is the final part of the flow, where the payment method and product details are detailed. 2) Sprint 2: Sprint 2, has developed 2 prototypes which are: User Registration Prototype which was determined to create this interface for the registration of persons or companies that wish to register to the system and can have records within it. A basic form was added with three fields to fill out and a button to confirm the registration. Prototype of Login to the system, is where the user will log in that allows you to have access to more features and to buy within the page, has two fields of email and password.
3) Sprint 3: Sprint 3 has developed 2 prototypes that are part of the administrator page and does not involve the client: Administrator Module Login Prototype, which has a form with two text fields and a Login button. Product Management Prototype, which is the administrator module. This interface shows details of the products published in the e-Commerce which can be modified, deleted, updated, as well as adding new products. 4) Sprint 4: Sprint 4 has 1 development prototype, which is the Sales Registration Prototype. A field was created where the daily sales reports are shown, where the products are detailed with their respective images and status of the items, in addition, actions were added so that the area manager has access to modify any sale if necessary.
B. About the Methodology 1) Advantages: One of the advantages of Scrum is to provide organization and collaborative work of the team members and is adaptable to the changes that can be generated in the construction of the project [18]. As well as having deliverables periodically and not at the end of the project [19].
2) Disadvantages: One of the disadvantages of Scrum is that it requires people capable of managing large projects and who have adequate academic training. Another negative circumstance is that this methodology is misused in development teams, as it does not comply with the values and principles that Scrum proposes [18].

3) Comparisons:
The agile methodology that we have used for the development of the project is Scrum, one of the agile methodologies that is currently being widely used and consequently is becoming one of the best, bringing benefits to companies, in addition to the fact that Scrum is capable of managing difficult projects. Scrum is basically an agile and lightweight framework that provides the steps to manage and control the process of software and product development . This is why we are going to make a comparison with a traditional Cascade methodology. Cascade makes a procedural and rigid evaluation, which sometimes does not allow the interaction between processes and techniques, because of its rigorous disposition, does not allow an adequate flow of information that allows to know in an integral way the needs of the client [20]. With everything mentioned above in Table V, the comparison of these two methodologies already mentioned was made, where the important characteristics of each one were named.

VI. CONCLUSION AND FUTURE WORK
Finally, in this research, the whole prototyping of the interfaces of the web system that was developed to improve the commercial management, as well as to have new sales opportunities and to face the problems that the company is facing. And to do it now by means of the electronic commerce that is a window that the new technologies allow you to use. All this was carried out thanks to the Marvel tool that has interesting mechanisms and components that made the design ideas take shape as they are, and can be visualized in a realistic way. The methodology used for the good development of the web system was Scrum, which allowed us to carry out the project in a more orderly and efficient way at the time of its development. In my article, as future work, I recommend that the prototypes presented and designed be implemented and put into development. Where micro and small companies have the opportunity to undertake and have a new sales method for their business.