Skip to main content

Create and manage export

Learn how to create and manage exports

You are here: Market Price Analysis -> Price Analytics and Repricing Report

You can export the price data of your queries via a report. Reports are independent of query groups and are always filled with the latest available data. The data may come from different query groups.

Create report

  1. Click on "Create new export"

  2. Enter a name for your export

  3. Choose if you want to ...

    • Copy an existing export with all its data fields and use it for your export

    • Create a new export

  4. Click on "Create New export"

Manage Export

Manage the data fields you want to show in your export.

  1. Open the export you want to configure

  2. Click on "Export Settings"

Now you are here: Market Price Analysis -> Price Analytics and Repricing Report -> <any report> -> Manage Export

Report Assistant

When creating a new report and want to edit its fields for the first time, the Report Assistant opens automatically. With this wizard, you can easily add many relevant price data fields to the report. This way it covers many scenarios of report creation.

Create standard report

A standard report contains data on SKU, EAN, article description and own article price as well as data on shipping costs, price, availability, store name, rating and number of ratings of the competitor for each of the positions 1-10.

  1. If the report assistant doesn't open automatically, click on "Report Assistant".

  2. Choose the channel to which you want to add data fields listed above.

  3. Click on "Create standard report for channel".

  4. The data fields listed below will be added to the export.

  5. Click "Save."

Advanced data field selection

You can add individual data fields with the report assistant.

  1. If the report assistant doesn't open automatically, click on "Report Assistant".

  2. Choose the channel to which you want to add data fields listed above.

  3. Click on "Advanced data field selection".

  4. Follow the instructions and choose your requested data fields.

  5. Click "Save".

Add data fields manually

You can add more data fields manually to your report to export more data.

  1. Click on "Add field".

  2. Rename the data field according to the channel's specifications using the pencil icon.

  3. Press "Enter" on your keyboard to accept the field name.

  4. Choose the data source for your export field.

  5. Click "Save".

Edit Settings

Specify the export behaviour of your report here.

Open the report you want to edit.

Now you are here: Market Price Analysis -> Price Analytics and Repricing Report -> <any report> -> Manage Export

Export-URL

To export your report to another tool, you must first store the URL generated by Channel Pilot Pro in the tool.

  1. Move your mouse over the link to your product catalogue in the upper area

  2. The link will be highlighted in orange.

  3. With "right click + copy" or "<CTRL>+C" you copy the link to the clipboard.

  4. Paste the link to the tool of your choice.

Export Settings

In "general export settings" you can configure the report basically. These are your options:

  • Channel Enable: Enable or disable the export of your report for this channel.

  • Feed update rule:Set the frequency of the export of your report:

    • Automatic: The report will be updated automatically after any change.

    • Manual: The report will be updated only when you click the button on this page for it.

    • Scheduled: The report will be updated only at the times you specify.

  • Minimum number of articles: If fewer articles than specified here are calculated in the report for export, the export will be cancelled. This can be specified via the slider in whole numbers or as a percentage.

  • Channel filter: Add a filter to limit the articles of your product catalogue included in the report.

Click "Save Settings" after you have made changes.

Security

The security settings for your report export allows you to select whether and how your export should be protected against unauthorized access.

  • Off: The export can be accessed by anyone with a link.

  • Header: The export is only accessible with an HTTPS header extension. Proceed as follows:

    1. Password: It is composed of API Merchant ID and API token concatenated by ":".

      • e.g.: <API-Merchant-ID>:<API-Token> -> 4KR8TV8VO:TRLR36O7D59D49

    2. Encoding: The password must then be Base64 encoded.

      • e.g: NEtSOFRWOFZPOlRSTFIzNk83RDU5RDQ5

    3. GET request: add the Base64 encoded password via a third party tool to the http GET request as a header extension of type "Authorization".

    4. The Channel Pilot Pro server checks the header and responds with the export if authentication was successful.

API Merchant ID and API token can be found in the store settings under the Channel Pilot Pro API Access tab (Start -> Settings -> Shop Setup).

  • Password: The export is protected by a password, which must be added to the download URL as an additional parameter:

    1. Enter a password in the password field.

      • Ex: MyPassword

    2. Click "Save Settings".

    3. Copy your export URL as described above and paste it into the backend of your channel.

    4. Add the following to the export URL: ?password=<selectedPassword>

      • Ex: https://get.cpexp.de/.../googleshoppingde.csv?password=MyPassword

    5. The Channel Pilot Pro server will check the additional parameter and respond with the export if the correct password was passed.

You can set the preselected security standard in the store settings under the Security tab (Start -> Settings -> Set up store). This will then be automatically selected for all subsequently created exports.

Click "Save Settings" after you have made changes.

Related Articles
Did this answer your question?