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
• Part B - Upload Reviews
• Tips
• Data fields

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