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 Kudosi template fields.
Import reviews using Kudosi template
Format the template fields
Steps to get product handle
Steps to publish an image link
From the Kudosi dashboard:
Click Import reviews in the side menu.
Click Import CSV file at the top-right of the Import reviews page.
Click the button labeled Select products in the guideline.
This step opens a modal where you can select the products you want to import reviews for.
Why this step matters
We recommend selecting products before downloading the CSV file or using a spreadsheet template because the product handle column is required.
As you select products, their product handles will be auto-filled or copied automatically depending on the import method you choose.
Pre-selecting products simplifies the process, saving you the effort of searching for product handles manually.
There are two methods to import reviews via CSV file:
After selecting products, click the Download CSV file button. The template will download to your computer.
If you selected products beforehand
The product handle column will already be auto-filled with the handles of the selected products.
Complete the remaining fields:
Country code (Optional)
Customer name (e.g., John Doe)
Star rating (1 to 5)
Text reviews (Optional)
Published date (format: YYYY/MM/DD)
Optional: Up to 5 image links (provide direct image URLs)
Refer to this guide for instructions on how to format import fields.
Save the completed file.
If no products were selected before downloading
The CSV file will be empty.
You will need to manually find and fill in the product handles and other fields.
Refer to this guide for instructions on how to get product handles.
When using the spreadsheet template method, product handles for the selected products are copied automatically.
Steps to complete the process:
Select the products you want to import.
Click Use spreadsheet template.
In the modal, click Make a copy template.
Click Make a copy.
In the Kudosi import template:
When the template opens, paste the product handles into the product handle column:
Click on cell A4.
Press Ctrl/⌘ + V to paste the handles.
This will auto-fill all product handles.
Complete the remaining fields:
Country code (Optional)
Customer name
Star rating
Text reviews (Optional)
Published date
Optional: Up to 5 image links
Refer to this guide for instructions on how to format import fields.
Download the completed file:
After completing the template, go to File > Download > Comma Separated Values (.csv).
Do not change column names or labels. When filling out the Kudosi template, ensure you do not change the column names or labels of the fields (e.g., Product handle, Text reviews, Customer name). Changing these will cause the import process to fail. If you get an "invalid column name found" error during import, you need to:
Use the official Kudosi import template
Compare your import file's column names with the template
Rename columns in your file to match the template exactly (case-sensitive)
Return to the Import reviews page.
Upload the completed CSV file.
Click Import now.
To import reviews from a CSV file successfully, you need to complete the Kudosi template. There are 7 columns in the Kudosi template:
Product handle
Customer country code (Alpha-2 code) (optional)
Customer name
Star rating
Text reviews (optional)
Published date
Image link (optional)
From the Shopify admin:
Click Products in the side menu > select the product you want.
Scroll down to the Search engine listing section and click Edit.
Find the URL handle field > Copy everything after /products/ in the URL.
Another way to get product handle:
Go to a live product page on your store.
Look at the URL in your browser.
The product handle is the part of the URL that comes after your store domain.
Example:
Product URL: https://skinmeltest123.myshopify.com/products/40ml-repair-cream
Product Handle: 40ml-repair-cream
From Shopify admin:
Go to 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 [creating a public image link].
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 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
On this page
Import reviews using Kudosi template
Format the template fields
Steps to get product handle
Steps to publish an image link
Import reviews using Kudosi template
Access import CSV file feature
From the Kudosi dashboard:
Click Import reviews in the side menu.
Click Import CSV file at the top-right of the Import reviews page.
Step 1: Select products
Click the button labeled Select products in the guideline.
This step opens a modal where you can select the products you want to import reviews for.
Why this step matters
We recommend selecting products before downloading the CSV file or using a spreadsheet template because the product handle column is required.
As you select products, their product handles will be auto-filled or copied automatically depending on the import method you choose.
Pre-selecting products simplifies the process, saving you the effort of searching for product handles manually.
Step 2: Fill in the required fields in the Kudosi template
There are two methods to import reviews via CSV file:
Method 1: Download CSV file
After selecting products, click the Download CSV file button. The template will download to your computer.
If you selected products beforehand
The product handle column will already be auto-filled with the handles of the selected products.
Complete the remaining fields:
Country code (Optional)
Customer name (e.g., John Doe)
Star rating (1 to 5)
Text reviews (Optional)
Published date (format: YYYY/MM/DD)
Optional: Up to 5 image links (provide direct image URLs)
Refer to this guide for instructions on how to format import fields.
Save the completed file.
If no products were selected before downloading
The CSV file will be empty.
You will need to manually find and fill in the product handles and other fields.
Refer to this guide for instructions on how to get product handles.
Method 2: Use spreadsheet template
When using the spreadsheet template method, product handles for the selected products are copied automatically.
Steps to complete the process:
Select the products you want to import.
Click Use spreadsheet template.
In the modal, click Make a copy template.
Click Make a copy.
In the Kudosi import template:
When the template opens, paste the product handles into the product handle column:
Click on cell A4.
Press Ctrl/⌘ + V to paste the handles.
This will auto-fill all product handles.
Complete the remaining fields:
Country code (Optional)
Customer name
Star rating
Text reviews (Optional)
Published date
Optional: Up to 5 image links
Refer to this guide for instructions on how to format import fields.
Download the completed file:
After completing the template, go to File > Download > Comma Separated Values (.csv).
Note:
Do not change column names or labels. When filling out the Kudosi template, ensure you do not change the column names or labels of the fields (e.g., Product handle, Text reviews, Customer name). Changing these will cause the import process to fail. If you get an "invalid column name found" error during import, you need to:
Use the official Kudosi import template
Compare your import file's column names with the template
Rename columns in your file to match the template exactly (case-sensitive)
Step 3: Upload the downloaded CSV file and click "Import now"
Return to the Import reviews page.
Upload the completed CSV file.
Click Import now.
Format the template fields
To import reviews from a CSV file successfully, you need to complete the Kudosi template. There are 7 columns in the Kudosi template:
Product handle
Customer country code (Alpha-2 code) (optional)
Customer name
Star rating
Text reviews (optional)
Published date
Image link (optional)
| Fields | Description | Example |
|---|---|---|
| 1. Product handle | A unique, simplified identifier for a product used in its URL on Shopify. It typically consists of lowercase letters, numbers, and hyphens. | Product URL: https://yourstore.myshopify.com/products/original-eucerin-facial-sunscreen ; Product handle: original-eucerin-facial-sunscreen |
| 2. Customer country code (Alpha-2 code) (Optional) | 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 |
| 3. Customer name | The reviewer's name. | Anna |
| 4. Star rating | The star rating. Valid values from 1 to 5 are supported. | 2 |
| 5. Text reviews (optional) | The written content of a customer's review | Excellent price with high quality. I will definitely buy it again. |
| 6. Published date | Follow the pattern: mm/dd/yyyy, mm/dd/yy, or dd/mm/yyyy. 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 |
| 7. Image Link (optional) | To import review images, make sure that the image URL is published, and follow accepted formats: .jpg, .jpeg, .png, .avif or .gif. The maximum number of images in a review is 5 | 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 |
Steps to get product handle
From the Shopify admin:
Click Products in the side menu > select the product you want.
Scroll down to the Search engine listing section and click Edit.
Find the URL handle field > Copy everything after /products/ in the URL.
Another way to get product handle:
Go to a live product page on your store.
Look at the URL in your browser.
The product handle is the part of the URL that comes after your store domain.
Example:
Product URL: https://skinmeltest123.myshopify.com/products/40ml-repair-cream
Product Handle: 40ml-repair-cream
Steps to publish an image link
From Shopify admin:
Go to 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 [creating a public image link].
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 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: 27/12/2024
Thank you!