Import reviews from CSV file

You can import reviews in Ryviu dashboard from other review apps via CSV files.

Yen Ma avatar
Written by Yen Ma
Updated over a week ago

This feature is available only on Ryviu Paid plans.

This guide provides clear steps for importing reviews from a CSV file into Ryviu.

πŸ‘‰ Step 1. Prepare Your CSV File

We highly recommend preparing your CSV file using an online Google Spreadsheet so that the CSV template file is not affected by your Excel settings and does not cause any issues when importing.

Import by using Ryviu CSV template file.

  1. Ensure your CSV template is correct with Ryviu CSV template file.

  2. Review data should be formatted according to the formats provided below.

    • product_handle (required): The product handle (Shopify), slug (WooCommerce), or friendly URL (PrestaShop) of the products you want to import reviews for should be used.

    • rating (required): Valid values range from 1 to 5(1/2/3/4/5). Use whole numbers only, for example 5.

    • title: review's title. For example, "Awesome!"

    • author (required): name of reviewers.

    • email: Email of reviewers.

    • body_text: Review text.

    • photo_urls: Photos URLs of reviews. Add all image URLs separated by commas for reviews with multiple photos under this column.

    • created_at: The format should be Year-Month-Date Hour: Minute, for example, 2019-09-23 09:12. If the date format in your CSV file is incorrect, as required, reviews will be added to your Ryviu dashboard in real-time when you import the CSV file.

    • status: enable or disable.

    • featured: "1" is the featured review, "0" is not a featured review.

  3. After filling in your review's information according to the template file format, download it as a CSV file.

  4. Import CSV following Step 2.

Import by using the CSV template of your previous review app

For past users of the apps listed below, we offer a seamless import process with the following review solution apps: Ryviu, Loox, Judge.me, Product Reviews by Shopify, and the Rivo app. Please export your reviews from your previous app and then import reviews by following Step 2.

πŸ‘‰ Step 2. Import reviews from CSV file

  1. Login to your Ryviu account.

  2. Navigate to Reviews dashboard manager.

  3. Click the Import CSV button.

  4. In CSV format, select the app to which your CSV template file belongs.

  5. Click Add file button.

  6. Select your CSV file.

  7. If your CSV file contains products in Ryviu that already had reviews, please choose one of the three options below to import a CSV file.

    • Replace items: replace existing reviews of products in the Ryviu dashboard with reviews in a CSV file.

    • Merge items: combine current reviews of your products in the Ryviu dashboard and new reviews in the CSV file.

    • Skip items: It will avoid importing reviews from the CSV file to products that exist in the Ryviu dashboard.

  8. Click Import button.


Need help?

Get in touch with our support team through live chat or email at [email protected]. We're here to help!​

Did this answer your question?