Import reviews from CSV files
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

Note: This feature supports Ryviu Paid plans only.

Import CSV file

Please go to your Ryviu dashboard > Products section > Click on Import button to browse your CSV file and start importing.

Note: Please make sure you have a CSV file of the reviews you want to import and that it is formatted correctly.

You just select one of the three below options to import CSV file:

  • Skip importing: if you don't want to import reviews from the CSV file for products that exist in the Ryviu dashboard.

  • Replace product reviews with new data: replace existing reviews in the Ryviu dashboard with reviews in a CSV file.

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

Product reviews CSV file

Please refer to the detail for fields of the CSV file and the types of information that belong in each field 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. Please check this article to know how to get the correct product handle: Get product handle.

  • rating (required): Valid values range from 1 to 5(1/2/3/4/5). Example: 5

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

  • author (required): name of reviewers

  • email (required): Email of reviewers

  • body_text: Review text.

  • photo_urls: Photos URLs of reviews; if you want to add multiple photos to a review, please add photo URL separated by a comma, for example, https://cdn.shopify.com/photo-1.png,https://cdn.shopify.com/photo-2.png

    You can upload and get the image's URL quickly from Ryviu Media Manager easily, click here to read more.

  • created_at: 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

We suggest using Google sheets to open and edit the CSV file. If you encounter any errors, click here to learn how to resolve them.

Got questions? Please don't hesitate to ask us :)

Did this answer your question?