Importing Reviews Using CSV File

Modified on Mon, 6 Oct at 11:41 AM

In this article, we will cover the process of importing reviews to TrustZ using a custom file, how to format your review data correctly, and how to troubleshoot common import errors to ensure a smooth process.

Importing reviews using a CSV file

To import reviews using a custom file:

1. Click the Import Reviews button in the Product Reviews section of your TrustZ admin.

2. Select TrustZ Template.

3. Download the template, or make a copy of it, and add your review data following the required format (see Review formatting guidelines below).

4. Save your completed file in CSV format.

5. Return to the TrustZ app and upload your file.

6. During the import process, you’ll see a banner showing the progress - it will disappear once the process is complete.

7. Imported reviews will appear under your selected product.

If any reviews fail to import, a modal will display an error message, allowing you to correct the issue before re-importing.

Note: You can import up to 100,000 reviews per store using a custom file. After reaching this limit, additional imports will not be possible using this method.

Review formatting guidelines

To ensure a successful import, your review data must match the template’s format. Below are the required fields and formatting guidelines:

Column Title	Description	Example
product_handle (Required)	The handle is the last part of the product URL (after /products/)	t-shirt
rating (Required)	Whole number between 1 and 5	5
reviewer_name (Required)	The reviewer's name. This will appear exactly as listed.	Alex D.
email	The reviewer's email address (optional).	example@email.com
review_content (Required)	The review text. Must contain at least one character.	This is the best blue hoodie I've ever seen
review_date (Required)	The date the review was submitted, in YYYY-MM-DD format.	2025-10-09
photo_url	Public URL(s) of review images (comma-separated for multiple images)	cdn.shopify.com/photo.png

Note:

To upload multiple photos (up to 5 per review), separate image URLs with commas under the photo_url column.
Image files must be in JPG, JPEG, or PNG format. Make sure URLs do not include trailing characters after .jpg, .jpeg, or .png.

Fixing Review Import errors

This section will indicate the reason each review failed, categorized into two types: File Formatting Errors and File Processing Errors.

Please update the CSV file based on the descriptions below and re-upload it following the same import process.

File Formatting Errors

These errors occur when the review data does not meet the required format.

Error	Description	How to fix
Product not found	The value in the product_handle column is missing or does not match an active product in your store	Ensure it matches the last part of the product URL and is linked to an active product
Review date invalid	The created_at field is missing or incorrectly formatted	Use the YYYY-MM-DD format (e.g., 2025-10-09)
Review date cannot be in the future	The date in the created_at field is set in the future	Adjust it to a past date
Reviewer's name is missing	The reviewer name field is missing	Enter a reviewer name.
Review content is missing	The review content field is missing	Ensure that all reviews include text
Rating invalid	The rating field is missing or is not a whole number between 1 and 5	Use whole numbers only (1, 2, 3, 4, 5)
Photo URL invalid	The photo_url field is missing or incorrectly formatted	Ensure URLs link to valid JPG, JPEG, or PNG images

File Processing Errors

These errors occur due to issues with the file itself.

Error	Description	How to fix
Missing columns	One or more required columns are missing	Ensure all template columns are included
Corrupted file	The file is corrupted or unreadable	Try re-saving or exporting it again in CSV format
File too heavy	The file exceeds the maximum allowed size (15MB max)	Reduce the number of reviews or optimize the file size before uploading.
Empty file	The file has no content or rows of data	Ensure it contains valid review information before uploading

FAQs

Question: What is the maximum number of reviews I can import?

Answer: You can import up to 100,000 reviews per store using a custom file. After reaching this limit, additional imports will not be possible using this method. For assistance, contact support.

Question: How do I generate a photo URL?

Answer:

Save the relevant image to your computer.
Go to your Shopify ״Files״ menu within "Content".
Click "Upload files".
Upload your image.
Copy the photo link.

Question: Can I import video reviews using a custom file?

Answer: TrustZ currently only supports importing text and photo reviews using a custom file.