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 recipientproduct_id
(partially required): Shopify ID of the purchased product (eitherproduct_id
orproduct_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 (eitherproduct_id
orproduct_handle
is required)fulfilled_at
(required): (dd/mm/yyyy
) date when the order was fulfilled. E.g.04/05/2015
for May the 4th 2015quantity
(optional but recommended): quantity of the purchased product, we will set to1
by defaultprocessed_at
(optional): (dd/mm/yyyy
) date for the request to be sent, if blank, we will calculate usingfulfilled_at
plus wait date in your settings. Ifprocessed_at
is in the past, we will schedule a request email after 10 minutes
Note: fulfilled_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
with123456789
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