Setup - Import Reviews Into Stamped.io

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

  1. Download this CSV to your Google Sheets account to prepare a file to import the data Stamped---Custom-Review-Template.csv.
    Note: Alternatively, you can directly copy this Google Sheet to your Google Drive and prepare the import file.
  2. 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.
  3. Make sure the date is in the following format:YYYY-MM-DD HH:MM:SS. For example, 2020-12-13 13:00:00.

  4. Make sure the product id is correctly entered, e.g., 44122744568127. Learn more.
  5. 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 changed or removed.

Part B - Upload Reviews

  1. Open a new browser tab and login to Stamped.io
  2. Go to Importer > Import Reviews from the left navigation menu under Settings.

  3. Select Custom under Select provider source

  4. Click Select file and upload the file you downloaded from Google Sheets
  5. 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 softwares, 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 types of information that belongs in each column:

Header Name Description Example
product_id 
(Required)
The product's numeric ID. Here's a guide to locate the Product ID for your platform. 123456
product_handle 
(Optional)
The product handle. Here's a guide to locate the product handle on your platform. goat-mug-16oz
productUrl
(Required)
The product URL in your store https://ex.com/
products/mug
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 select "Copy Image Address" as shown:
https://ex.com/image.jpg
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 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 Goat Mug 16oz (473mL)
rating
(Required)
A score rating of  1 - 5, where 5 represents the most positive product review and 1 the least negative review  5
title
(Optional)
Title of the review

*If left blank, first 5 words of the review body will be used as the title.
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)
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 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 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.
Mugs
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