Import reviews from other apps (CSV)

This feature helps you import reviews from any sources using .csv files.

On this page

• Import custom files

• Import from other apps

• Import from LAI Product Reviews

Use a custom CSV file

Fill in the LAI template with your review data

info

This is LAI Review CSV template.

• Please follow these steps:

  • 1. Make a copy of this file: LAI Review CSV template.

  

  • 2. Fill in the review data to the template.
  caution

  Do not rename or remove any of the columns including the column titles.

  info

  Product identifiers (required) may be Product ID, Product handle or Product name.

  You can choose one of three Product identifier types to fill in to match reviews in your CSV file with products listed in LAI app.

LAI CSV template detail:

Column Title	Description	Title
Product_id	To get an ID number, from your Shopify admin, you go to Products > Click the name of the product > The last numbers of this product page link is the ID number
Product_handle	To get the Product handle, please visit product URLs > copy the last part following product/	3-fraft-easy-cheese-cheddar-in-can-80z is the product handle.
Product_name	To get the Product name, please visit Shopify Admin site > Products > click products > choose specific pnes and copy their names.
Customer_name (Required)	The name of the customer (The name will appear on the review exactly as inserted here)	Jillian Le
Content (Required)	The text of the review	Highly recommend this product!
Photo	A public URL for the review photo. Use this template: link photo 1,link photo 2,link photo 3 *Note: If you don’t have a photo URL, you can create one by following these instructions: 1. Save the relevant images to your computer 2. Go to your Shopify settings - Files 3. Click "Upload files" 4. Choose one of the images and upload it Copy its photo URL from the "URL" column once it has been uploaded	Example format of uploading 1 photo: https://www.rei.com/media/6ade2f52-f8d9-4bea-9634-b68a57777db5?size=512x682​,https://images-na.ssl-images-amazon.com/images/I/81B6-uzku8L._UL1500_.jpg
Emails (optional)	You can leave this column empty if you don’t have the customer’s email address	[email protected]
Rating (required)	Valid values are 1/2/3/4/5 Please use whole numbers only.	5
Date (Required)	You can choose different available or self-customized date formats.
Country	The 2-letter country abbreviation codes. If you don’t know these codes, please look up at this page: https://laendercode.net/en/2-letter-list.html​	Canada is written as CA

Step 2: Download it as a CSV file

• Click to "File" > "Download" > "Comma-separated values (.csv, current sheet)".

Step 3: Upload the downloaded CSV file to LAI app

• Go to LAI app > Manage Reviews > Import > Select CSV > select Import custom files > upload the file.

• After uploading the CSV file, our system will match all columns automatically for you. All red-asterisked fields are required to be matched. If you need to adjust, please click on Edit column.

• After submitting the file, the file will be in Importing state, please reload the page to show other states of the file. You can download reports for import processes by clicking on Download report at Import queues section.

danger

Note: CSV file can be formatted wrong when it's opened by Excel. For the best result, suggest merchants edit data by **Google Sheet template, try not to edit data by Excel. **When data is all set, save it as a CSV file and then upload that file to our app right away.

Import from other apps

How it works

• Step 1: Please prepare a standard template of one of review apps below:

  • LAI Product Reviews

  • Judge.me Product Reviews

  • Loox Product Reviews & Photos

  • Stamped Product Reviews & UGC

  • Opinew Product Reviews App UGC

  • Rivyo Product Reviews & QA

  • Fera Product Reviews App

  • Trustoo Product & Ali Reviews

  • Product Reviews

• Step 2: Go to LAI app > Reviews > Import and Export > Import from other apps > select one review app > upload the file.

• Step 3: Click on Import and wait for reviews imported.

Import from LAI Product Reviews

• Step 1: Export reviews from LAI Product Reviews.

• Step 2: Go to LAI app > Reviews > Import and Export > Import from LAI Product Reviews > upload the file.

• Step 3: Click on Import and wait for reviews imported.

info

Replace existing reviews: Reviews in our app are replaced with some having similar review_IDs in the file you upload.

If you need any more help, please contact our support team via live chat or send emails to [email protected]