Desarrollo de sistema de gestión de venta de licores para la licorería la nenita : Backend.

Abstract

Liquor Store 'La Nenita' is a physical establishment with over three years of experience in the sale of alcoholic beverages located in Santa Rosa de Cuzubamba. It was identified that the order process was carried out through social media, phone calls, and manual note-taking, resulting in inefficiency due to limited administrator availability and the risk of information loss and duplication. Additionally, the absence of a virtual catalog to showcase their wide range of products to customers was highlighted. To provide a technological solution to the aforementioned issue, this Curricular Integration Work focuses on the development and deployment of a backend for liquor sales management for 'La Nenita' liquor store. This server-side solution interfaces with an existing frontend, thus providing a robust infrastructure that enables customers to browse and make purchases through a virtual catalog and a shopping cart. Through this integration, the administrator gains better inventory control and more efficient order management, enhancing business competitiveness and market positioning. Furthermore, the customer experience is improved, as they can place orders from the comfort of their homes, providing a more enjoyable shopping experience. The structure of this document is organized as follows: first, the business-related issue is identified, and based on that, the objectives, scope, and relevant theoretical framework are established. Next, the implementation of the methodology used, in this case, Scrum, is detailed along with the design of the database and its interaction with the FastAPI Framework and PostgreSQL database. Moreover, the use of relevant tools and libraries for backend development is described. Subsequently, a detailed description of each task developed in each module is provided, along with the results obtained in each iteration (Sprint). Finally, the conclusions and recommendations drawn throughout the development and production deployment process of this project are presented.