Direct Import | Judge.me

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 (optional): (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: 34.203.165.149.

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 red-widget.

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 red-widget.

Finding Shopify product ID

To find the Shopify product ID of a product, do as follows:

  • Go to the Shopify products admin www.yourshop.com/admin/products)
  • Open the product admin on the product you want to find the Shopify product ID for
  • The URL will now be www.yourshop.com/admin/products/123456789 with 123456789 being 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 product_id and product_handle empty.

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 CF both 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 CF.

Please notice that we do no check if the review already exists for import. So importing twice will create duplicates. If you want us to remove old/duplicated reviews let us know.