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.
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:
/ mark of the product URL. You can see the product URL in the Search engine listing preview section of the product detail page. (For example: if your product URL is testweb.onshopbase.com/products/single-sided-printed-pillowcase, the handle will be single-sided-printed-pillowcase).MM/DD/YYYY. If you leave this field blank, the date will be automatically updated as the date the CSV file was uploaded to the system (Example: 01/20/2021)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 or = 0, the review you uploaded will be automatically recognized by the system as a general store review.