Rapid Reviews / Import CSV Template File

Import CSV Template File

Use our import file below to import both Reviews and Questions. This file shares the identical format as our exported csv files.

Click here to download our official template file.

Reviews and Questions share all the same fields. They are differentiated from each other using the type field. The acceptable values are r for reviews, and q for questions.

Required Fields For Reviews

Field Name Description
type Value should be r
entity_id The Shopify entity ID associated with the product, collection, page, etc. This id can be found in the Shopify admin in the numerical url suffix like: https://foo.myshopify.com/admin/products/9812301239

If using Microsoft Excel, you can put a single quote before the id so that Excel does not convert the large number to scientific notation. So annoying!
email The email of the reviewer
name The name of the reviewer
body This is the content of the review
title This is the title of the review
shop Your myshopify domain, like foo.myshopify.com.

Required Fields For Questions

Field Name Description
type Value should be q
entity_id The Shopify entity ID — learn more
email The email of the reviewer
name The name of the reviewer
body This is the content of the review
shop Your myshopify domain, like foo.myshopify.com.

Notes About Optional Fields

Field Name Description
id This is the Rapid Reviews id. If we recognize the id, we will overwrite our existing entry instead of creating a new entry.
entity_handle This is the Shopify entity handle, e.g. nike-super-max-12. We use this field only as a fallback if you import from other review apps that do not provide the entity ID.
entity_type This is the Shopify entity type, Accepted types are: products, collections, or pages.
created_at_iso This is the created at time for the review or question. Use ISO date format. If you do not know the time, you can use simplified format like 2022-10-23.
counts_liked, counts_reported If your review was liked or reported.
img_url This is the image associated with the entity (usually a product). We automatically get this from Shopify whenever possible.
published 1 or 0
delete See Bulk Delete
source Marketing referral source. This is captured on your review capture page. *Reviews only.
source_other If the customer selects “Other” for referral source on your review capture page. *Reviews only.
featured 1 or 0 If review was marked as “Featured” in the app admin. This will populate a review in this Featured List widget.
verified 1 or 0 If customer is auto-verified. This can also be set manually in the app admin. *Reviews only.
attr Attributes from review capture. This field must be valid JSON. *Reviews only.
variant_id This is the Shopify product variant ID. We pull this from the page URL if available. You can also pass it to us in your direct capture link.
order_id This is the Shopify Order ID.
lang Two-letter language code associated with the review. Acceptable values are en, es, de, and nl. Learn more
ip_address IP address associated with the person who left a review or question.
location Currently not in use by Rapid Reviews, but will populate if imported from other apps, where applicable.
spam_score Spam score from review or question capture pages.
media_0_src Image or video from review content. *Reviews only.
media_0_type Accepted types: image or video.
media_0_rel_id Rapid Reviews generated.
media_0_public_id Rapid Reviews generated.
HTML