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.

Year

2021

Project duration

5 months

Technical support

from 2021 to the present

Specialists involved

5 persons

Year

2021

Project duration

5 months

Technical support

from 2021 to the present

Specialists involved

5 persons

artwinery, website screens, bottles, champagne, wine

Challenges

logo Artwinery

    Long order processing time.

    A lot of lost information regarding stock and inventory.

    Ineffective communication with staff.

    Scattered documents in various storages.

    No timely update of information for customers due to the need to. enter all data manually.

Solutions

    Implement CRM. It will allow organisation of online sales through the website.

    Connect with CRM messengers, SMS notification, cash register software, delivery service.

    Synchronise data between the site, CRM and ERP.

artwinery, bottles, champagne, wine, logo, pearls

Project Details

The project can be divided into 3 main steps:

Step 1. Basic system settings

    Setting up access rights;

    Setting up the Order Life Cycle business process;

    Setting up the REST API;

    Setting up the RabbitMQ queue server;

    Filling up directories;

    Implementation of the loyalty program;

    Finalisation of the entities "Deal", "Contact";

    Implementation of the characteristics directory and the region directory;

    Implementation of the entities "Product", "Price list", "Warehouse";

    Integration with ERP;

    Import of customers/orders;

    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

    Setting up access rights;

    Setting up the Order Life Cycle business process;

    Setting up the REST API;

    Setting up the RabbitMQ queue server;

    Filling up directories;

    Implementation of the loyalty program;

    Finalisation of the entities "Deal", "Contact";

    Implementation of the characteristics directory and the region directory;

    Implementation of the entities "Product", "Price list", "Warehouse";

    Integration with ERP;

    Import of customers/orders;

    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.

artwinery, website screens, bottles, champagne, wine

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.

artwinery, website screens, bottles, champagne, wine

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:

    Data on the product list;

    Guide to possible product characteristics;

    Price list;

    Data on inventory by warehouse (the number of units of each product for each warehouse).

artwinery, website screens, bottles, champagne, wine

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:

    Data on the product list;

    Guide to possible product characteristics;

    Price list;

    Data on inventory by warehouse (the number of units of each product for each warehouse).

artwinery, website screens, bottles, champagne, wine

Step 2. Integrations to expand the functionality

The key settings of the second stage are the following:

    Integration with WEB;

    Integration with the iPOST postal service;

    Adding the ability to set a payment waiting period in CRM;

    Setting up open lines;

    Setting up SMS campaigns.

Step 2. Integrations to expand the functionality

The key settings of the second stage are the following:

    Integration with WEB;

    Integration with the iPOST postal service;

    Adding the ability to set a payment waiting period in CRM;

    Setting up open lines;

    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.

artwinery, website screens, bottles, champagne, wine

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.

artwinery, website screens, bottles, champagne, wine

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:

    Sales increased.

    Order processing speed tripled.

    Due to the emergence of a personal account with up-to-date information, the level of satisfaction of regular customers increased.

    The unified information space significantly simplified communications within the company and with customers.

    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:

    Sales increased.

    Order processing speed tripled.

    Due to the emergence of a personal account with up-to-date information, the level of satisfaction of regular customers increased.

    The unified information space significantly simplified communications within the company and with customers.

    The customer base grew.

logo Artwinery
Logo Optimir
logo agro
logo Symmetry Plus
logo tiyo
Logo AS центр відновлення зору Анатолія Совви
logo pastrans
logo spaitach
Logo Keystone Equities LLC
Logo kompas
Logo SunwaySamui
logo modern expo
logo STAINLESSSWIM
logo Tutor Job
Olena Melnychuk

Olena Melnychuk

Chief Operating Officer

+38 067 700 75 72

latigid.ogeretla%40liam

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.