Send invitations by uploading a file with customer data (product reviews)

This feature is part of the Product Reviews add-on module.

Get the module

If you want to invite customers to write product reviews manually, you can create a CSV file that contains your customers' information, then import it to your Trustpilot Business account. Here’s how to do it.

  1. From your Trustpilot Business account, navigate to Get reviews > Invite Customers.
  2. Under Invite manually, select Upload a file - Service and product reviews.
  3. Click Select file and upload your CSV file. The columns in the CSV file should include the following data in this order:
    • Customer email
    • Customer name
    • Reference number
    • SKU
    • Product name
    • Product URL
    • Image URL

  1. Check your customer data to make sure it's correct, then click Continue.
  2. In the Sender name field, enter your sender information. Then select the Reply-to email address you would like the invitation to be sent from in the drop-down menu. Click Continue.

  1. In Select template, choose the template you would like to use from the Select template for the review invitations drop-down menu. You can also choose the language for your invitation.

  1. In the Send your customers to this website to write their review: drop-down menu, select the local Trustpilot website that you want to send your customers to when they write their review. Click Next.

  1. Review your data. If you're satisfied, click Send Invitations.