How-To: Import Reviews to Stamped.io

Have reviews collected outside of a review app and want to import the reviews to Stamped.io? 

  1. Download the CSV file sample_reviews_import_photos.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

The table below describes the headers of the CSV file (the top row) and types of information that belongs in each column:

Header Name Product Review Information
product_id This is 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
state The status of your review.

published: Reviews visible on site
Leave cell blank to unpublished 
rating A score from 1 - 5, where 5 represents the most positive product review and 1 least positive review.
*Digits only
title A summarize of customer's experience. For example, "Best product ever!"
author The first and last name connected to the customer account that submitted the review
email The customer's email address
location City or Country
body A longer description of the customer's experience.
reply Optional. Response to customer’s review
created_at The date and time when customer submits the review.

Format: YYYY-MM-DD HH:MM:SS
replied_at


Required field if there’s a response to customer’s review. The date and time of response to customer’s review. 

Format: YYYY-MM-DD HH:MM:SS 
photoFilenames
*Premium plan and above
The customer's photo review. An Image URL is required. Seperate each Image URL with a comma.

Here's how you can get the Image URL in the Shopify admin here:
https://myshopify.com/admin/settings/files

Upload the photo and copy the Image URL and paste it to the CSV file.

An example of Image URL: 
https://cdn.shopify.com/s/files/1/0638/7747/products/mug_original_black_real_grande_08f168d9-c69f-4a74-ab49-cff3af6a8de3.png?v=1475639650


Still need help? Contact Us Contact Us