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
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.
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 |
| 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 or YES |
| 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 |
