Shopify Importing Custom Review

Have collected reviews outside of a review app and want to import the reviews to our app? Here's how you can do so.
*Note: Only applicable to Shopify Platform

  1. Download CSV File
  2. Fill in the details of the reviews
  3. Import them to our app, here
  4. Click the drop-down box at 'Import Review', select 'Shopify Product Review'
  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:

Need an example to refer? Click here

Header Name Product Review Information
product_handle This is the tail end of your product's URL.

Here's an example in bold:
https://www.gatomall.com/products/goat-mug-12oz
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


Requied 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 & 
Enterprise plan
The customer's photo review. An Image URL is required.

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