Import Reviews From CSV file
Overview
First, you need to prepare a CSV file containing the data of the reviews, contains necessary data fields, such as author name, content, title, rating, product handle, ... There is one column you need to pay attention to, which is the product handle, which is the bridge to help the reviews display properly on the product you want. It should match the handle of the product you want to import the review into.
Product handle in Shopify
This is the tail end of your product's URL. For example, if your product appears on your online store at https://a2reviews.myshopify.com/collections/frontpage/products/professional-makeup-brush-set, then the product_handle is professional-makeup-brush-set.
product_handle
This is the tail end of your product's URL. For example, if your product appears on your online store at https://a2reviews-shopify.com/products/blue-t-shirt, then the product_handle is blue-t-shirt.
rating
A score from 0-5, where 5 represents the most positive product review.
title
A short, bolded title summarizing the customer's experience. For example, "Awesome!"
author
The first and last name connected to the customer account that submitted the review.
The customer's email address.
country_code
The customer's address, such as their city and country.
content
A longer description of the customer's experience. They can elaborate on what they liked or did not like about your product.
images
It is an array containing image links, for example ["url1", "url2", "url3", ...] or url1, url2, url3, ....
created_at
The date and time when the product review was created by the customer.
Import reviews from a CSV file
From A2Reviews app (app.a2rev.com) > Products - click on Import Reviews From CSV button > pick file via Upload CSV or From History Upload.
Mapping fields step
In this step, the purpose is to connect the data fields with the reviews criteria in A2Reviews, drag the columns from the CSV header to the data fields that A2Reviews requires. And continue to the next step.
Edit reviews step
A2Reviews provides full tools for you to preview your reviews and modify them as you like before importing them into the database and displaying them outside.
Once the reviews have been revised and are as expected we go to the final step to complete the import.
Finish step
In the last step, you need to pay attention to the option you want. There will be 3 options for you.
Skip: If there is already a product with the same product handle on the system and there is a rating, it will be ignored.
Replace: It will replace all reviews imported from the CSV, which will delete all existing old reviews.
Merge: It will merge both the old reviews and the reviews from the CSV, the total of the reviews will be added from the 2 sources and the data will be preserved.
Click on "Import Reviews" button to finish
Last updated