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 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.
HTML