☸️Import review from CSV/XLSX using All star template

A great tool to easily import genuine product reviews onto your Store in large quantities

All star provides a user-friendly import process, allowing easy import of reviews from various apps without CSV/XLSX file changes. Additionally, you can import reviews directly from AliExpress.

Even if you have reviews from sources not directly supported by All star, their CSV/XLSX template enables you to import these reviews efficiently into the All star system.

Step 1: Create and Import CSV/XLSX file with All star

• Open the All star import template in Google Sheets

• Click "Make a copy"

Tip: Google Sheets is free, works well on most devices, and automatically saves the file as CSV without introducing unsupported characters.

Step 2: Importing Review into CSV file

In the CSV file, each column serves a specific purpose:

Content_review	required	body of the review (up to 5000 characters). If the content_review is empty, the import will fail
Rating	required	the review rating (1-5)
Review_date	required	the date the review was created (mm/dd/yyyy hh:mm:ss). If empty, the import review will fail
Reviewer_name	required	name of the reviewer. If empty, the import review will fail
Reviewer_email	required	email of the reviewer. If empty, the review import will fail
Product_ID	optional	If you fill a product ID, the review will be assigned to that product. Otherwise, the review will be counted as a storage review
Reply	optional	the public reply of the review
Picture_URLs	optional	URLs of the images in the review. Supported .png, .jpg, .If there is more than one picture, please separate images by new lines, 1 image per line We accept up to 5 pictures per review. If there are more than 5 URLs, we will only take the first 5.

How to get product_ID?

In the product details on Shopify Admin, you may see a series of numbers in the search bar. That is the product_ID of the product

How to get product_ID

Step 3: Upload and Import File to All star

• Once you've added the reviews, download the sheet by going to File > Download > Comma Separated Value (.csv) or Microsoft Excel (.xlsx)

• From your All star Admin, go to Import Review > CSV/XLSX File

• Upload the CSV/XLSX file and click Import file

Related Articles

Fixing import errors