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, website screens, bottles, champagne, wine

Challenges

logo Artwinery
    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, bottles, champagne, wine, logo, pearls

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.

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:

    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).

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:

    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).

artwinery, website screens, bottles, champagne, wine

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.

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:

    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.

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.