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:
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.
- If the CSV file contains at least one incorrect line, it will be sent to the error folder with a log file, but the valid lines will still be saved.
- If the file is entirely correct, it will be sent to the success folder.
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. YYYY-MM-DD, eg: “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” If the language isn’t available in our system, or if the language is missing from your file, English will be used by default. |
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"
|
| purchase_price | The amount of the purchase. Default: 0 Ex:300 |
| phone | Consumer’s phone number ex: 3361111111 |
| hide_personal_data |
Default: false Automatically hides the consumer’s personal data when the review is published.
Must be exactly true or false (lowercase). Use: if the brand already has the consumer’s consent, it can send true to hide data from the order, without the consumer checking a box. Example: the brand always hides names and emails, even if the consumer doesn’t tick anything in the survey. |
Non required field for the brand review request only is the following:
| FIELD | DESCRIPTION |
| delay |
Default: 0 Please note:
For catch-up files (past orders), the delay starts from the integration date, even if the order has already been placed. |
Non required fields for the product review requests only are the following:
| FIELD | DESCRIPTION |
| delay_product |
Default: 0
(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