Integration between ANT-Logistics and other services using ApiX-Drive

Integration with the connector service ApiX-Drive allows you to create applications in ANT-Logistics using data from other systems. For example, you can transfer requests from your CRM, website, landing page or Google Sheets to ANT-Logistics. It efficiently and easily automates work processes and saves a lot of time.

ApiX-Drive is easy and intuitive to use. And the main feature of the service is that integration settings can be performed independently without programmers. To get to know the service, all new users are given free trial access for 14 days. A special bonus — our partner offers a 10% discount on the first payment using the blackfriday promo code «blackfriday» (offer valid until November 31, 2022).

In this article, we will look at exactly how to set up the integration with ANT-Logistics using ApiX-Drive.

In the ANT-Logistics service, select the menu Service — Settings – Accounting. In the field Type of SP code mapping set the value «text».

Next, we perform the integration settings on the ApiX-Drive website.

We configure the Data Source in ApiX-Drive. Data source is the system from which you want to collect data and transfer information to ANT-Logistics (CRM, website, Google Sheets, etc.). The settings are made in the section Connection. Please  use ApiX-Drive service help. In our case, for example, we used the CRM service SalesDrive as a Data source.

Then we configure the Data Destination. We choose ANT-Logistics. Click the Continue button.

Indicate what action will be performedSelect Import DEX. Click Continue:

Fill in the fields:

  • User — login for entering the ANT-Logistics web service.
  • Password — password for entering the ANT-Logistics web service.

Information will appear that the account has been successfully connected. Click Continue:

Attention! If an inscription appears that the account is configured with an error, check the correctness of the login and password on the ANT-Logistics service.

Then edit settings. We assign the necessary variables from the Data Source to the fields in ANT-Logistics.

Important fields to fill in:

  • The date of the general list of orders – a field with the date of application delivery is assigned;
  • Internal string code of point — the field uniquely identifies the point of sale. If such a code is already in the service, then the order is added to the existing point, if there is no code, a new point is created;
  • Delivery point name – a field is assigned with the name of the delivery point or the client’s name;
  • Address (or Latitude and Longitude) – delivery address (or coordinates of the delivery point);
  • Application number — the field uniquely identifies the application.

Select the necessary values in the field Should orders coordinates (latitude and longitude) be updated or not, if they are imported from the accounting system:

  • Yes – the coordinates will change when loading orders to points that are already in the ANT-Logistics database;
  • No – the coordinates do not change when loading orders to points that are already in the ANT-Logistics database.

To fill in the fields, you can use not only variables from the Data Source, but also System data and manually written data.

The format for filling in fields in ANT-Logistics can be found in the API. Since the format of the fields in the Data Source does not always correspond to the required format of the fields of the Data Destination (ANT-Logistics), you can use the Data formatting in ApiX-Drive. Data formatting easily modifies the data transmitted from the Date source. Mathematical operations functionality is used to perform mathematical operations on the Data source and then transfer these modified data to the Data Destination.

After specifying the necessary fields, click Continue.

Test data will appear on the screen. To upload data to ANT-Logistics, click Send test data to ANT-Logistics. A test application will appear in the ANT-Logistics service on the selected date. If the settings suit us, click Next. If you need to change the settings, click Edit:

Next, we can enable auto update of data. To set up auto update, press the gear and specify the update interval.

To manually unload orders, go to the Connection 1 and click the Manual start 2:

Example of unloaded orders:

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave an application on the ANT-Logistics website.

Route correction. Сhange the order of detour of delivery points

Consider the situation: the route is ready, but you need to first deliver an important order to two stores that are somewhere in the middle of this route.

For this you need:

  • select these two objects,
  • set the order of their visit,
  • fix these stores
  • create a new route.

 For example, first you need to visit TPT 9 and TPT 1, and only after that the rest of the points. To do this, select TPT 9 1, click Move Record 2, and click on the line to which you want to move store (for example, line 2). In the same way, we will move TPT 1 to the third line:

