Knowledge Base

Knowledge base

Explore How-To's and learn best practices from our knowledge base.

Schedule review requests in bulk via CSV upload

Modified on: Sat, 6 Apr, 2019 at 7:13 PM


Schedule review requests 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.

You can upload the CSV inside the Judge.me Admin: Go to your Requests/Emails Dashboard and click on Add Manual Requests on the upper part of the dashboard.

Note: After importing manual review requests, we will wait for 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 Requests Dashboard.

References of each column of the CSV:

  • reviewer_name (required): name of the recipient. We only use the name provided in this csv if an email address does not have a name provided by Shopify or by the customer themselves.
  • reviewer_email (required): email of the recipient
  • product_id (partially required): Shopify ID of the purchased product (either product_id or product_handle is required). Please make sure this is either empty or a strict positive number. Not 0.
  • product_handle (partially required): handle of the purchased product (either 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

Notefulfilled_at and processed_at are two different dates. fulfilled_at is the date the order was fulfilled while processed_at is the date you want to send the request email.

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.

For WooCommerce, we will only look in the last part of your URL for identifying the product handle so it doesn't matter if you are using a slug like /product/ or /produkte/. E.g. the product handle for this URL: http://examplestore.com/alle-produkte/example will be example.

Finding Shopify product ID

To find the Shopify product ID of a product:

  • 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

Finding WooCommerce product ID

To find the WooCommerce product ID of a product:

  • Go to your WooCommcerce admin (.../wp-admin/edit.php?post_type=product)
  • Hover over any product and find the ID: ..., e.g. ID: 122



Did you find it helpful? Yes No Still have questions? Talk to us here

Can you please tell us how we can improve this article?