Have reviews collected outside of a review app and want to import the reviews to Stamped? Stamped lets you import reviews from any source through CSV.
Note: If you are migrating from another review platform, kindly check out the following document and see if your export file is eligible for direct import as the format of the custom import is different: Migrating Existing Reviews.
In This Guide
How To Import Your Reviews
Part A - Formatting the CSV
- Directly copy this Google Sheet to your Google Drive and prepare the import file.
- Fill in the details of the reviews in the same format as the sample reviews in row #2 and #3. You can remove this sample review later.
- Make sure the date is in the following format:YYYY-MM-DD HH:MM:SS. For example, 2020-12-13 13:00:00.
- Make sure the product id is correctly entered, e.g., 44122744568127. Learn more.
- Download the formatted review data to your local PC in the CSV format as shown in the screenshot:
Important
- Make sure there are no empty rows or duplicate entries.
- Make sure the date is in the recommended format (#3).
- You can choose to fill product_handle instead of product_id if you wish. But make sure the product_id column or other fields are intact.
- The default headers in the template shouldn’t be changed or removed.
Part B - Upload Reviews
- Open a new browser tab and log in to Stamped
- Go to Importer > Import Reviews from the left navigation menu under Settings.
- Select Custom under Select provider source
- Click Select file and upload the file you downloaded from Google Sheets
- Click Upload
Voila! Your reviews are now imported. Go to Reviews and start moderating :)
Tips
- Update the published column as per your requirement, for example, TRUE to set the review status as Published and FALSE to keep a negative review unpublished
- In the location column, you can either enter the full name or the country code, e.g., United States or US (ISO 3166-1 alpha-2 format)
- You can prepare the CSV using any decent editor or spreadsheet software, however, some programs like MS Excel tend to convert the values into scientific notation which might corrupt the intended format. Also, it may change the date format. We recommend using the above-linked Google Sheet instead for a smoother experience.
Data Fields
The table here describes the headers of the CSV file (the top row) and the types of information that belong in each column:
| Header Name | Description | Example |
| product_id (Required) |
The product's numeric ID. Here's a guide to locating the Product ID for your platform. | 123456 |
| product_handle (Optional) |
The product handle. Here's a guide to locating the product handle on your platform. | sweater-black |
| productUrl (Required) |
The product URL in your store | https://ex.com/ products/sweater |
| productImageUrl (Required) |
The image URL of the product. Unsure of how to get your product image URL? You can retrieve your product image URL by right-clicking on the product image, and selecting "Copy Image Address" as shown: |
|
| photoFilenames *Only paid plans |
This is where you copy the customer's photo. An Image URL is required for each photo and they have to be separated by a comma. Note: i) A maximum of 3 photos is allowed for each review ii) You can upload the photos to the Shopify files section or file sharing service, like Dropbox, and copy the source link. |
https://ex.com/image.jpg |
| videoFilenames *Buisness Plan & above |
Specify the URL of the video here, similar to photo reviews. * Only one video is allowed for each review |
https://ex.com/video.mp4 |
| productTitle (Required) |
The title of the product | Wool Sweater - Black |
| rating (Required) |
A scored rating of 1 - 5, where 5 represents the most positive product review and 1 is the least negative review | 5 |
| title (Optional) |
Title of the review | Super awesome product! |
| author (Required) |
Name of the reviewer | John Doe |
| email (Optional) |
Email address of the reviewer * Will not be shown on display widgets |
johndoe@example.com |
| body (Required) |
The main content of the review | Super awesome product and I love it! You should get one too! |
| created_at (Required) |
The date and time when the customer submits the review. Format: YYYY-MM-DD HH:MM:SS |
2018-12-12 12:00:00 |
| published (Optional) |
TRUE: Reviews visible on site. If left blank or other values: Reviews will be imported unpublished in the dashboard. |
TRUE |
| reply (Optional) |
Response to the customer review | Thank you for your kind review! |
| replied_at (Required if "reply" is filled) |
The date and time of response to customer review. Format: YYYY-MM-DD HH:MM:SS |
2018-12-13 13:00:00 |
| publishedReply (Optional) |
FALSE: Replies will not be visible on the site. If left blank or other values: Replies will be imported as published. |
FALSE |
| tags (Optional) |
Tags to be attached to the review– more information on the feature. |
Jacket |
| recommended (Optional) |
For reviews that recommend the product– more information on the feature. | TRUE |
| votes_up (Optional) |
Number of upvotes for the review | 1 |
| votes_down (Optional) |
Number of downvotes for the review | 2 |
| location (Optional) |
Country of the customer | Singapore |
| featured (Optional) |
The review will be marked as featured– more information on the feature. | TRUE |