Export settings

Receive the Pricewatch export file via e-mail or FTP/SFTP

There are two ways to receive the Pricewatch export file: via e-mail or FTP/SFTP. You can change these settings in the Export data section under Pricewatch export:

Picture16

Export via e-mail

You can choose to receive the Pricewatch export via e-mail. This means that you will receive an e-mail with the CSV file, containing all pricing data.

If you would like to receive the Pricewatch export on multiple e-mail addresses, separate multiple e-mail addresses with a semicolon.

Note – If you do not receive the Pricewatch export, please check your spam filter. If it is not in your spam filter, your Pricewatch export file may be too big for your email-provider to process. The maximum filesize we can export is 30mb. If this is the case, we recommend you set up an FTP/SFTP connection for export.


Upload export to FTP/SFTP

You can also choose to receive the Pricewatch export file on an FTP/SFTP location. Just enter the location and login details of the FTP/SFTP in this export data section.

Note – You might need to whitelist our IP addresses. Please find more about our IP addresses in this article.

The “status email” textbox is a tool that keeps your team updated whenever there is an export. When you enter an email into this box, we will send an e-mail to this address every time we have uploaded a new file to your FTP/SFTP location.

Pricewatch Export: Public Key Authentication for SFTP

Public Key Authentication is now available for Pricewatch SFTP exports, providing stronger security for your data by using key pair authentication instead of traditional passwords.

Key Benefits:
  • Enhanced Security: Safeguard your pricing data with stronger access control.
  • Seamless Automation: Automate processes more securely, reducing reliance on passwords.
  • Easy Integration: Select and download key pairs directly from the interface.
How It Works:
  1. Enable Public Key Authentication: Check the option when selecting SFTP.
  2. Select Key Pair: Choose or create a key pair in the dropdown.
  3. Download Public Key: Download the key to complete setup.

For more in-depth explanation, please click here


Available data

Date

Last time we updated the datapoint

Product Name

This is a field that comes from your own import

Shop ID

Internal shop ID of the data source (CSE’s*)

Shop name

Name of the seller of the product

Price

Price of the seller of the product

Shipping Costs 

Shipping costs found on the datasource for that unique seller

Delivery Times

Delivery times, for Tweakers this might be a special code*

Product ID

This is your own imported Product ID 

Data source

The datasoruce we found the product and price on

Price from data feed

This is your own imported price

Number of Review

Refers to the number of reviews for the webshop  (only available for CSE’s)

Shop Score

Refers to the average review score of the webshop (only available      on CSE’s)

Brand

Brand of the product

*CSE sources refer to Tweakers, Kieskeurig and Vergelijk

Picture17


Tweakers delivery time codes
:

All positive values represent delivery time in so many days (with a maximum of 255).

0 = "ordered today, delivered tomorrow" - without the weekend
-10 = download
-20 = "ordered today, delivered tomorrow" including the weekends
-25 = "ordered on a working day, delivered the next working day"
-30 = "pre-order"
-1 = Unknown delivery date supplied
-2 = no information available in the shop feed