Knowledge base | Judge.me

Schedule requests for non-Shopify orders, in bulk via CSV upload

You can schedule Manual Review Requests in bulk by uploading a CSV file. You can download a sample CSV file here.

Note: after importing manual review requests, we will wait 10 minutes before sending the review request emails, even if you set processed_at in the past. This allows you to check the requests you uploaded and if necessary skip the newly added requests by clicking Do not send this request in the More column in the Dashboard.

References of each column of the CSV:

  • reviewer_name (required): name of the recipient
  • reviewer_email (required): email of the recipient
  • shopify_product_id (partially required): Shopify ID of the purchased product (either shopify_product_id or product_handle is required)
  • product_handle (partially required): handle of the purchased product (either shopify_product_id or product_handle is required)
  • fulfilled_at (required): (dd/mm/yyyy) date when the order was fulfilled. E.g. 04/05/2015 for May the 4th 2015
  • quantity (optional but recommended): quantity of the purchased product, we will set to 1 by default
  • processed_at (optional): (dd/mm/yyyy) date for the request to be sent, if blank, we will calculate using fulfilled_at plus wait date in your settings. If processed_at is in the past, we will schedule a request email after 10 minutes

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