How can I import reviews I have collected from other providers into eTrusted?

Did you collect reviews from other providers before you joined Trusted Shops? Then you can import the collected reviews into the eTrusted review platform subject to certain conditions. An import means you're not starting from scratch at Trusted Shops, but continue to benefit from the reviews you have collected in the past.

What prerequisites do I have to meet to be able to import reviews?

You can import both service and product reviews into eTrusted. To do this, you provide us with the necessary review data in import tables.

Service reviews must have been collected using a certified Google vendor review partner. You can find a list of all certified Google partners here: List of certified Google partners However, reviews you have collected with your Google company profile cannot be imported.

Product reviews must have been collected either through a certified Google partner or through your own shop system.

You must also declare to Trusted Shops in an additional agreement that

  • ... all reviews are based on a specific, verifiable transaction.
  • ... all reviews were written by genuine customers.
  • ... all ratings and comments have been submitted unchanged.
  • ... no reviews have been selected or held back.
  • ... you have the rights of use for the imported reviews and are entitled to grant Trusted Shops corresponding sublicenses.
  • ... you have received the right from your previous provider to transfer the reviews to third-party systems.
  • ... you assume responsibility for compliance with data protection regulations.
  • ... the reviews do not violate any legal regulations and were collected in compliance with competition law criteria.

What do I need to do if I want to import reviews?

  1. Check whether your collected reviews meet the above requirements.
  2. Send an e-mail to members@trustedshops.com and ask for the "Agreement to take over existing evaluations from other evaluation systems".
  3. Print out, read and sign the supplementary agreement. Then scan the signed licence confirmation.
  4. Download the service review import table sample file here: Import table for service reviews
  5. Do you also want to import product reviews? Download the import table for product reviews here: Import table for product reviews
  6. Use the sample files to create one or more import tables with all the reviews you want to import. An explanation of the import tables can be found here: What data do I have to enter in the import table?
Do you want to import reviews for multiple domains? Then please create your own import tables for each domain.
  1. Check whether the letters specific to your language such as ã, ä, ç, ë, ę, ê, ñ, ö, ß, ü or ż are displayed correctly within your import table.
  2. Send the signed supplementary agreement and the prepared import tables to members@trustedshops.com.

You have now successfully requested the import of your reviews. We will check the documents and contact you if anything is missing. If the documents are complete, it will take about seven working days for the reviews to be imported into our system.

Among other things, you can check whether the import was successful in the eTrusted Control Center. Information on how to do this is available here: Where can I find the imported reviews in the eTrusted Control Center?

What data do I have to enter in the import table?

You can use the import table to transfer the reviews you want to import to us. The import tables for service and product reviews have different structures. Therefore, always send us separate import tables for service and product reviews.

Import table for service reviews

The import table for service reviews consists of eleven columns. The following four columns are mandatory:

Column Explanation Further information
review.locale Review language The value must have the format language_COUNTRY. Example: English spoken in the United Kingdom has the value en_GB. A list of all possible values can be found here: Locales
review.rating Star ratings awarded Integers or decimals can be entered. Examples: 1, 3.5, 5
review.submittedAt Date and time of review submission An example of the specified date format is: 2023-01-22T12:52:13.000Z However, please feel free to use a standard date format. We will adapt the date format to the requirements of our system for you, unless you have used several different date formats in your table.
transaction.reference Order number of the order associated with the review  

For example, your import table could look like this after you have completed it:

01_EN.png

Do you also want to import your responses to collected reviews? Then you also need to fill in the following two columns:

Column Explanation Further information
review.reply.comment Response text  
review.reply.repliedOn Date and time of response An example of the specified date format is: 2023-01-22T12:52:13.000Z However, please feel free to use a standard date format. We will adapt the date format to the requirements of our system for you, unless you have used several different date formats in your table.

The following five columns of the import table can be filled in optionally:

Column Explanation Further information
channel.id ID of the eTrusted channel for which you want to import reviews  
review.title Review title  
review.comment Review comment  
transaction.date Order date of the order belonging to the review Please use a standard date format. We will adapt the date format to the requirements of our system for you, unless you have used several different date formats in your table.
tracking.source Provider with whom you collected the review  

Import table for product reviews

The import table consists of the eleven columns of the import table for service reviews, as well as a further seven columns. In addition to the columns review.locale, review.rating, review.submittedAt and transaction.reference described above, you also need to fill in three additional columns to import product reviews. Therefore, fill in at least these seven columns:

Column Explanation Further information
review.locale Review language The value must have the format language_COUNTRY. Example: English spoken in the United Kingdom has the value en_GB. A list of all possible values can be found here: Locales
review.rating Star ratings awarded Integers or decimals can be entered. Examples: 1, 3.5, 5
review.submittedAt Date and time of review submission An example of the specified date format is: 2023-01-22T12:52:13.000Z However, please feel free to use a standard date format. We will adapt the date format to the requirements of our system for you, unless you have used several different date formats in your table.
transaction.reference Order number of the order associated with the review  
product.name Name of the reviewed product  
product.url URL of the product detail page of the reviewed product on your website  
product.sku Stock Keeping Unit (SKU) of the reviewed product This column is used to link the reviews to the corresponding products. Therefore, ensure that the values match those in your shop system.

For example, your import table could look like this after you have completed it:

02_EN.png

The following four columns of the import table can be filled in optionally:

Column Explanation Further information
product.imageURL URL of an image of the reviewed product on your website  
product.mpn Manufacturer Part Number (MPN) of the reviewed product  
product.gtin Global Trade Item Number (GTIN) of the reviewed product Do you use Google integration? If so, please also provide the GTIN.
product.brand Brand of the reviewed product  

Where do the reviews appear after import?

Imported service reviews appear in the following places:

  • In the Trustbadge®, the imported reviews are counted in the total number of reviews collected. However, since the imported reviews have not been verified by Trusted Shops, they will not be taken into account when calculating your average rating.
    03_EN.png
  • If the imported reviews are not older than 12 months, they are also listed in the review profile. They are marked as "Imported" there.
    04_EN.png
  • The widgets display the review comments of imported reviews. However, they have no influence on the displayed average rating.
    05_EN.png

Where can I find the imported reviews in the eTrusted Control Center?

You will find the imported reviews in your inbox.

  1. Log in to the eTrusted Control Center.
  2. Click on the star ("Reviews") (01_16x16.png) in the main navigation. Then click on "Inbox" (02_16x16.png).

06_EN.png

You have now opened the inbox. You can recognise imported reviews by the fact that the e-mail addresses begin with "imported_review_".

07_EN.png

Since imported reviews have not been collected with Trusted Shops, they do not affect the analytics dashboard.

Download import tables

Back to: What do I need to do if I want to import reviews?


Was this article helpful?

1 out of 1 found this helpful