You can import your orders via a CSV file directly from your Verified Reviews account.
By importing your orders, we’ll then be able to ask your customers about their experience with your services.
> Click on the version corresponding to your menu:
First collection
Requirements
- We recommend retrieving orders from the last three months to get relevant reviews.
- Prepare your file using the correct format: CSV.
Downloadable templates
The review collection will be done based on the data in your file. Download the template that best fits your needs below:
- 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).
Make sure to follow the expected formats and headers for each field by checking the examples; otherwise, rows with errors won’t trigger a review request. For example, date formats like dd/mm/yyyy or yyyy/mm/dd
- Brand review requests are about the shopping/order experience.
- Product review requests are about the product(s) purchased online or in-store.
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 |
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"
|
| purchase_price | The amount of the purchase. Default: 0 Ex:300 |
| phone |
Consumer’s phone number Warning: this field must always contain numeric characters, without decimals. |
| hide_personal_data |
Default: false Warning: the value must be entered exactly as true or false, in lowercase. |
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 |
| product_delay |
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 |
If you want to start collecting reviews right now, you can send a review request to your customers from the last three months by setting delay = 0 for brand reviews and delay_product = 0 for your product reviews.
One-time import
You use another automation method (SFTP, API, Connector...) but want to do a one-time import of your orders.
Prerequisites
- We recommend retrieving orders from the last three months to get relevant reviews.
- Prepare your file in the correct format, CSV.
- Verify that all required data is present.
Procedure (first collection and one-time import)
- From the left sidebar menu of your Verified Reviews dashboard, click on
Collect Reviews, then Configuration.
- Click on the CSV File tab.
- Upload the completed CSV file in the designated area.
- The total number of lines to import will then be displayed, as well as any lines with errors (incorrect format) or duplicates.
- Click on Import Data and confirm the import.
Remember the CSV format must use these settings: UTF8 encoding – semicolon separator and Max size: 5MB
As a trusted third party, whose review management is certified compliant with NF ISO 20488, we are required to survey all of your customers. Moreover, European regulations prohibit manipulating consumers, meaning no selection should be made in the collection process.
Import failure of requests
The import may fail if there is an issue with the file. Reasons will be indicated:
The file exceeds 5MB: we recommend splitting your imports into smaller files.
The file format is incorrect: change your file format – make sure it is indeed the CSV format to download at the beginning of this article, and that the columns match our recommendations.
If you import a file containing purchase/service proofs that already exist in our database, the system will block the import of these purchase proofs.