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

  1. Download the CSV file Stamped---Custom-Review-Template.csv
  2. Fill in the details of the reviews
  3. Import them to our app by going to Settings - Importer - Import Reviews
  4. Click the drop-down box at 'Provider Source', select 'Custom Platform'
  5. 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 Number of upvotes for the review 1
votes_down Number of downvotes for the review 2

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.