ERP – Farmica shop
Vision by Cleverville
ERP is intended to make it easier for farmers to have activities that are not directly related to the cultivation and production of the product, emphasizing product promotion and linking short supply chains with the motto “From field to table“. The main features of this ERP relate to the promotion of farmers with their products, and it provides customers with a place where they can safely buy fresh and organically grown products.
How the system is created
ERP consists of three basic modules:
- Concern – Cooperative
- Company – Manufacturers
- Client – Buyer
Concern is logistic and controls module. The main part of this module is routing, which involves creating, updating and servicing routes, and takes of warehousing products. Possibility manage routing type and company administration, insights into statistics and report module.
Company is a module designed for manufacturers (farmers). The main part of this module is a product catalog that is used to create and update products. Also, it includes various functionalities such as production planning, consumption of resources and time spent in various production processes.
Client is a module used to order a product through an application.
How the system works
Company represents main module of ERP system. ERP system may and may not include concern module, so the ERP system workflow is defined depending on the instance.
There are two ways of the ERP workflow, and they depend on the routing:
- First way is to deliver goods on the home address,
- Second way is pick-up at company address
Picture 1. Application workflow
First workflow using three modules (concern , company, client), where more companies are related with one concern and the concern takes care of the delivery process. The products at the warehouse deliver manufacturers, or in agreement with concern to another place. After the customer orders products through the app, the company receives requests that the products ordered should be delivered. After delivery, the products are checked and consolidated, so that a route to the customer can be created. Last step is to create and start a route.
Second workflow uses 2 modules(company, client). When ordering a product, before confirming the order, buyer must choose a place where will he pick up the product and he has two options:
- At company address,
- At agreed delivery point
Highlights of ERP
- Product placement from field to table via a web application
- Insights into buyers and orders,
- Efficiency of invested and received
- Multiple modes of ERP
- Depends on routing type:
- Home address,
- Manufacturer address or an agreed delivery point
- Depends on routing type:
Delivery on home address is a type of routing which includes all three modules. Main feature is the possibility of creating and optimizing routes for delivery. Routing is integrated with ArcGIS system and it supports more than 23 locations per route, also it calculates the cheapest shipping routes
Manufacturer address or an agreed delivery point
Picking up goods on company address is designed to ensure that the system is not dependent only on the routing and that the company is not dependent to be inside the concern. Main feature is that company can have more places where goods could be picked up.
What improvements ERP brings
It contributes to facilitating the business of farmers, promoting and marketing products to end customers. ERP has an impact on sales growth and price management at any time. A big plus of this ERP is the promotion and purchase of products that are of high quality and fresh, and thus affect the health of the customer.
In application we would highlight two important components:
ArcGIS is a geographic information system for working with maps and geographic information.
Because it allows more than 23 locations in route planning also provides the easy implementation of 3D maps and real-time tracking.
PostgreSQL is free, open-source object-relational database management system.
Why PostgreSQL with multi schema
Because it allows us to deploy multiple applications on a single database, reduce maintenance cost and make database organization simpler.
The application contains an option for multi-language. Depending on the integration, desired language can be implemented.
Picture 2. Technology flow
Technologies we used in project:
- Angular 8
- SASS (CSS)
- REST framework,
- PostgreSQL (multi-schemas)