How can I export reviews to a CSV?

Until Site Reviews provides this feature, an easy way to do this is with the Database Browser plugin.

1. Install the Database Browser plugin
2. Go to the “Tools > Database Browser” page
3. Click the “Select table” button (it doesn’t matter which table is selected)
4. Copy the table prefix of your tables (for example, if the table is wp_posts, the prefix is the first part with the underscore wp_).
4. Click the “Edit query” button
5. Paste the following SQL query, replacing wp_ in “wp_glsr_ratings” and “wp_posts” with your table prefix:

SELECT
    p.post_date as date,
    p.post_title as title,
    p.post_content as content,
    r.*
FROM wp_glsr_ratings AS r
INNER JOIN wp_posts AS p ON r.review_id = p.ID

6. Click the “Run query” button
7. Click the “CSV” button to download the results

Thanks!

Also, my client has two types of products on their site (not e-commerce at this time). They want to be able to give users the ability to select which product they’re reviewing when they write a review. And they would like to have the option to put reviews for that specific product type on its own page.

Is that possible perhaps with the Pro version?

The first point can be done with the Review Forms addon by using the “Review: Assigned Posts” custom field.

The second point can be done using the assigned_posts option on the shortcodes.

I just installed the add-on and I can’t seem to select the type of field I want to add; i’m only seeing “custom field” when I click to add a field.

This has been resolved.