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.