Skip to main content

Data Import

The information extracted from the photo may not be enough to count the specific numbers. Often you need an information on what exactly should be presented in the picture. For example, to calculate OSA, you need to know what products should be in the store. To recognize new products — a catalog of goods.

For the system to calculate the indicators correctly, and the business rules to work, you will need to import the master data.

Master data is a structured information provided by a company. The composition of the master data differs in different projects, and depends on the indicators that need to be read. These may include:

  • stores with attributes — address, name, store chain, management hierarchy, etc.
  • product catalog and information about new products — to update new products;
  • assortment matrix — what products should be presented in the store;
  • planograms — in what order and on what shelves the goods should be;
  • plan for promotional equipment — which pieces of equipment, what type they are, in which stores they should be;
  • information on discounts;
  • price nuances. For example, the presence of a price corridor for regular price tags and for promotions;

Import Methods

The import methods differ in degree of automation. Automatic methods are faster and practically eliminate the human factor. But they require people who will be responsible for the system’s operation on your part.

File

Most often, this is a manually updated spreadsheet. Within the agreed period, you send the Excel file to your account manager by mail. After verification, we upload your file to the database, and the information is updated.

Suitable for small projects. Excel files support up to a million lines per sheet. They can contain information about stores, product catalog, assortment matrix, planogram, discounts, and other data.

Via an Adapter

If you already have a specific sample Excel file, we will configure our adapter, so it correctly recognizes and interprets your file.

This method is suitable for common data types, for example, for a product catalog.

Via portal

Automated option for sending a file to your account manager. You would upload your file using a button on the portal. The database is updated at night. This is done in order not to overlap the current data that users can work with.

This exchange option requires a strict adherence to the format. If the file format is wrong, then it will not be uploaded to the portal until you correct the errors yourself.

Through an external resource

Here you would host the file on your resource, such as an FTP server or the cloud. On our side, a robot would start on a timer. It automatically downloads the files, checks them against the format, and updates the master data at night.

This option is suitable for organizations that need to update data every day. Custom files in XLS, CSI or XML formats.

API

Programming interface, in which you can write data that will be saved. We can also connect to your API, and our back end will download the necessary data on a schedule.

With this method, the human factor is practically excluded, which means there will be fewer errors during the exchange.

Intermediate database

This is a form of an API, where master data is stored in a separate database. The base has a relational structure. For example, a planogram will refer to stores, an assortment matrix will refer to a product catalog, and so on. This method allows you to customize the base logic for the needs of your project.

The import of master data is synchronized. We run a separate database on our side. You write data to it, and our robot reads them on a timer. If the robot sees errors, it will stop downloading until they are fixed.