ERP - Farmica shop

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

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

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

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

Application workflow

Application workflow

Picture 1. Application workflow

First 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

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
    • Statistics,
    • 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

Home address

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.

About application

In application we would highlight two important components:

  • ArcGIS
    • Locations, 
    • Places,
    • Routing,
    • 3D Maps,
    • Real-Time tracking
  • PostgreSQL with multi schema

ArcGIS

ArcGIS is a geographic information system for working with maps and geographic information.

Why ArcGIS?

Because it allows more than 23 locations in route planning also provides the easy implementation of 3D maps and real-time tracking.

PostgreSQL

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.

Multi-language

The application contains an option for multi-language. Depending on the integration, desired language can be implemented.

Application design

Technology flow

Picture 2. Technology flow

About technologies

Technologies we used in project:

  • Front-end: 
    • Angular 8
    • SASS (CSS)
  • Back-end: 
    • Django, 
    • REST framework,
    • Swagger
  • Database: 
    • PostgreSQL (multi-schemas) 
  • Integrations: 
    • ArcGIS
  • Automatization:
    • Jenkins,
    • GitLab,
    • Docker

Go to Farmica shop

Recent Posts
Categories