Importing reviews from a CSV file
In this article, we will learn the steps for importing existing reviews from a CSV file and how to fill in review data in the Ali Reviews template fields.
Import reviews using Ali Reviews template
Format the template fields
Steps
From the Ali Review dashboard > click Import Reviews in the side menu > click Import CSV file in the top right of the import reviews tab.
From the spreadsheet in the left-sidebar, click the Ali Reviews template. This will open a new tab, which is the Ali Reviews spreadsheet template.
From the Ali Reviews template, select File > Make a copy.
Delete all sample data in the template, then complete all your data on the copied template fields. Read format the template fields
After filling in all information in the copied template, select File > Download > Comma Separated Values (.csv).
Upload the downloaded CSV file, and check the box I agree to the terms of service.
Click Import now.
Note: The maximum file size for uploading is 5MB.
To import reviews from a CSV file successfully, you need to complete the Ali Reviews template. There are 8 columns in the Ali Reviews template:
Customer country code (Alpha-2 code)
Product ID
Customer name
Rating
Content
Customer email (optional)
Published date
Image link (optional)
Steps to get product ID:
From the Shopify admin > click Products in the side menu > select product you want > copy the product ID in the URL.
Steps to publish an image link:
From the Shopify admin > Content > Files > Upload files.
After uploading the image into Shopify files, copy the image link and paste it into the image link field.
There are more ways to publish image links, and you can learn more about publishing image links.
That’s how to import reviews from a CSV file. In case you get errors while importing reviews from a CSV file, please read the article to fix CSV file import review errors.
If you need some more help, please feel free to contact us via live chat or email us at support@fireapps.io.
Related articles:
Fixing common importing errors
Fixing CSV file import review errors
From this page
Import reviews using Ali Reviews template
Format the template fields
Import reviews using Ali Reviews template
Steps
From the Ali Review dashboard > click Import Reviews in the side menu > click Import CSV file in the top right of the import reviews tab.
From the spreadsheet in the left-sidebar, click the Ali Reviews template. This will open a new tab, which is the Ali Reviews spreadsheet template.
From the Ali Reviews template, select File > Make a copy.
Delete all sample data in the template, then complete all your data on the copied template fields. Read format the template fields
After filling in all information in the copied template, select File > Download > Comma Separated Values (.csv).
Upload the downloaded CSV file, and check the box I agree to the terms of service.
Click Import now.
Note: The maximum file size for uploading is 5MB.
Format the template fields
To import reviews from a CSV file successfully, you need to complete the Ali Reviews template. There are 8 columns in the Ali Reviews template:
Customer country code (Alpha-2 code)
Product ID
Customer name
Rating
Content
Customer email (optional)
Published date
Image link (optional)
| Fields | Description | Example |
|---|---|---|
| 1. Customer country code (Alpha-2 code) | The two-letter country code represents the location of the reviewers. Click here to see the full list of country codes. | US: United States, AU: Australia |
| 2. Product ID | The product ID is a sequence of digits found in the last part of the product URL from the Shopify admin. | This is an example of product URL from Shopify admin: https://admin.shopify.com/store/skinmeltest123/products/8168837578940. “8168837578940” is product ID |
| 3. Customer name | The reviewer's name. | Anna |
| 4. Rating | The star rating. Valid values from 1 to 5 are supported. | 2 |
| 5. Content | The review text | Excellent price with high quality. I will definitely buy it again. |
| 6. Customer email (optional) | The reviewer's email address. You can leave this field empty if you don’t have the customer’s email. | Ryanwitt@gmail.com |
| 7. Published date | Follow the pattern: mm/dd/yyyy or mm/dd/yy. Make sure the date format is consistent across the entire published date column. yyyy and yy is the year; mm is the month; dd is the day. | 10/12/21 |
| 2. Image Link (optional) | To import review images, make sure that the image URL is published, and follow accepted formats: .jpg, .jpeg, .png, or .gif. The maximum number of images in a review is 5, and each one separated with a comma | https://cdn.shopify.com/s/files/1/0633/7835/8460/files/tay-te-bao-chet-ca-phe-5_4a1d81f3-62ba-4d5d-9892-77b4dbe48fe5.jpg?v=1704188405,https://cdn.shopify.com/s/files/1/0633/7835/8460/files/Body-Sunscreen.jpg?v=1704188234 |
Steps to get product ID:
From the Shopify admin > click Products in the side menu > select product you want > copy the product ID in the URL.
Steps to publish an image link:
From the Shopify admin > Content > Files > Upload files.
After uploading the image into Shopify files, copy the image link and paste it into the image link field.
There are more ways to publish image links, and you can learn more about publishing image links.
That’s how to import reviews from a CSV file. In case you get errors while importing reviews from a CSV file, please read the article to fix CSV file import review errors.
If you need some more help, please feel free to contact us via live chat or email us at support@fireapps.io.
Related articles:
Fixing common importing errors
Fixing CSV file import review errors
Updated on: 28/03/2024
Thank you!