Mass delete hundreds of pages of “pending” spam donations

  • Resolved kw11

    (@kw11)


    4 years, 1 month ago

    I have hundreds of pages of “pending” spam donations and I need to bulk delete them and don’t want to click buttons thousands of times. All of these donations were blocked by Stripe Checkout, but the database is still littered with tens of thousands of donations.

    Is there an automated way or SQL query to delete all pending donations?

    Thank you,
    Kyle

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter kw11

    (@kw11)

    Also, when the database is like this, queries are extremely inefficient. The queries lock up the server in the backend.

    Queries look like this

    SELECT id FROM wp_give_sequential_ordering WHERE payment_id = '33572' LIMIT 1

    So I tried disabling sequential ordering, but same queries run with the same severe performance issues.

    • This reply was modified 4 years, 1 month ago by kw11.
    Plugin Support Rick Alday

    (@mrdaro)

    Hi @kw11,

    An SQL commands will directly affect your database, and we could not support any change in that way, because there is a risk that something will be missed OR something will be corrupted.

    I suggest the “Bulk Delete” plugin instead: https://www.ads-software.com/plugins/bulk-delete/

    It has an option to bulk delete custom post types based on status, in this case, Donations (give_payments) – Pending.

    Regarding the feedback on the SQL queries you can post it on our Github issue tracker: https://github.com/impress-org/givewp/issues

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Mass delete hundreds of pages of “pending” spam donations’ is closed to new replies.