Flat CSV Report

So far, Dealavo reports had a structure where each row represented a single offer with selected attributes and a price history from a specified period in subsequent columns. This meant that a single glance could provide a lot of information about one offer. To facilitate integration with external systems, we have introduced a solution where one row represents one offer with one price.

Where to find the flat CSV report in Dealavo:

You can find flat CSV reports in your account under the Files tab, in the flat_reports folder. Inside, there is a history subfolder and the file current_dealavo_flat_prices.csv:

File current_dealavo_flat_prices.csv

The current_dealavo_flat_prices.csv file contains the current prices of all offers associated with your account. Each row represents a different offer with the most up-to-date collected price, even if it is from a few days ago. By default, this report will also show unavailable offers - for example, offers that a given seller no longer sells. If you want to disable the display of such offers, please contact your account manager.

History folder

The history folder contains files with offers for which we managed to update the price in a given update. The date and time of the update initiation are included in the file name. If you have updates enabled only for a selected group of products at a specific time, only that selected part will appear in the file. Similarly, if we fail to collect data on a given offer (because, for example, it has been withdrawn by the seller), such an offer will not be included in the file.

Access via API

You can download the flat CSV report via API. If you need to analyze files from several updates simultaneously, you can use one of the provided links.

Examples of API link templates with specified accesses:

The newest file:

https://app.dealavo.com/files/dealavo_flat_prices.csv?account_id=1234&api_key=1234

The file gathered from last 2 days:

https://app.dealavo.com/files/dealavo_flat_prices.csv?account_id=1234&api_key=1234&days=2