Support

Home Forums Event Espresso Premium CSV data to reflect separate payment for group ticket purchase EE4

CSV data to reflect separate payment for group ticket purchase EE4

Posted: January 2, 2019 at 11:45 pm


Lyon

January 2, 2019 at 11:45 pm

Hi,

I can’t seem to find any thread regarding my issue. Please help.

Description:
As my events’ ticket prices are partially claimable (from our government) for individuals, I’m having a scenario whereby participants register Group Tickets (for a discounted price) but they will pay/claim it individually. Eg. Husband signs up for both wife and himself in a group buy for $100 per pax, and both of them will pay/claim separately a few days later. (Total incomplete transaction amount due is $200)

So far on the back end, I’m able to apply payments to each individual accordingly. Eg, wife pays full amount first ($100), I apply payment to her registration and approve her registration first. Husband follows suite a day later but only pays a portion of the amount with the claim (eg. $80) and will pay the remaining on the day itself with cash. So I apply $80 payment and approve his registration.

Problem:
The issue comes in when I export the “registrations” data into csv. The data shows both husband and wife in separate rows but the columns “amount paid”, “payment dates”, “payment methods”, “gateway transaction IDs” are combined together on the primary registrant ie. husband (Eg. Under husband row, column for amount paid is $180 while wife’s shows $0). Is there anyway to export the data to reflect the separate details for each individual? (Eg, Husband Row shows amount paid $80 while wife row shows $100).

Here’s a sample screenshot for your reference on the csv data issue: http://www.gardens-with-purpose.com/wp-content/uploads/2019/01/EEcsvData.jpg

Details:
Wordpress: WordPress 4.5.16
Event espresso: EE4 4.9.56.p

Thank you.

Best Regards,

Lyon


Tony

  • Support Staff

January 9, 2019 at 11:49 am

Hi Lyon,

There is already a field with the ‘Registration’s share of the transaction total’ value in the CSV (for me its Row I), changing the ‘Transaction Amount Due’ to match that value doesn’t seem correct as that field is the total for the transaction, not the registration.

With regards to separating out the payments for each individual registrant, it’s likely possible as the CSV is filtered so you can change any of the fields within it. You’ll need to be a little careful when doing so though as you ‘could’ have more than a single payment assigned to a single registration, so you will need to be aware of that when adding this.

How comfortable are you with PHP?

WordPress: WordPress 4.5.16
Event espresso: EE4 4.9.56.p

Also, may I ask why you are using older versions of both EE and WP?
Is there something preventing you from updating?

The support post ‘CSV data to reflect separate payment for group ticket purchase EE4’ 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