Case ARTWINERY

CRM setup for a sparkling wine producer

ARTWINERY is the largest producer of sparkling wines in Eastern Europe. The entire production cycle at Artwinery is located at a depth of more than 72 metres in underground gypsum tunnels, which maintain unique microclimatic conditions all year round – constant temperature and humidity.
The production capacity of the enterprise is 25 million bottles of sparkling wine per year.

icon

Year

2021

icon

Project duration

5 months

icon

Technical support

from 2021 to the present

icon

Specialists involved

5 persons

icon

Year

2021

icon

Project duration

5 months

icon

Technical support

from 2021 to the present

icon

Specialists involved

5 persons

artwinery

Challenges

Illustration
    icon
    Long order processing time.
    icon
    A lot of lost information regarding stock and inventory.
    icon
    Ineffective communication with staff.
    icon
    Scattered documents in various storages.
    icon
    No timely update of information for customers due to the need to. enter all data manually.

Solutions

    icon
    Implement CRM. It will allow organisation of online sales through the website.
    icon
    Connect with CRM messengers, SMS notification, cash register software, delivery service.
    icon
    Synchronise data between the site, CRM and ERP.
artwinery

Project Details

The project can be divided into 3 main steps:

Step 1. Basic system settings

    icon
    Setting up access rights;
    icon
    Setting up the Order Life Cycle business process;
    icon
    Setting up the REST API;
    icon
    Setting up the RabbitMQ queue server;
    icon
    Filling up directories;
    icon
    Implementation of the loyalty program;
    icon
    Finalisation of the entities "Deal", "Contact";
    icon
    Implementation of the characteristics directory and the region directory;
    icon
    Implementation of the entities "Product", "Price list", "Warehouse";
    icon
    Integration with ERP;
    icon
    Import of customers/orders;
    icon
    Installing and configuring modules of postal services "Nova Poshta" and "Ukrposhta".

Project Details

The project can be divided into 3 main steps:

Step 1. Basic system settings

    icon
    Setting up access rights;
    icon
    Setting up the Order Life Cycle business process;
    icon
    Setting up the REST API;
    icon
    Setting up the RabbitMQ queue server;
    icon
    Filling up directories;
    icon
    Implementation of the loyalty program;
    icon
    Finalisation of the entities "Deal", "Contact";
    icon
    Implementation of the characteristics directory and the region directory;
    icon
    Implementation of the entities "Product", "Price list", "Warehouse";
    icon
    Integration with ERP;
    icon
    Import of customers/orders;
    icon
    Installing and configuring modules of postal services "Nova Poshta" and "Ukrposhta".

Automation of the Order Life Cycle business process

To automate order processing by managers, we set up the Order Life Cycle business process using the code. The business process has several scenarios depending on the type of delivery and the availability of the required product in the warehouses.When working with a Deal, CRM processes data on the quantity of goods in warehouses. If the required quantity is not in the nearest warehouse, CRM informs the operator about it and also shows the warehouse where the required quantity is available.

Illustration

Automation of the Order Life Cycle business process

To automate order processing by managers, we set up the Order Life Cycle business process using the code. The business process has several scenarios depending on the type of delivery and the availability of the required product in the warehouses.When working with a Deal, CRM processes data on the quantity of goods in warehouses. If the required quantity is not in the nearest warehouse, CRM informs the operator about it and also shows the warehouse where the required quantity is available.

Illustration

ERP and CRM integration

The RabbitMQ queue server is used for integration with the ERP system. Data from the ERP is uploaded to the server daily and then to the CRM and website.

The data we get from ERP:

    icon
    Data on the product list;
    icon
    Guide to possible product characteristics;
    icon
    Price list;
    icon
    Data on inventory by warehouse (the number of units of each product for each warehouse).
Illustration

ERP and CRM integration

The RabbitMQ queue server is used for integration with the ERP system. Data from the ERP is uploaded to the server daily and then to the CRM and website.

The data we get from ERP:

    icon
    Data on the product list;
    icon
    Guide to possible product characteristics;
    icon
    Price list;
    icon
    Data on inventory by warehouse (the number of units of each product for each warehouse).
Illustration

Step 2. Integrations to expand the functionality

The key settings of the second stage are the following:

    icon
    Integration with WEB;
    icon
    Integration with the iPOST postal service;
    icon
    Adding the ability to set a payment waiting period in CRM;
    icon
    Setting up open lines;
    icon
    Setting up SMS campaigns.

Step 2. Integrations to expand the functionality

The key settings of the second stage are the following:

    icon
    Integration with WEB;
    icon
    Integration with the iPOST postal service;
    icon
    Adding the ability to set a payment waiting period in CRM;
    icon
    Setting up open lines;
    icon
    Setting up SMS campaigns.

Step 3. Integration with R-Keeper

Data is transferred from CRM to the website via the API in json format. The interface of the Deal provides the ability to transfer the order composition through an API request to the R-Keeper system. Based on the received data, R-Keeper generates receipts for customers. This functionality is used to sell goods in bars and other points of sale, not through the website.

Illustration

Step 3. Integration with R-Keeper

Data is transferred from CRM to the website via the API in json format. The interface of the Deal provides the ability to transfer the order composition through an API request to the R-Keeper system. Based on the received data, R-Keeper generates receipts for customers. This functionality is used to sell goods in bars and other points of sale, not through the website.

Illustration

The implementation of CRM made it possible to organise online sales through the website, as previously goods were not sold through the website. Website development and CRM implementation were carried out in parallel.

Results

A website was created as a new sales channel, implemented data synchronisation between website, CRM, and ERP, and as a result:

    icon
    Sales increased.
    icon
    Order processing speed tripled.
    icon
    Due to the emergence of a personal account with up-to-date information, the level of satisfaction of regular customers increased.
    icon
    The unified information space significantly simplified communications within the company and with customers.
    icon
    The customer base grew.

Results

A website was created as a new sales channel, implemented data synchronisation between website, CRM, and ERP, and as a result:

    icon
    Sales increased.
    icon
    Order processing speed tripled.
    icon
    Due to the emergence of a personal account with up-to-date information, the level of satisfaction of regular customers increased.
    icon
    The unified information space significantly simplified communications within the company and with customers.
    icon
    The customer base grew.
Illustration
Optimir
agro
SPlus
tiyo
Illustration
pastrans
pastrans
spaitach
kompas
kompas
Sunway
modern
Illustration

Julia Andrusiak

Account Director

+38 050 700 75 72

latigid.ogeretla%40kaysurdna.y

We work with you to find the best solution for the business challenges you face.

Book a free consultation

Let’s work together for great results

Thank you!

We will contact you shortly

Can't send form.

Please try again later.