Skip to main content

Import Existing Reviews via CSV

Ryan Liao
  • Updated

You can import existing reviews to OnVoard via CSV upload.

 

Before you Begin

  • Go to products page and ensure that products are already imported to OnVoard if you are importing product reviews. This is required since product reviews needs to be linked to a product. It may take up to a few hours for products to be fully imported once you have connect to your ecommerce platform. 

 

CSV Requirements

  • Must use comma (,) as delimiter.
  • Must use double quotes (") as quote char.

 

Import Existing Reviews

Go to imports job page and add a new import job.

screenshot-2021.08.16-05_31_07.png

Select Reviews for Data Type and attach csv file for import.

 

screenshot-2021.08.16-05_35_14.png

On next step, specify field mappings and other configurations for import. Below are the available fields.

 

Field Description Example Required
ID (OnVoard Review) Review ID in OnVoard. Only use this if you want to bulk update existing reviews. rvw_dg7bn6ksvwvidia No
Title Title for review. Awesome No
Content Content for review.  This is a good product. Yes
Rating A score from 0-5, where 5 represents the most positive review. 4 Yes
Image URLs String array for list of image urls for review. Values can be in comma-separated string format as well. Support single image url as well. 
[
"https://test.com/1.jpg", 
"https://test.com/2.jpg"
]
"https://test.com/1.jpg", 
"https://test.com/2.jpg"
https://test.com/1.jpg
 No
Video URLs
String array for list of video urls for review. Values can be in comma-separated string format as well. Support single video url as well. Video must be .mp4 file under 30MB. This is an optional field.
 
[
"https://test.com/1.mp4", 
"https://test.com/2.mp4"
]
"https://test.com/1.mp4", 
"https://test.com/2.mp4"
https://test.com/1.mp4
 No
Created Datetime Review created datetime in ISO 8601 format. 2020-02-01T21:11:51.205173-11:00 No
Product External ID ID of reviewed product on ecommerce platform. This is used to identify reviewed product. For product reviews, at least one of Product External ID, Product Handle must be mapped. 124556 Maybe
Product Handle Handle for reviewed product on ecommerce platform. This is used to identify reviewed product. For product reviews, at least one of Product External ID, Product Handle must be mapped. white-tshirt Maybe
Reviewer Display Name Display name of reviewer. John Doe Yes
Reviewer Email Email of reviewer.  john@example.com Yes
Num Upvotes Number of upvotes for this review. Default value is 0. 0 No
Reply HTML Business reply for review in HTML. Even though HTML is indicated, plain text reply will work as well. 
<p>
Thank you for your review!
</p>
Thank you for reviewing!
 No
Reply Datetime Reply datetime in ISO 8601 format. 2020-03-01T21:11:51.205173-11:00 No

 

  • Content, Rating , Reviewer Display Name and Reviewer Email must be mapped.
  • For product reviews, at least one of Product External ID, Product Handle must be mapped.

 

 

 

 

Related articles