One of your organizers renounced and said he would cancel all the events, so you need to delete them all quickly.
However, you can’t do it in WordPress because the bulk actions are limited and you can get server errors since WP will try to apply all the changes at once.
That’s why we want to show you how to do it using the Events Spreadsheet plugin, which allows you to edit thousands of events in seconds using its Bulk Edit tool.
It displays all your events on a spreadsheet where you can edit values as you do in Excel or Google Sheets.
You can download the plugin here: Download Events Spreadsheet Plugin - or - Check the features
You can open the spreadsheet by going to WP Sheet Editor > Edit Events.
Now just follow these simple steps.
1- Open the Bulk Edit tool
With the Bulk Edit tool, you can edit thousands of events at once. Open it with one click on the toolbar.
2- Filter the events by organizer
You need to filter all the events by organizer in order to delete them. For that, select the I want to search rows to update option in Select the rows that you want to update.
Once you open the Search tool, you need to filter the events by organizer.
Important. You need to have the organizer ID in order to filter all his events.
You need to tick the Enable advanced filters checkbox and select these values:
- Field key: EventOrganizerID (_EventOrganizerID)
- Operator: =
- Value: Enter the organized ID in this field.
- Click on Run search.
3- Delete all the filtered events at once
Now you need to select these values to delete all the filtered events at once.
- Select the rows that you want to update: I want to search rows to update
- What field do you want to edit: Status
- Select type of edit: Set value
- Replace existing value with this value: Delete completely
- Click on Execute now.
Done!
Editing thousands of events doesn’t have to be a headache at all. It’s really simple and fast if you use the Events Spreadsheet plugin. You can save a lot of time and clicks.
You can download the plugin here: Download Events Spreadsheet Plugin - or - Check the features