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 or entity_handle	See below “Notes About Optional Fields”
rating	This is the rating of the review
name	The name of the reviewer
body	This is the content 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 or entity_handle	See below “Notes About Optional Fields”
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.
email	Email associated with the review or question. If no value is provided, the email will default to your shop email.
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_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. You DO NOT want the variant id like: https://foo.myshopify.com/admin/products/9812301239/variants/39302884229169. 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.
entity_type	This is the Shopify entity type, Accepted types are: products, collections, or pages.
title	This is the title of the review
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.
published	1 or 0
delete	See Bulk Delete
img_url	This is the image associated with the entity (usually a product). We automatically get this from Shopify whenever possible.
reply_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.
reply_private	1 or 0 If reply is marked as a private reply, it will not be shown in widgets or search.
counts_liked	Number of times the review was liked.
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.