Deleting Pending Transactions

  • Resolved klaybc

    (@klaybc)


    10 years, 6 months ago

    I had two donations that were marked as pending. These clearly represented abandoned PayPal attempts, as the they are both followed immediately with two completed donations of the same amount, from the same individuals.

    To keep the transaction data clean, I have deleted those pending transactions, as it is clear that they will never be completed. Now, however, my donation goal bar is showing an incorrect total. It has been reduced by the amount of the deleted pending transactions.

    Currently, the total of the completed donations (in the admin area, and in PayPal) is not accurately reflected by the goal bar (goal bar is too low).

    It was my understanding that the goal bar does not include pending transactions. How then could deleting them affect the total shown?

    http://www.fromztoa.ca

    Please advise.

    https://wordpress.org/plugins/give/

Viewing 1 replies (of 1 total)
  • Plugin Contributor Matt Cromwell

    (@webdevmattcrom)

    10 years, 6 months ago

    Hi there,

    We do have a known bug regarding deleting transactions. We have it fixed in our development version already and will be releasing that very soon. The problem stems from the Goal amount not updating correctly when any kind of transaction is deleted. The only way to get that corrected is via the database. Here’s your steps:

    1) Go to “Donations > Forms” and hover over the “Edit” link to see the form ID of the form that you want to update.

    2) Now go into your database and do a search for _give_form_earnings in the wp_postmeta table.
    3) The “metavalue” column is your current total donations for each form. Find your Form ID in the post_id column and update that forms “metavalue” value.

    As I mentioned, we’ve got this fixed in the upcoming version. But generally, I’d encourage you to not delete transactions but instead use the “Abandoned” status.

    Also, if you find that your PayPal transactions are stuck in Pending continually, read our docs on that here:
    https://givewp.com/documentation/core/payment-gateways/paypal-standard/

    Thanks!

Viewing 1 replies (of 1 total)

The topic ‘Deleting Pending Transactions’ is closed to new replies.