You can import a CSV file with ALL your orders, from your Back Office, in order to survey your customers and get reviews quickly.
Below you can find the prerequisites, depending on your case: first collection or one-time import, as well as the procedure to follow.
> Click on the version corresponding to your menu:
| ✨ New Platform | 🖥️ Historical Platform |
First Reviews collection
To start collecting, regardless of the automation method, you can integrate a file of your customers to start collecting their reviews.
Prerequisites
- We advise you to retrieve orders from the last three months in order to have relevant reviews.
- Prepare your file with the correct format, CSV. You can find the sample files below.
- Respect the file format as well as the headers.
- Check and make sure that all mandatory data is present.
The collection of reviews will be done using the data in your file. You can find the sample files below (click on the correct sample to download):
- File template for stores without product (brand reviews only)
- File template for online stores (website) without product (brand review only)
- File template for stores with product (brand review and product review)
- File template for online shops (website) with product (brand review and product review).
Be sure to respect the expected formats as well as the headers for each field by following the examples; otherwise, the lines with error will not give rise to the sending of a request for review. For example, the date formats dd-mm-yyyy or yyyy-mm-dd
- 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
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 |
The product information above is essential for submitting a review on Google Shopping.
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. |
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 |
If you want to collect reviews now, you can send a review request to your customers of the last three months by entering delay = 0 for brand reviews and delay_product = 0 for your product reviews.
Temporary Upload
You use another automation method (SFTP, API, Connector...) but you want to import your orders from time to time.
Prerequisites
- We advise you to retrieve orders from the last three months in order to have relevant opinions.
- Prepare your file with the correct format, CSV.
- Check that all mandatory data is present.
Procedure (first collection and occasional import)
- First of all, you have to log in to your Back Office.
- Go to the tab: Collection of reviews > Sending requests for reviews > CSV file
- Import your CSV file
Check CSV format, UTF8 encoding – semicolon separator and Max: 5MB
You will have the total of rows to import, the rows with error (the format does not match) or the duplicate rows.
4. Click on Import data and validate the import
5. You can track your requests from the Review Requests Tracking page
As a trusted third party, whose review management is certified as NF ISO 20488 compliant, we are obliged to survey all of your customers. In addition, the various European regulations impose not to manipulate consumers, ie to carry out a sorting in the collection.
I can't import my requests
If there is a problem with the file, we will mention the reason, for example if the format is incorrect.
In the case that you import a file with proofs of purchases/services already existing in our database, the system will block the import.