This article is also available in:
There are many ways to import reviews into Product Review, but using a CSV file is the fastest and most convenient way for a seller to import multiple reviews into their store to build credibility with customer. This article will help you understand more about the CSV file for Product Reviews app.

In this article

A. CSV file for Product Reviews
B. Import and export CSV file into Google Sheets
C. Create a CSV file to review products

A. CSV file for Product Reviews

CSV stands for comma separated values, file format (.csv) for spreadsheets. With the Product Reviews app, you can use a CSV file to import and export product reviews.

Note:

Your CSV files must use UTF-8 encoding.

If you are updating a CSV file, be sure to confirm UTF-8 encoding to avoid generating unwanted special characters in your file. If you save the file without confirming the UTF-8 encoding, your data will be modified when you upload it as a new spreadsheet. Modified files cannot be recovered.

We recommend you use Google Sheets to work with your CSV files. After you make changes to the CSV file using Google Sheets, export the CSV file to your computer. Incorrect special characters in the CSV file will be exported and edited by another software and then imported back into ShopBase.

B. Import and export CSV file into Google Sheets

You can learn more about importing and exporting CSV files via this article.

C. Create a CSV file to review products

First, refer to the sample CSV file used to import product reviews into Product Reviews to learn more about the information and required fields to fill in the file. Then add all your reviews like the sample file above and save the CSV file in UTF-8 format using the LF styled feeds.

Explain about columns in CSV file:

product_id (required, but if you enter the product_handle field, the product_id field is not required): Product code on the store's admin page (Example: 2134234)
product_handle (optional but if the product_id field is not already filled in then you must enter this field): The sequence after the last / mark of the product link (Example: short-sleeves-t-shirt)
name_of_customer (required): Customer's name in product reviews (For instance: John Doe)
email(required): Customer's email. It could be anonymous (For example: johndoe@example.com)
rating (required): Star number (from 1 to 5) that customers rate on the products (e.g: 5)
title (optional): Title of customer reviews, limited to 70 characters (Example: My new T-shirt)
review (required): Customer review content, limited to 500 characters (Example: I just bought this T-shirt and absolutely love the look!)
date_of_review (optional): The date the customer writes the product review. This date must be current or earlier. If you leave this field blank, the date will be automatically updated as the date the CSV file was uploaded to the system (Example: 2020-01- 20 10:02:56 +0000 UTC)
fields such as link_of_img_1, link_of_img_2, link_of_img_3, link_of_img_4, link_of_img_5: Review image links. Reviews with images give greater confidence. A review can have up to 5 images.

Note:

You just need to enter product_id or product_handle. If both are filled in, we will give preference to product_id. If you leave these two fields blank, the review you uploaded will be automatically recognized by the system as a general store review.
The review date must be between 2000 and the current date (It cannot be a future date). Reviews of more than 10 years ago or of a future date will not be accepted by the system.

Related articles
Overview of Product reviews
Show product reviews on store
Get shared reviews on PrintBase database for your PrintBase store
Import reviews to Product Reviews by CSV file
Add Google Reviews snippet in Product Reviews
Manage reviews on Product Reviews app
Display reviews on All reviews page
Auto-publish reviews
Group product reviews
Encourage more reviews from your customers
Was this article helpful?
Cancel
Thank you!