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.
Import Existing Reviews
Go to imports job page and add a new import job.
Select Reviews for Data Type and attach csv file for import.
On next step, specify field mappings and other configurations for import. Below are the available fields.
|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.||
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.
|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 Handle||Handle for reviewed product on ecommerce platform. This is used to identify reviewed product. For product reviews, at least one of
|Reviewer Display Name||Display name of reviewer.||John Doe||Yes|
|Reviewer Email||Email of firstname.lastname@example.org||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.||
Thank you for reviewing!
|Reply Datetime||Reply datetime in ISO 8601 format.||2020-03-01T21:11:51.205173-11:00||No|
Reviewer Display Nameand
Reviewer Emailmust be mapped.
For product reviews, at least one of
Product External ID,
Product Handlemust be mapped.