Bulk Entry Delete

[vc_row][vc_column][vc_column_text]

Issue

You have a large amount entries that you want to delete based on some criteria, e.g., all entries that are older than 14 days.

Use Case

Client is a Wildlife park and wishes to purge all ticket sales for days more than 14 days in the past.

Solution

Write a small PHP function to loop over entries, check a specific criteria and then delete entries matching that criteria. Additionally, you can create a CRON job to run this program every night (or at whatever frequency you wish).

Credits to

Martin Koss (@Martin Koss on Formidable Slack) for having the problem that needed to be solved.

Non-Code Changes

N/A

Caveats

For the love of Pete, back up your database AND test the function with echo commands, rather than the actual delete, to make sure your logic is correct, before making the script live.

Code

[/vc_column_text][vc_raw_html]JTNDYmxvY2txdW90ZSUzRSUwQSUzQ3ByZSUzRSUwQSUwOSUyNHBhdGglMjAlM0QlMjBwcmVnX3JlcGxhY2UlMjglMjclMkZ3cC1jb250ZW50LiUyQSUyNCUyRiUyNyUyQyUyNyUyNyUyQ19fRElSX18lMjklM0IlMEElMDlyZXF1aXJlJTI4JTI0cGF0aCUyMC4lMjAlMjclMkZ3cC1sb2FkLnBocCUyNyUyOSUzQiUwQSUwQSUwOWRlZmluZSUyOCUyMCUyN0ZPUk1fS0VZX1RJQ0tFVF9PUkRFUlMlMjclMkMlMjAlMjdkYXktcGFzcy1zdHJpcGUlMjclMjklM0IlMjAlMkYlMkYlMjBrZXklMjBvZiUyMHRoZSUyMGZvcm0lMjB5b3UlMjdyZSUyMGRlbGV0aW5nJTIwZnJvbSUwQSUwOWRlZmluZSUyOCUyMCUyN0ZJRUxEX0tFWV9USUNLRVRfREFURSUyNyUyQyUyMCUyN3ZwYmt6JTI3JTI5JTNCJTIwJTJGJTJGJTIwa2V5JTIwb2YlMjB0aGUlMjBmaWVsZCUyMHRoYXQlMjB5b3UlMjdyZSUyMGNoZWNraW5nJTIwZm9yJTIwdGhlJTIwZGF0ZSUyMGNvbXBhcmlzb24lMEElMEElMDklMjRmb3JtSWQlMjAlM0QlMjBGcm1Gb3JtJTNBJTNBZ2V0X2lkX2J5X2tleSUyOEZPUk1fS0VZX1RJQ0tFVF9PUkRFUlMlMjklM0IlMjAlMEElMDklMjRjaGVja0ZpZWxkSWQlMjAlM0QlMjBGcm1GaWVsZCUzQSUzQWdldF9pZF9ieV9rZXklMjhGSUVMRF9LRVlfVElDS0VUX0RBVEUlMjklM0IlMEElMEElMDlkZWxldGVQYXN0RW50cmllcyUyOCUyNGZvcm1JZCUyQyUyMCUyNGNoZWNrRmllbGRJZCUyQyUyMDE0JTI5JTNCJTBBJTBBJTA5ZnVuY3Rpb24lMjBkZWxldGVQYXN0RW50cmllcyUyOCUyNGZvcm1JZCUyQyUyMCUyNGNoZWNrRmllbGRJZCUyQyUyMCUyNG51bURheXNUb0RlbGV0ZSUyOSUyMCU3QiUwQSUwOSUwOSUyNGN1cnJlbnREYXRlJTIwJTNEJTIwZGF0ZSUyOCUyN1ktbS1kJTI3JTI5JTNCJTBBJTA5JTA5JTI0ZW50cnlJZHMlMjAlM0QlMjBGcm1EYiUzQSUzQWdldF9jb2wlMjglMjAlMjdmcm1faXRlbXMlMjclMkMlMjBhcnJheSUyOCUyN2Zvcm1faWQlMjclMjB4eCUyMCUyNGZvcm1JZCUyOSUyMCUyOSUzQiUwQSUwOSUwOWZvcmVhY2glMjAlMjglMjRlbnRyeUlkcyUyMGFzJTIwJTI0ZW50cnlJZCUyOSUyMCU3QiUwQSUwOSUwOSUwOSUyNGVudHJ5JTIwJTNEJTIwRnJtRW50cnklM0ElM0FnZXRPbmUlMjglMjRlbnRyeUlkJTJDJTIwdHJ1ZSUyOSUzQiUwQSUwOSUwOSUwOSUyNHRpY2tldERhdGUlMjAlM0QlMjAlMjRlbnRyeS0lM0VtZXRhcyU1QiUyNGNoZWNrRmllbGRJZCU1RCUzQiUwQSUwOSUwOSUwOWlmJTIwJTI4ZW1wdHklMjglMjR0aWNrZXREYXRlJTI5JTIwJTdDJTdDJTIwJTI0dGlja2V0RGF0ZSUyMCUzRSUzRCUyMCUyNGN1cnJlbnREYXRlJTI5JTIwJTdCJTBBJTA5JTA5JTA5JTA5Y29udGludWUlM0IlMEElMDklMDklMDklN0QlMEElMDklMDklMDklMjRkYXRlMSUyMCUzRCUyMGRhdGVfY3JlYXRlJTI4JTI0Y3VycmVudERhdGUlMjklM0IlMEElMDklMDklMDklMjRkYXRlMiUyMCUzRCUyMGRhdGVfY3JlYXRlJTI4JTI0dGlja2V0RGF0ZSUyOSUzQiUwQSUwOSUwOSUwOSUyNGludGVydmFsJTIwJTNEJTIwZGF0ZV9kaWZmJTI4JTI0ZGF0ZTIlMkMlMjAlMjRkYXRlMSUyOSUzQiUwQSUwOSUwOSUwOSUyNG51bURheXNEaWZmJTIwJTNEJTIwJTI0aW50ZXJ2YWwtJTNFZm9ybWF0JTI4JTI3JTI1UiUyNWElMjclMjklM0IlMEElMDklMDklMDlpZiUyMCUyOCUyNG51bURheXNEaWZmJTIwJTNFJTNEJTIwJTI0bnVtRGF5c1RvRGVsZXRlJTI5JTIwJTdCJTBBJTA5JTA5JTA5JTA5RnJtRW50cnklM0ElM0FkZXN0cm95JTI4JTIwJTI0ZW50cnlJZCUyMCUyOSUzQiUwQSUwOSUwOSUwOSU3RCUwQSUwOSUwOSU3RCUwQSUwOSU3RCUwQSUzQyUyRnByZSUzRSUwQSUzQyUyRmJsb2NrcXVvdGUlM0U=[/vc_raw_html][/vc_column][/vc_row]