You’ve put all that hard work into getting product reviews on Trust Pilot, but now you still lack the social proof on your WooCommerce product pages. This is the exact situation I had with a client, as they had an automated sequence which asked customers to leave a review on Trust Pilot. They’ve been importing these reviews manually from Trust Pilot to WooCommerce, which isn’t fun when you have a big store and hundreds (or even thousands) product reviews per month.
Luckily, there is a way to semi-automate this process. We’ll be using Product Reviews Import Export plugin to make this happen.
Export reviews from Trust Pilot
First we need to export product reviews from Trust Pilot:
- Login to your business Trust Pilot account
- Choose Reviews > Product Reviews from the sidebar menu
- Choose “More Filters” button to reveal “Date” widget. Click on it.
- Choose the date range from the date you want to import the reviews to the present da te if you’re doing it for the first time. Otherwise, choose the last time reviews have been imported to the present day. Click Apply and Export.
Prepare template file for import
Next we need to prepare CSV spreadsheet with specific values to be able to import reviews.
Download Sample product review file HERE and fill it out like this, using the reviews you’ve previously exported from TrustPilot.
- comment_post_ID – product ID from WooCommerce. This can be found by searching for a product and mouse-over the product link.
- comment_author – name of the reviewer
- comment_author_email – email of the reviewer
- comment_date – date in the same format as exported from TrustPilot
- comment_date_gmt – same as above
- comment_content – The actual review
- comment_approved – Set to “1” and it will automatically appear in Woo. Set to “0” and it will need to be approved first.
- comment_parent – Leave to “0”
- user_id – Same as above
- rating – Number of stars the review received
- verified – Set to “1” since these are your real, verified reviews. Save the file in CSV format after you remove the special characters, if any (see below)
When everything is filled out correctly and special characters removed, save the file in CSV format.
Import reviews to WooCommerce
All that’s left now is to import the CSV file containing product reviews from TrustPilot to WooCommerce. I suggest importing a small portion of reviews first to test it make sure everything is in order.
- Install Product Reviews Import Export for WooCommerce plugin and activate it
- Go to WooCommerce > Product Reviews Im-Ex to load it
- Click on “Product Reviews Import” tab
- Choose the file you’ve prepared and click “Upload file and import” button
- Wait for the import to finish and then check the product pages to make sure reviews imported correctly
That’s it! Now set a reminder in your calendar to import product reviews from TrustPilot to WooCommerce on a regular basis and make sure to note down every time you do so.
Hi! thanks for the article ! I used the plugin it worked fine on my local version on MAMP but it’s not working on ftp version of the website : “Product review skipped.” for all the line of the csv 🙁 I’m trying to understand the issue and trrying to fix it for more than 24 hours now… I’m desperate… if you have any clue it would be very nice of you
Hey Tarik,
can you try disabling all other plugins and giving it a go? Maybe there’s a conflict.
Another thing to try is to get some tips/ideas from this TrustPilot article.