Send product review invitations by uploading a file with customer data
If you want to invite customers to write product reviews, you can create a CSV file that contains your customers' information, then import it to Trustpilot Business.
All new (paying and free) customers will have 90 days to upload files with customer data from the first time they use it. The amount you can send will depend on your pricing plan as follows:
- Free: 50 per month
- Plus: 200 per month
- Premium: 500 per month
- Advanced: 5000 per month
- Enterprise: Unlimited
Invitations to write product reviews will be sent in connection with a service review invitation. By default, customers will be asked to leave a product review right after they've written a service review. You can enable separate product review invitations in the Time and delivery section of your Invitation Settings.
-
In Trustpilot Business, go to Get reviews > Invitation methods. Scroll down and click Try a different way to get reviews.
-
Select File Upload with Product Reviews.
-
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
You can learn how to create this file here.
If the Reference number and the Customer email address match, all product reviews will be combined in one invitation email.
-
Check your customer data to make sure it's correct, then click Next.
-
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. You can also select the option to Add another Reply-to Email.
-
Choose if you'd like to send from a generic no reply email, or from your own email domain. Click Next.
-
In Select template, choose the template you'd like to use from the Select template for the product review invitations menu. You can browse the options and make your selection by clicking Change. You can also choose the language for your invitation.
-
In the Invitations landing page to send customers to: drop-down menu, select the local Trustpilot website that you want to send your customers to when they write their review. Click Next.
-
Review your data. If you're satisfied, click Send Invitations.