Support

Home Forums Event Espresso Premium Payment method on CSV registration report

Payment method on CSV registration report

Posted: April 25, 2019 at 9:23 am

Viewing 4 reply threads


Phil Wildcroft

April 25, 2019 at 9:23 am

I’m looking at using the CSV registration report to match bank statements against registrations that selected the Bank payment method. But the payment method only seems to be displayed on the report when a payment has been made even though the payment method ID is present on the transaction record created at the time of registration. The export code confirms that, the payment method is only extracted for approved registrations.

Is there an easy way to get the payment method on the report of pending registrations or do I just live with the assumption (which is probably correct in these particular circumstances) that a pending registration is pending because the bank payment method was selected?


Tony

  • Support Staff

April 25, 2019 at 10:54 am

Hi Phil,

The CSV fields are filtered before they are sent to be written to file, which means you can add/remove details from the CSV with some PHP.

You are correct in that the payment methods field is only populated when payments have been made, so based on the above, what I would do is check if the Payment methods column was empty and if so, pull the transaction for the registration and then from that the ‘last’ payment method used on that transaction and add it to the field.

Would that work for you?

Heres an example of doing the above:

https://gist.github.com/Pebblo/c38802287e59dcded1260e4303f91ce1

You can add that to a custom functions plugin on your site, we have some documentation on creating one here:

https://eventespresso.com/wiki/create-site-specific-plugin-wordpress-site/

  • This reply was modified 5 years, 7 months ago by Tony.


Phil Wildcroft

April 25, 2019 at 11:06 am

Excellent, sounds like just what I need. I’ve already got a custom plugin set up so I’ll test it out this evening and let you know how it goes.

Thanks,
Phil


Phil Wildcroft

April 25, 2019 at 1:10 pm

That works perfectly. Thanks very much.


Tony

  • Support Staff

April 26, 2019 at 4:56 am

You’re most welcome 🙂

Viewing 4 reply threads

The support post ‘Payment method on CSV registration report’ 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.

Event Espresso