WP Review – How to Bulk Edit Hundreds of Reviews Quickly

In this tutorial, we’ll show you how to bulk edit reviews created with the WP Review plugin. But the same steps can be used to edit Reviews created by any other plugin.

We’ll do it using an intuitive spreadsheet for posts that allows you to apply massive changes and do advanced searches quickly.

We’ll use WP Sheet Editor. This is a WordPress plugin designed to help you save time and increase your productivity by bringing all the benefits of spreadsheets into WordPress. You can view all the reviews in a spreadsheet, bulk edit posts, pages, and any custom post type generated by other plugins.

These are some of the features of this plugin:

  • Edit using a spreadsheet inside WordPress
  • Advanced searches of posts by keyword, category, tag, date, etc.
  • Bulk edit any of the fields on thousands of posts with just a few clicks.
  • Export all posts, pages, or custom post types to Excel or Google Sheets.
  • Import hundreds of posts, pages, or custom post types from Excel or Google Sheets.

To bulk edit hundreds of reviews from WP Reviews using this intuitive and powerful bulk editor, you need to follow these steps:

1- Install the WP Sheet Editor

If you already have WP Sheet Editor installed and activated, you can skip this step.

2- Open the Posts spreadsheet

To open the posts spreadsheet, go to WP Sheet Editor > Edit Posts. You’ll see all your reviews displayed in the spreadsheet as rows and all their fields displayed as columns.

You can see every field created by the WP Review plugin in the spreadsheet. It will be loaded automatically, but if you don’t see some fields, go to Settings > Scan DB to find fields. This way, all the fields will appear in the spreadsheet.

3- Search for all the reviews you want to edit

You may not want to edit all reviews but specific groups of reviews. For example, all the book reviews, all the event reviews, etc.

The Search tool allows you to do that. You can filter your reviews by status, author, price, schema, review links, review type, etc. You can open this tool with a click on Search on the toolbar.

In this example, we want to show you how to search for all the Book reviews.

For that, we need to click Enable advanced filters and select the following values:

  • Field: Wp review schema
  • Operator: =
  • Value: book
  • Click Run search to filter all the reviews.

After selecting and applying these search parameters, the reviews will be displayed in the spreadsheet, as you can see here:

4- Bulk edit the filtered reviews

Once the reviews have been filtered and displayed in the spreadsheet, you need to open the Bulk Edit tool and apply the massive changes only to the reviews that were found by the Search tool.

The Bulk Edit works perfectly with any number of reviews, you can easily update 10,000 reviews in one go, and it works with all the servers.

To open the tool, just click Bulk Edit on the toolbar.

In the following drop-down sections, we’ll show you several changes you can apply to all the filtered reviews.

These are the values you need to select in the Bulk Edit tool to delete all the filtered reviews.

  • Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
  • What field do you want to edit: Status
  • Select type of edit: Set value
  • Replace existing value with this value: Delete completely
  • Click Execute Now to delete all the filtered reviews.

If you’re working with book reviews, as we’re doing it in this example, then you may want to change the book format for all the filtered reviews.

We’re going to replace the Print value with the E-Book value in the Book Format field.

  • Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
  • What field do you want to edit: Wp Review Schema Options: Book: Book Format
  • Select type of edit: Replace
  • Replace this: Print
  • With this: E-Book
  • Click Execute Now.

With these values, you’ll have edited the book format for all the selected reviews.

If you want to set a new review link for all the selected reviews, you can do it quickly with the Bulk Edit. For that you just need to select the following values:

  • Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
  • What field do you want to edit: Wp Review Links : Url: 1. Notice: You decide which review link field you’ll edit. In this example, we’ve selected review link 1.
  • Select type of edit: Set value
  • Replace existing value with this value: Enter the new review link here.
  • Click Execute Now.

Done! After selecting and applying these values, all the selected reviews will contain the review link URL you’ll have set.

In case you’re editing product reviews, you may want to set a new price for all the filtered product reviews. But don’t worry because you can do it quickly with the Bulk Edit tool. Just select the following values:

  • Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
  • What field do you want to edit: Wp Review Product Price
  • Select type of edit: Set value
  • Replace existing value with this value: Enter the new WP review product price here.
  • Click Execute Now.

With these values, you can set a new price for all the selected reviews.

How easy!

Editing thousands of reviews can be a hard, time-consuming task. You’d have to deal with the complex editor to edit your reviews manually. However, with WP Sheet Editor you don’t need to worry anymore because you can apply advanced search parameters and edit any field on thousands of reviews quickly.

This way you can increase your productivity by editing hundreds of reviews in just some minutes and with just some clicks.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu