Setup - Import Reviews Into Stamped.io
Have reviews collected outside of a review app and want to import the reviews to Stamped.io?
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: Migrating Existing Reviews
In This Guide
How To Import Your Reviews
- Download the CSV file Stamped---Custom-Review-Template.csv
- Fill in the details of the reviews
- Import them to our app by going to Settings - Importer - Import Reviews
- Click the drop-down box at 'Provider Source', select 'Custom Platform'
- Upload CSV file
CSV Template Guidelines
The table below 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: https://help.stamped.io/article/111-how-to-finding-product-ids-in-your-e-commerce-platform |
123456 |
| productUrl (Required) |
The product URL in your store | https://www.gatomall.com/products/goat-mug-16oz?variant=11688002947 |
| productImageUrl (Required) |
The image URL of the product |
https://cdn.shopify.com/s/files/1/0638/7747/products/gatomall.goatmug.brown_a856c4cd-68c4-45bc-9914-484375cd5598.png?v=1461570973 |
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:
| Header Name | Description | Example |
| photoFilenames *Only paid plans |
The customer's photo review. An Image URL is required. Separate each Image URL with a comma (,) Note: A maximum of 3 photos is allowed for each review |
https://cdn.shopify.com/s/files/1/0638/7747/products/mug_original_black_real_grande_08f168d9-c69f-4a74-ab49-cff3af6a8de3.png?v=1475639650 |
| productTitle (Required) |
The title of the product | Goat Mug 16oz (473mL) |
| rating (Required) |
A score rating from 1 - 5, where 5 represents the most positive product review and 1 least positive 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 Doh |
| email (Optional) |
Email address of the reviewer * Will not be shown on any display widgets |
johndoh@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’s review | Thank you for your kind review! |
| replied_at (Required if "reply" is filled) |
The date and time of response to customer’s review. Format: YYYY-MM-DD HH:MM:SS |
2018-12-13 13:00:00 |
A Note On CSV File
Our users have experienced issue getting data to save properly in a CSV file using Microsoft Excel, especially for lengthy product IDs and date format. We recommend exporting the file as CSV in Google Sheets instead, which will normally resolve any issues.