Post cover image

ERP – Farmica shop

Vision by Cleverville

In a digital marketing age with increased aim at customer convenience and environmentally conscious distribution, many businesses rely on enterprise resource planning (ERP) for efficient business management. Likewise, it is important for farmers to have access to these tools for managing, promoting, and distributing their products directly to the hands of the customer. This ERP makes it possible, linking short supply chains with the motto “From Field to Table.”

How the system is created

ERP consists of three basic modules:

  • Concern – Cooperative
  • Company – Manufacturers
  • Client – Buyer

Concern

Concern is the logistics and control module mainly focused on product routing by creating and updating routes and managing warehousing receiving. It can also integrate company administration insights and statistics and reports modules for determining route.

Company

Company is the module designed for the manufacturers’ production planning through a continuously update inventory catalog. Functionalities also include resource consumption and time management across the various tasks.

Client

The client module is designed for the market, allowing buyers to order products through an application.

How the system works

ERP depends on which modules are needed to produce a streamlined workflow. The central and mandatory module of the ERP system is company, the manufacturer. The concern module, routing, is not applicable for all companies and may or may not be included.

There are two types of ERP workflow depending on whether concern is included:

  • Product delivery to client address (concern, company, client)
  • Product pickup at company address (company, client)

Application workflow

Application flow Picture 1. Application flow

First workflow

The first workflow, using three modules (concern, company, client), relates several companies with one concern to maximize efficiency and environmental sustainability. After clients place orders through the app, the company receives requests to deliver the products to a warehouse, or in agreement with concern, another location. From there, the products are checked and consolidated and the module to creates an efficient route to the customer.

Second workflow

The second workflow includes two modules (company, client) When ordering through the app, clients are prompted to select a pick up location at either the manufacturing company address or an agreed delivery point.

  • 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:
      • Client home address
      • Manufacturer address or an agreed delivery point

What improvements ERP brings

ERP has an impact on sales growth and price management at any time. It contributes to facilitating the business of farmers through promoting and marketing products to customers. A big plus of this promotion is allowing customers to easily purchase high quality and fresh products, affecting both their health and the environment!

Application Methods and Design

We highlight two important components of the application:

  • 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 over 23 locations in route planning while providing straightforward implementation of 3D maps and real-time tracking.

PostgreSQL

PostgreSQL is a free, open-source, object-relational database management system.

Why PostgreSQL with multi schema

Because it allows deployment of multiple applications on a single database, thereby reducing maintenance costs and simplifying database organization.

Multi-language

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