Import Reviews From CSV File

Plans: All plans Platforms: Shopify

Overview

At present, building social proof is significant for customer base expansion, strong brand image, and persistent sales growth. And doing so isn’t tough because all you need is good product reviews on your online store.

AfterShip Reviews helps to import product reviews in two ways:

Import reviews directly from AliExpress
Import reviews from a CSV file

Import reviews from a CSV file

Log in to your AfterShip Reviews account.
Go to Reviews and select Import reviews.
Download the CSV template.

Fill in the review data according to the given instructions.
Upload the file to AfterShip Reviews and hit the **Import **button.

We will drop you an email containing the import summary, once your file gets uploaded successfully. It will give you insights into the number of reviews imported successfully and the number of failed reviews along with error details.

Select the checkbox for Publish all imported reviews if you want the CSV imported reviews to be auto-published without any manual review.

Reviews import via CSV

Instructions to fill the review data

Please do not rename or remove any of the column titles
Required means you have to enter relevant data in that particular field
In the CSV template, there’s a sample data row that you must remove before uploading the document

Sample data row

Header	Description	Example
product_handle (Required)	The last part of the product URL (after “/” and before “?”)	aftership-t-shirt
	For example, the product URL https://demostore.com/aftership-t-shirt?123, the product handle is “aftership-t-shirt”
	Please make sure not to enter the full URL
rating (Required)	Valid values: 1, 2, 3, 4, 5	5
	Please make sure not to enter decimals.
author (Required)	The name of the reviewer.	John Doe
	(Better to enter the full name, you can choose the display format for the name in admin)
title	The title of the review.	Love this product
content (Required)	The review content.	Nice t-shirt and the quality is great.
author_country (Required)	The country of the author.	USA
	You can use the ISO 3166 Alpha-3 country code or the country full name
author_email	The email address of the customer.	example@email.com
	You can leave this column empty if you don’t have the customer’s email.
commented_at (Required)	The date when review is created.	2021-03-01
	Better following this format: YYYY-MM-DD
photo_url_1	A public URL for the review photo. You can leave this empty if you don’t have images.	https://cdn.shopify.com/photo_1.png
photo_url_2	(Make sure you use the appropriate image size and file extension)
	Suggested image size: 428*268 px. or height: width: 1.5 : 1
	Accepted image file extensions:
	→ .apng
	→ .avif
	→ .gif
	→ .jpg, .jpeg, .jfif, .pjpeg, .pjp
	→ .png
	→ .svg
	→ .webp
video_url_1	A public URL for the review videos. You can leave this empty if you don’t have videos.
video_url_2	(Make sure you use the appropriate link format)
	Accepted video links:
	→ Youtube link
	→ Vimeo link
	→ Shopify link
	→ .mp4 link
If you wanna import customized questions, please add a new column and use your Question Key as the header	The question answer
e.g. “Quality”	Please make sure you have set up the relevant customized question forms and using the correct answer format
	Single answer: only accept the preset options you set in this customized question
	Multiple answer: only accept the preset options you set in this customized question, can separate multiple options with “,”
	Rating scale: must be a whole number from 1～5
	Slider: must be a whole number from -1～1
	Plain text: no more than 2000 characters

In case you have no photo or video URL, create it by simply following these instructions:

Go to your Shopify store > Content > Files
Upload the image (JPEG, PNG, WEBP, HEIC, and GIF) or video (MOV/MP4) to get the URL
Copy the link and add it in the CSV file under the photo_urlor video_url column.

Updated on: 13/06/2025