*Note: This article is outdated. Please check the new version HERE.
References of each column of the CSV:
title(optional): title of the review.
body(required, has fallback): the body of the review. If empty the product's title will be used instead. The body needs to have content.
rating(required): the rating of the review.
dd/mm/yyyy) date when the review was created. E.g.
04/05/2015for May the 4th 2015. If left empty that review will be created with the current date.
reviewer_name(optional): name of the reviewer. If empty anonymous will be used instead.
reviewer_email(optional): email of the reviewer. If empty a unique fake email will be used instead.
product_id(partially required): Shopify ID of the purchased product (either
product_handle(partially required): handle of the purchased product (either
reply(opional) : The public reply of the review. If the review has one.
picture_urls(optional): The urls of the images attached to the review. If there are more than one urls please separate them by a comma. E.g.: https://picture1, https ://picture2, ..., https://picture5 . We only accept up to 5 pictures per review so we will only take first 5 urls, if more.
ip_address(optional): IP address of the review. We automatically calculate detailed location (e.g. city, country, country code) based on the IP address. Example:
Finding product handle
The product handle is the last part of the product URL. For example, for
www.yourshop.com/products/red-widget the product handle is
Note: If a product URL has params, those params are not part of the handle. So for
www.yourshop.com/products/red-widget?variant=1 the handle is still
Finding Shopify product ID
To find the Shopify product ID of a product, do as follows:
- Go to the Shopify products admin
- Open the product admin on the product you want to find the Shopify product ID for
- The URL will now be
123456789being the Shopify product ID
If one of the two, product handle or product ID, is wrong but the other one is correct, we will still be able to import the product reviews.
Importing shop level reviews.
If you want to import shop level reviews, then please leave both
Import custom forms with Direct Import.
We now support importing custom forms with your reviews. To import custom forms please follow these instructions:
- We only import custom forms as text so we do not import multiple options custom forms.
- For each Question you want to import create a column named
CF question name, and then for each review add the corresponding value. Please make sure the column name starts with
CFboth capital and no space before.
- Then import reviews normally,
For example in the picture below we added 3 extra columns. Two start with
CF one does not. After Import one review with have one custom form and the other one will have two. The third column is ignored as it does not start with