☸️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"
Step 2: Importing Review into CSV file
In the CSV file, each column serves a specific purpose:
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
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 errorsLast updated