✨ New version: Automation method SFTP for collecting reviews

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:

  • 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
email 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:
  • BRAND_AND_PRODUCT: brand and product review requests sent at the same time.
  • PURCHASE_ONLY: brand review request only or brand review request sent before product review request.
  • PRODUCT_ONLY: product review request only or product review request sent after brand review request.
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

  1. Go to the Collect reviews > Send review requests menu
  2. Choose SFTP
  3. Click on the button to create your SFTP account
  4. 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

Was this article helpful?
2 out of 2 found this helpful