Desarrollo de un sistema web de rastreo (tracking) para pedidos y exportaciones en la empresa Ecuadorquideas.

Abstract

A post-pandemic effect of COVID-19 that is here to stay, aggravated by non-presence, has been a large increase in the demand for services and products virtually. E-commerce was no exception, with a huge demand for products from consumers in virtual stores. The medium and small companies, not having a scalable order management logistics, were taken by surprise by this unusual number of orders and many of them collapsed, mainly the SMEs that due to their condition of small companies with limited resources usually do not know how to count on a computer system that serves as support for transactions, actions and processes that the company must develop on a day-to-day basis. The over-demand of products has also compromised air cargo services, delaying the processes of reception and delivery of cargo. Cargo airlines such as Copa and KLM have had to double their cargo capacity to meet the current volume demand. Providing a personalized and quality customer service translates into a good user experience and a positive recommendation in the future, which is a fundamental point that companies should implement when offering the service of an online store or when engaging in some type of e-commerce. Despite the popularity of acquiring products online today there are certain criteria that make end customers do not buy in these stores, one of these criteria is the little or no access to information from the company on the management of orders, for the end customer is very important that there is presence of the company on the web and have a channel of information where you can access and track your purchase. Ecuadorquideas is an Ecuadorian company that exports plants to various countries. The company does not have an integrated computer system for managing and tracking orders and exports, the company carries out these processes manually. By not having a computer system to help with the management of orders in a company, it may be prone to failures in the export logistics chain. The technological proposal of this work is focused on developing a prototype of a Web system for tracking orders and exports in the company Ecuadorquideas, using the XP methodology for the optimization of logistic processes and the improvement of the customer's experience. By using an XP methodology, the level of difficulty of the development is reduced and allows delivering a functional system in a very short development time. For the planning phase, meetings were held with top management and personnel related to the company's order management, which allowed the elicitation of requirements, a schedule was managed, tools and technologies to be used in the development of the system were selected, and several actions proposed by the XP methodology were taken. In the modeling or design phase, the user stories, the database model and the prototyping of the user interfaces, among other activities, were carried out. In the development or coding phase, the integrated development environment (IDE) Visual Studio Code was used, Python was used for BACK-END and Bootstrap version 5 was used for FRONT-END, for cloud hosting, Amazon server was used through a VPS, additionally, Vestacp was used to instantiate the web page for administrative management. Subsequently, an evaluation of the quality of the system was carried out taking as a reference the parameters of the standards: ISO/IEC-9126 using a questionnaire and ISO/EC-25010 using SEO tools, the evaluation yielded the following results, efficiency (80%-77%), functionality (99% and 80%), accessibility (75% and 73%) usability (93% and 85%) and portability (61% and 60%). Finally, the results obtained support the quality of the system, which is fully functional and meets the needs for which it was developed.