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. 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_handleis 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
dd/mm/yyyy) date when the order was fulfilled. E.g.
04/05/2015for May the 4th 2015
quantity(optional but recommended): quantity of the purchased product, we will set to
dd/mm/yyyy) date for the request to be sent, if blank, we will calculate using
fulfilled_atplus wait date in your settings. If
processed_atis in the past, we will schedule a request email after 10 minutes
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
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
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
123456789being the Shopify product ID