Support

Home Forums Event Espresso Premium Payment received, no registration : How to delete transaction

Payment received, no registration : How to delete transaction

Posted: May 23, 2018 at 4:32 am


Oguzhan Altun

May 23, 2018 at 4:32 am

Hello,

Recently we found out 2 cases of people trying to pay through Stripe, the system gets their payment but no registration is created. They think that the payment didn’t go through, and they try again, this time they succeed.

I found these 2 transactions, and with the help of the gateway transaction ID, I found who they belong to and refunded through Stripe. However their payments are still in EE4 and there is no way to delete or refund them (see the screenshot):
https://screencast.com/t/TELDmzSf
How can I remove these records from EE4? Right now, they create an imbalance on total payments received vs actual payments received.


Tony

  • Support Staff

May 24, 2018 at 7:54 am

Hi there,

Recently we found out 2 cases of people trying to pay through Stripe, the system gets their payment but no registration is created.

Registration objects are created in the database way before the payment objects even come into play so they will, at some point, have been created.

I found these 2 transactions, and with the help of the gateway transaction ID, I found who they belong to and refunded through Stripe. However their payments are still in EE4 and there is no way to delete or refund them (see the screenshot):
https://screencast.com/t/TELDmzSf

May I ask where you pulled the gateway transaction ID from? It’s not visible in your screenshot and there are no payments assigned to that transaction.

Do you have caching enabled on the site? We’ve seen something similar to this before when there was a conflict with sessions and that was due to caching.


Josh

  • Support Staff

May 24, 2018 at 7:58 am

Hi there,

You’re correct, there isn’t a way within the UI to delete those, but you can go into the database and remove those entries from the esp_transactions table.


Oguzhan Altun

May 28, 2018 at 6:58 am

Hi Tony,

May I ask where you pulled the gateway transaction ID from? It’s not visible in your screenshot and there are no payments assigned to that transaction.

I got these ID’s from the csv regsitration downloads.

Do you have caching enabled on the site?

Yes but it excludes all the event espresso key pages. We never had this problem before. It might be that there was an update happening on the website during the transaction..

Josh,
Could you explain how I can do this exactly? I’m quite afraid to touch the database, as I don’t have the technical knowledge. I can access it via php admin.


Josh

  • Support Staff

May 29, 2018 at 2:39 pm

It’d probably be best to leave them. If you really need them deleted, the esp_transaction table will have one row for each transaction. The ID column shown in phpmyadmin will match the ID in Event Espresso > Transactions. As a good rule of thumb, it’s best to do a database backup before working directly on the database.

The support post ‘Payment received, no registration : How to delete transaction’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  Josh 3 months, 3 weeks ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!