AiTrillion.com

AiTrillion allows you to easily import product and site / store reviews from other applications into AiTrillion via the CSV import method. Follow the steps below to import your reviews.

Here are the steps to import product or site review:

Step 1 Go to <a href="https://app.aitrillion.com/review/importexport.php" rel="nofollow noopener noreferrer" target="_blank">Product Reviews &gt; Settings &gt; Import Reviews &gt; Product Reviews</a><a href="https://app.aitrillion.com/review/importexport.php" rel="nofollow noopener noreferrer" target="_blank">.</a>

​ ​Step 2: Click on the “CSV template” to download the Sample CSV (an example of the required format).

Step 3: Fill in the data in the downloaded CSV. Then go back to the product review import screen in AiTrillion.

Note📜: Make sure that the first row remains unchanged

Email - {{email}} is not a valid email id.

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

Title - Review title should not be blank.

Review date - Review date is not a valid date - Date must be in the format mm/dd/yyyy.

Review status - Value must be either 0 or 1.

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

- Email - {{email}} is not a valid email id.
- Rating - Rating must be a positive numeric value, and must be between 1 to 5.
- Title - Review title should not be blank.
- Review - Review should not be blank.
- Review date - Review date is not a valid date - Date must be in the format mm/dd/yyyy.
- Review status - Value must be either 0 or 1.
- Status - Status must be one of the following: 'approve' or 'pending' and must not be a numeric value.
- Verified - Value must be either 0 or 1.

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

- Rating - Rating must be a positive numeric value, and must be between 1 to 5.
- Title - Review title should not be blank.
- Email - {{email}} is not a valid email id.
- Body - Body should not be blank.
- Created at - Date must be in the format mm/dd/yyyy.
- Featured - Value must be either 0 or 1.
- Verified - Value must be either 0 or 1.
- Status - Status must be one of the following: 'approve' or 'pending' and must not be a numeric value.

🗒️Featured = 1 - The review which you wish to keep on top 🗒️Verified = 1 - The person who has purchased the product ​

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

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

​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 reason of failed, So that you can update it and import again. This reporting helps you to save the importing time &amp; improve the efficiency of import process.

<a href="https://docs.aitrillion.com/en/articles/9053936-notify-to-customer-that-their-question-has-been-answered">Notify to customer that their question has been answered</a>

💡Tips for Product &amp; Site review

<a href="https://docs.aitrillion.com/en/articles/9053945-can-our-customers-see-all-our-reviews-in-one-place">Can our customers see all our reviews in one place?</a>

<a href="https://docs.aitrillion.com/en/articles/9053996-filter-product-reviews">Filter product reviews</a>

Introduction

Here are the steps to import product or site review:

Advance Review reports