|
nicetouch
|
August 15, 2017 at 4:51 pm
Hi there,
We run hundreds of events per year, and it’s looking like we can’t remove old events, registrations, etc without removing transactions one at a time. We’re going to run mostly the same events again this year, but the date-times are all locked, so we planned to just duplicate the old events and start from scratch (per EE4’s recommendation). The problem is now that all the old “sold out” or “expired” events cannot be removed from the WP backend. Not good!
This is a huge issue for us, as the site is becoming nearly impossible to administer when digging through hundreds of expired events with completed transactions. Clearly removing one transaction at a time is not really an option for hundreds of events with scores of tickets sold for each event.
|
|
Josh
|
August 15, 2017 at 5:08 pm
Hi there,
You can delete all of the events, registrations, and old data from last year by going to the Event Espresso > Maintenance > Reset page and then you click on the button that deletes all event data. Please be sure to make a backup of your database before you do this, because the deletion cannot be undone.
|
|
nicetouch
|
August 23, 2017 at 12:37 pm
Nice. Thanks.
Now here’s the tough part. All of our events are the same this year, and have actually built a pretty solid SEO presence. How would you recommend we preserve the events/permalinks and just re-create the datetimes? I’m hoping we don’t have to start from scratch and re-create everything :). Should we export some the event MYSQL tables separately and re-import them?
|
|
Josh
|
August 23, 2017 at 1:10 pm
If you use the same permalink from the events from last year then the new events will have the same URLs as the prior events. The MYSQL tables that store event data (starting with the WP posts table) aren’t something that can be re-imported without breaking associated data from other tables.
|
|
nicetouch
|
August 23, 2017 at 1:21 pm
So to clarify, there is no way to clear out all the registrations without clearing out events? And there is no way to duplicate the hundreds of events we’ve created?
|
|
Josh
|
August 23, 2017 at 1:26 pm
You can duplicate the events within the event editor (there’s a button below the event title field labeled “Duplicate”) This will duplicate the event, and only the event data (no registration data will be deleted. The registrations from last year can be cleared out, but if they have payments the payments need to be removed first.
|
|
nicetouch
|
August 23, 2017 at 1:52 pm
Yeah, I see the duplicate option, but obviously we can’t delete all events once we’ve duplicated, so we’d be stuck removing events one at a time, right? I guess that’s what I’m asking, is there a way to do any of this in a mass/bulk manner, rather than iterating through either creation or deletion?
By payments, is that “transactions” in EE? Is there a way to mass remove these payments? I’m only seeing removing one payment at a time, and we have thousands of transactions.
|
|
Josh
|
August 23, 2017 at 2:07 pm
Payments are within transactions and the developers did not build a way to delete payments in bulk.
|
|
nicetouch
|
August 23, 2017 at 2:21 pm
Any advice here that would not involve manually deleting thousands of transactions? I’m thinking MySQL will be the way, and we’ll have to find a way to delete payments in bulk.
|
|
Josh
|
August 23, 2017 at 3:13 pm
We actually advise not deleting prior event data, but if you go the route of deleting data from the esp_ tables you’ll need to make sure that you remove all associated data that links one table’s data to the other. So for example these tables all store related registration, transactions, and payment data:
_esp_registration
_esp_registration_payment
_esp_payment
_esp_transaction
_esp_line_item
|
|
nicetouch
|
August 23, 2017 at 4:00 pm
Yep, got that part for sure :). It also looks like the DTT_Sold column in the esp_datetime table doesn’t get reset, so we’ll need to reset that in order to clear out any existing datetimes.
MySQL here we come!
|
