Client need

Comercial Casa Jerusalem is a small home supplies retail business registered in El Salvador with 5 employees, selling around 500 products and 100 inventory transactions monthly.

The company needs a platform to reference products and manage inventory transactions. The goal is to digitize the company’s inventory management for accounting purposes, in order to comply with local legislation. The system must be simple to use and adapted to the needs of the local business. A second medium-term objective is to start a website with online sales.

Methodology

First of all, research existing solutions on the market for online commerce and inventory management. After some research of existing solutions in the market, I concluded that most systems are heavy and have many complex processes, which is not adapted to a small company with no qualified technical resources. I decided to start from an open-source project Veniqa, which offers product referencing features for online sales. I adapted the back office system of Veniqa and added the necessary features:

• Inventory management according to the specific process of the company.
• Accounting report in CSV format.

Deliverable

Web application secured with email and password access. The project is structured as follows:

• Backoffice API in Node.js, Express.js, MongoDB, AWS S3 buckets.
• Management backoffice web application in Vue.js with Vuex.
• Integration with Github Actions to build a docker image for each project.
• Hosting on AWS Lightsail Containers