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.