Thanks to this new functionality, you will save time by importing, independently, your purchase/service delivery events more easily into the interface.
Take advantage of questionnaires with a more modern design, in order to offer your consumers a more fluid questionnaire experience and improve your response rates.
> Click on the version corresponding to your menu:
| ✨ New Platform | 🖥️ Historical Platform |
Prerequisites
- Create an SFTP account on the R&R servers
- Prepare the data file in advance (proof of purchase or services)
The collection of reviews will be done using the data in your file. You can find the templates files below and at the very bottom of the page:
- File template for stores without products (brand reviews only)
- File template for online stores without products (brand reviews only)
- File template for stores with products (brand and product reviews)
- File template for online stores with products (brand and product reviews)
- The brand review requests are the one about the purchase experience/order.
- The product review requests are the one about the product(s) purchased online or offline
Be sure to respect the expected formats for each field by following the examples. Otherwise, the lines with error will not give rise to the sending of a request for review.s.
Required fields for all types of review requests are the following:
| FIELD NAME | DESCRIPTION |
| channel | Default: "online" Enum: "online" "offline" How the purchase was made ("online" if made on a website, "offline" if made in a store) |
| shop_id | The shop where the purchase was made. Required if channel=offline |
| purchase_date | The date of the purchase and the purchase time ex: "2022-10-15 05:19:46", “"2022-10-15” |
| purchase_reference | The reference of the purchase. ex: "#1855" |
| first_name | Consumer's first name Ex: John |
| last_name | Consumer's last name Ex: Doe |
| Consumer’s contact email Ex: john@doe.com |
|
| language | Enum: "fr" "en" "es" "de" "it" "pt" "br",”be” ISO 639-1, 2 letters language code. If the language is not available in our solution, English will be used. (ex “en”) |
Required fields for product review requests are the following:
| FIELD | DESCRIPTION |
| product_ref | The reference of the product Required if product review request |
| name | Name of the product Required if product review request |
Non required fields for all types of review requests are the following:
| FIELD | DESCRIPTION |
| purchase_event_type | Enum: "BRAND_AND_PRODUCT" "PURCHASE_ONLY" "PRODUCT_ONLY" The type of review requests that will be sent:
|
| purchase_price | The amount of the purchase. Default: 0 Ex:300 |
| phone | Consumer’s phone number ex: 3361111111 |
| hide_personal_data | Default: false True if the personal data should be hidden during display of this purchase event. |
| language | Enum: "fr" "en" "es" "de" "it" "pt" "br",”be” ISO 639-1, 2 letters language code. If the language is not available in our solution, English will be used. (ex “en”) |
Non required field for the brand review request only is the following:
| FIELD | DESCRIPTION |
| delay | Default: 0 Number of days after the order/purchase before sending the brand review request to the consumer. (if you want to use a delay different from the one used in the collect review configuration page to send a brand review request regarding this purchase event) |
Non required fields for the product review requests only are the following:
| FIELD | DESCRIPTION |
| product_delay | Default: 0 Number of days after the order/purchase before sending the product review request to the consumer. (if you want to use a delay different from the one used in the collect review configuration page to send a product review request regarding this product) |
| Category | The category of the product |
| Brand | The brand of the product |
| product_price | Default: 0 The price of the product Ex:150 |
| product_url | A link to the product page |
| image_url | A link to the product image. This will be used to display your product on Skeepers. |
| ean | The EAN of the product (< =13 characters) |
| sku | The SKU of the product |
| upc | The UPC of the product |
| isbn | The ISBN of the product |
| jan | The JAN of the product |
| mpn | The MPN of the product |
Process
First connection
- Go to the Collect reviews > Send review requests menu
- Choose SFTP
- Click on the button to create your SFTP account
- Once the account is created, you can view your SFTP settings (Host, username, Port, Path, password). They will automatically be there, you just need to copy/paste
You also have the possibility to test the connection.
SFTP Architecture:
By default, the partition structure is defined as follows:
|
Folders |
Description |
|
.../orders/ |
Main drop folder |
|
.../orders/success/ |
Successfully Processed Files Subfolder |
|
.../orders/error/ |
Subfolder of files processed in error * |
An error in the file: You will find an error report with the description of the problem in order to be able to correct it.
Any deposit in the /orders/ folder will be processed by our system the day after the deposit between 1am and 3am (UTC+1 or UTC+2).
Files will end up in the /success/ or /error/ subfolders depending on their validity.
In order to be able to send us your data by SFTP, remember to authorize the following list of IPs: 52.214.31.102, 34.251.16.171, 34.252.230.124 and 34.251.217.121
It is possible to use a single SFTP for several dissociated accounts within the framework of an international collection or in a company/subsidiary system.
Here is an example:
|
Country |
Folder |
|
France |
.../fr_FR/orders/ |
|
France |
.../fr_FR/orders/success/ |
|
France |
.../fr_FR/orders/error/ |
|
USA |
.../en_US/orders/ |
|
USA |
.../en_US/orders/success/ |
|
USA |
.../en_US/orders/error/ |
If you have more than one account, you must complete the procedure on each of them.
File format
The characteristics to be respected are the following:
|
File type |
CSV |
|
Encodage |
UTF-8 sans BOM |
|
Délimiteur |
";" (semicolon separator) |
|
Date format |
AAAA-MM-JJ / jj-mm-aaaa |
You have the option of setting the deadlines for sending reviews from Collection of reviews – Configuration, for brand and product reviews by default. If you want to have a different delay per product, you can add it to your csv file, in the delay_product column