Articles on: Getting Started

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:



a. Import reviews using the CSV file from supported third-party review apps.

b. Import review using the AfterShip Reviews CSV template.


A. Import reviews using the CSV file from supported third-party review apps


  1. Log in to your AfterShip Reviews account.
  2. Go to Reviews and select Import reviews.
  3. In the Import from CSV file section, select the review app from the dropdown.
  4. Click Upload CSV to upload the exported reviews file from the review app.
  5. Click Import file.



  • 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 in the information box.


How to migrate historical reviews from the supported third-party apps?


To export reviews data from the supported third-party reviews apps, please refer to the help guides of each or visit their respective resource sections.



Other supported apps



B. Import review using the AfterShip Reviews CSV template


  1. Log in to your AfterShip Reviews account.
  2. Go to Reviews and select Import reviews.
  3. In the Import from CSV file section, select Use AfterShip Reviews template from the dropdown.
  4. Click Upload CSV.
  5. On the Import by CSV module,


  • Download the CSV template
  • Fill in the review data according to the given instructions.
  • Upload the file to AfterShip Reviews and hit the Import file button.
  • 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 in the information box.



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. Tip: To find a Shopify product handle, navigate to the product page in your Shopify admin, and locate the "Search engine listing" section. The product handle is the text that follows /products/ in the product's URL or in the "URL and handle" section. It is a unique, URL-friendly identifier for the product.

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

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

Status (Required)

The publish status of the review. Accepted value can either be “published” or “unpublished”

published

Question Key

The question answer

If you wanna import customized questions, please add a new column and use your Question Key as the header, 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.



How to fix review upload errors?


The reviews that fail to upload to your AfterShip Reviews account either using the third-party review apps or AfterShip Reviews CSV template, here are the quick steps to fix them.


  1. On the import by CSV popup, click Download and continue to download the reviews error file.
  2. Open the error file. Under the error column, find the reason of review import failure. Fix the error in the CSV template and upload it again.



  1. Click Import file to import fixed reviews again.


Updated on: 28/07/2025