Import Product or Site Reviews | Bring Customer Feedback into AiTrillion

Import Product Or Site Reviews

Introduction

Importing product or site reviews allows you to quickly populate your store with valuable customer feedback, helping build trust and credibility from the start. Instead of collecting reviews from scratch, you can bring in existing reviews from other platforms or previous systems.

With the import feature, you can seamlessly upload and manage reviews, ensuring they are accurately displayed on your product and store pages to enhance customer confidence and drive better conversion rates.


Here are the steps to import a product or site review:

Step 1: Go to Product Reviews >> Collect reviews >> Import reviews




Step 2: Click on the Product reviews tab to import product reviews CSV or click on the Site review tab to import Site reviews CSV, and click on Sample CSV to download the template. This file includes the required headers, which must not be modified when uploading reviews to AiTrillion.



Step 3: Fill in the data in the downloaded CSV. Then go back to the product review import screen in AiTrillion.
Notes
Note: Make sure that the first row remains unchanged

Site Review

  • customerName - Name of the customer who submitted the review.

  • Email - Customer’s email address. Email field must contain a valid email address.

  • Rating - Rating must be a positive numeric value, and must be between 1 to 5.

  • Title - Short title or headline of the review. Review title should not be blank.

  • Review - Detailed feedback or comment provided by the customer. The review should not be blank.

  • Review date - Date when the review was submitted. Date must be in the format mm/dd/yyyy.

  • Location - Customer’s location (e.g., country code like US, IN, etc.).

  • Review status - The value must be either 0 or 1. A value of 0 means the review is not published, while 1 indicates that it is published. Keep this value as 0 unless specified otherwise.

  • Status - Approval status of the review. Status must be one of the following: 'approve' or 'pending' and must not be a numeric value.

  • Verified -  Indicates whether the review is verified. Value must be either 0 or 1. Verified means that customers have purchased the product from the store.

  • Source - Source of the review import, such as CSV or any other app.

Product review

  • handle - Identifies which product the product reviews belong to.

  • Rating - Rating given by the customer. Rating must be a positive numeric value, and must be between 1 to 5.

  • Title - Title or headline of the review. Review title should not be blank.

  • Author - Name of the person who uploaded the review.

  • Email - Customer’s email address. The email field must contain a valid email address.

  • Body - The body or the feedback or commented porvided by the customers. The body should not be blank.

  • Created at - Date must be in the format mm/dd/yyyy.

  • Featured - Featured reviews mean the review which you would like to keep on the top. Value must be either 0 or 1.

  • Verified -  Indicates whether the review is verified. Value must be either 0 or 1. Verified means that customers have purchased the product from the store.

  • Location - Customer’s location (e.g., country code like US, IN, etc.).

  • Status - Status must be one of the following: 'approve' or 'pending' and must not be a numeric value.

  • Image - The image uploaded by the customer for the product.

  • Admin reply - The reply that has been replied by you or the store owner.


Idea

Note: handle = URL handle



Info


Featured = 1 - The review that you wish to keep on top
Verified = 1 - The person who has purchased the product



Step 4: Click on the Upload CSV, click on Choose File, and select that CSV file, and then click on Import Reviews.


Notes
Note: Follow the same steps to import the site reviews. However, in Step 1, instead of clicking on Product Reviews, click on Site Reviews!

Advance Review reports




The review import reporting provides detailed insights into your review imports, offering clarity on successfully imported and failed reviews, also provide you the ability to directly download failed review CSV with the reason of failed, So that you can update it and import again. This reporting helps you to save the importing time & improve the efficiency of import process.
The review import details include:
  • File name – Name of the uploaded CSV file.
  • Status – Shows the current status of the import (e.g., Completed).
  • Created count – Number of reviews successfully imported.
  • Error count – Number of reviews that failed during import.
  • Failed CSV – Download a file containing rows that failed, along with error details.
  • Media syncing (Product Reviews only) – Indicates whether review images/media have been successfully processed. 

Important Notes

  • Always use the Sample CSV format and do not modify the column headers.
  • Ensure all required fields are filled correctly to avoid import errors.
  • Keep the date format consistent (recommended: dd/mm/yyyy).
  • Each row in the CSV should represent one review only.
  • Make sure the product handle matches exactly with your store data.
  • Use valid email addresses for proper review association.
  • Ratings should be numeric values (e.g., 1 to 5) only.
  • Values like status, verified, and featured must follow the accepted format (e.g., 0 or 1, approve/pending).
  • A Completed status does not guarantee all reviews were imported—always check the Error count.
  • Download the Failed CSV to identify and fix any errors before re-uploading.
  • For product reviews with images, ensure media URLs are valid and accessible.

    • Related Articles

    • Product Review Program To-do points before the launch

      Introduction Launching a Product Review Program is a powerful strategy to gather authentic feedback, enhance your product's credibility, and drive customer engagement. However, careful planning and preparation are crucial to ensure the program's ...

    • Export Product or Site Reviews

      Introduction In this article, we'll explore method to export product or site reviews seamlessly, empowering you to leverage this valuable data to enhance your business strategies and customer experiences. Here are the steps to export Product or Site ...

    • Share Product or Site reviews on Social Media

      Introduction Sharing product or site reviews on social media helps extend your brand’s reach while building trust with a wider audience. When real customer feedback is showcased on platforms like social networks, it acts as social proof and can ...

    • Setup Product And Store Reviews

      Introduction Customer reviews play a key role in influencing purchase decisions and building trust with your audience. Setting up Product and Store Reviews allows you to collect valuable feedback, showcase customer experiences, and strengthen your ...

    • Customize Site & Product Review Button On Store

      Introduction You can easily customize the review button on your Shopify store. Sample Button shared below: Steps to customize: Follow the below steps to customize the site review button: Step 1: Go to Product Reviews > Settings > General Settings ...