Direct Import |

Direct Import

If your reviews do no come from another app we support, then you can import reviews by uploading a CSV file. You can download a sample CSV file here. A list of supported apps can be found here.

References of each column of the CSV:

  • title (optional): title of the review. If empty the default (rating/5) will be used instead.
  • body (optional): the body of the review. If empty the product's title will be used instead.
  • rating (required): the rating of the review.
  • review_date (opional): (dd/mm/yyyy) date when the review was created. E.g. 04/05/2015 for 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_id or product_handle is required)
  • product_handle (partially required): handle of the purchased product (either product_id or product_handle is required)
  • 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 and then wrap all in quotes( "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 the product handle is red-widget.

Note: If a product URL has params, those params are not part of the handle. So for the handle is still red-widget.

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 with 123456789 being the Shopify product ID

Importing shop level reviews.

If you want to import shop level reviews, then please leave both product_id and product_handle empty.