Skip to main content

Reviews template

Create and update BigCommerce reviews using Shift.

tip

Check out our step-by-step guides for how to import & export.

Quick start

The best way to get started is to run an export and use the file as a guide to the format required.

You can also download the reviews template.

Import & export columns

Basic columns

FieldsDescription
IDThis is the unique identifier provided by BigCommerce for existing reviews.
🔑 This field is required to update existing reviews.
Product IDThe ID of the reviewed product. Either the Product ID or the Product SKU is required to create a new review.
Product SKUThe SKU of the reviewed product
Product NameThe name of the reviewed product. Provided when exporting to help identify products.
This field is ignored when importing
TitleThe review title.
This field must be shorter than 255 characters.
TextThe review.
StatusThe status of the review
Allowed values: approved, disapproved, pending
RatingThe star rating.
Allowed values: 0, 1, 2, 3, 4, 5
EmailThe reviewer's email.
This field must be a valid email, or empty.
NameThe reviewer's name.
This field must be shorter than 255 characters.
Date reviewedThe date reviewed.
This field should be formatted as a ISO 8601 timestamp 2016-12-07T18:01:20+00:00

Export filters

You can filter review exports to include reviews only for specific products, brands, or categories.

Available filters when exporting review

tip

As you reduce the number of items in your export, or change what data should be included, the estimate of the number of records and duration of the export will be updated