Import Reviews From CSV file

Good to known: Importing reviews from a CSV file is a common and commonly used method for importing or exporting data. A2Reviews too, importing reviews from CSV is very easy with a few simple steps, follow this article to be able to import reviews on products on your website.

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 in Shopify

Column name
Description

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.

email

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.

Start import CSV reviews

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.

Mapping fields 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.

Edit reviews from CSV
Edit reviews from CSV (Click abled)
Expand review row

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.

Finish import reviews

Click on "Import Reviews" button to finish

Last updated