Import Reviews From CSV File
Plans: All plans Platforms: Shopify
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
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.
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
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_url`or video_url column.
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.
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
| 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 (Required) | 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_url`or video_url column.
Updated on: 04/04/2025
Thank you!