Downloading the recommendations file via the API

Repricing recommendations generated in the Dynamic Pricing module are also available via API.

Available file formats:

• CSV

• XML

• XLSX

• JSON

Recommended prices are provided for each product and for every monitored channel with an active repricing rule. The file uses your account’s currency.

Access to files

Files can be generated in different formats via permanent links. Each link always returns the latest version in that format.

• Excel file (XLSX): http://app.dealavo.com/files/repricing/repricing.xlsx?account_id=[Your account ID]&api_key=[Your API key]

• CSV file: https://app.dealavo.com/files/repricing/repricing.csv?account_id=[Your account ID]&api_key=[Your API key]

• XML file: https://app.dealavo.com/files/repricing/repricing.xml?account_id=[Your account ID]&api_key=[Your API key]

Filling in parameters

You can find your account ID and API key in the My Account tab, Public API section. Insert them in the places indicated in the links above.

Consistency with the Files tab

Files downloaded via the API are identical to those available in the Files tab in the application.

Downloaded files can be found in the history folder.

The JSON file is available in the api folder.

File characteristics

Generation mode

• XML, CSV and XLSX - generated on demand with each download through the API at a dedicated URL, for example: http://app.dealavo.com/files/repricing/repricing.xlsx?account_id=[Your account ID]&api_key=[Your API key]. If changes have been made in repricing, they will be visible immediately.

• JSON - generated when prices are updated. To ensure the data is up to date, wait until the next price update on your account.

Products without recommendations

• XML - contains only products with price recommendations.

• XLSX, CSV and JSON - contain all monitored products. For products without recommendations, fields remain empty.

Structure and fields

• Product identifier - we display the item ID exactly as uploaded to Dealavo.

• For each product we present a separate price recommendation for each source selected in the Dynamic Pricing module.

Sample XML file structure

Sample columns in XLSX (selected)

• SKU ID (as in the feed file uploaded to Dealavo)

• Price recommendation for each channel

• Difference between the current and recommended price - shown as both amount and percentage

Sample columns in CSV (selected)

• SKU ID (as in the feed file uploaded to Dealavo)

• Price recommendation for each channel

• The field separator in CSV is a comma, the decimal separator is a dot