As you can see, stores TPT 9 and TPT 1 have moved to 2nd and 3rd line:

Then, in order for the program to correctly optimize the new route, these points need to be fixed. To do this, you need to select one of the moved points (in this example TPT 9), click on the button in the form of a lock and select Capture the point 3:

This point (as well as all other points that are above the fixed one) will be fixed (highlighted in gray). Now feel free to click «optimize the route». The program will calculate a new optimal route maintaining the order of detour of the fixed delivery points:

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.

Kilometers or money?

 Have you ever wondered which calculation model to choose in ANT-Logisticsper kilometers or per money? In this article, we describe calculation models and their using.

There are two calculation models in ANT-Logistics:

— per km – this value is set by default. The calculation model «per km» is used when the selection of optimal routes must be carried out according to the minimum mileage and route duration.

— per money — is used when the tariffing of cars is applied. The selection of optimal routes in this case is carried out according to the principle: the cheapest route is the most optimal. The «recalculation per money» model is also useed to calculate route profitability.

Let us give you someexamples of the using different calculation models.
Prepare the data for the generating of routes. To do this, load order points using a method that is convenient for you: manually, using an Excel file or API. Then configure the vehicle parameters. In our example, we used two vehicles: Mercedes 1 and Mercedes 2, which had exactly the same parameters (carrying capacity, operating time, etc.), except the route template and tariffs.

Let’s assume that Mercedes 1  is a car owned by the company and its tariff is 9 USD per each kilometer 1.Let’s set the route template: in our case, we designated the start and end of the route with point Warehouse 2

Car Mercedes 2 is a hired transport and its tariff is accorded to the principle: 7 USD per each kilometer, starting from the 10th, and an additional payment is 500 USD for route 1. Set the start and end of the route with the point Office 2.

If you don’t know how to enter tariffs or a route template, we recommend you to read the articles  Vehicles’ Tariffing and Setting up route templates.

Calculation model: recalculation per km

Go to the menu Service-Settings-Accounting 1. In the Calculation model field, select Recalculation per km 2.

Generate a route by ticking the boxes for available vehicles (in our case, these are Mercedes 1 and Mercedes 2). In the Additional parameters we set «Yes» in the field Consider traffic 2

The service generated route using Mercedes 1 and Mercedes 2 vehicles with a mileage of 268.09 km. The expences of this route is 2411.

Calculation model: Recalculation per money

Go to the menu Service-Settings-Accounting 1. In the Calculation model field, select Recalculation per money 2

Then similarly to the previous example, form a route by ticking the boxes for available vehicles (in our case, these are Mercedes 1 and Mercedes 21. In the Additional parameters we set «Yes» in the field Consider traffic 2

The service generated route using Mercedes 1 and Mercedes 2 vehicles with a mileage of 275.71 km. The expences of this route is 2257.

As you can see, the service gives priority to the route where the mileage will be the smallest (not taking into account the tariffing of vehicles and expenses)when calculates per km, and it gives priority to the route with the lowest expenses when calculates for money.

 If you are interested in the described functionality, we are ready to demonstrate its operation, do the necessary settings and provide access to the service.  To do this, leave a request on the ANT-Logistics website.

Table Settings

 You can customize the display of fields on the screen: hide and move fields, change the width of columns in the ANT-Logistics service .

To do this, go to the Directories-Table Settings 1. If you need to display of fields only for yourself, incorporate Mode: apply only for the current user 2 — the icon will be highlighted in pink. If the field display settings are performed for all users of the service (Administrator, Logist, etc.), then this mode does not need to be incorporated. 

Pay attention! The settings for the current user take precedence over the settings for everyone.

Then select the desired line — a sub box will open with a list of available fields and data on their display. Double-click on the line with the required field and in the Editing Record 3 box, make the necessary changes. To move rows, enable Mode: Move record 4. If you need to reset to the table settings to whose you had maded previously, then click the Reset to default button 5

Pay attention! Tables that have saved default settings are highlighted in green. Tables whose have been modified by the user are highlighted in black.

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.