Getting Event/Ticket/User info into new

[Adam Thorp]

I’m needing to collect a large amount of information on an order for places on a course. It’d be nice to use the attendee info but it’s not quite got the functionality we’d like so we’re using Gravity forms instead. What we need to be able to do is create a link from the order that carries some details over

• Order Number
• Category the Events is in
• First Name
• Last Name
• Quantity of tickets purchased

There seems to be a bit of a disconnect between the order in woocommerce and the ticket plugin so I’m struggling to get all the info I need into the ‘new order’ email.

Any clues? Any hooks that I can use to pull tribe events ticket details into woocommerce order email?

[Geoff B.]

Good afternoon Adam and welcome to the Events Calendar Support forum!

Thank you for reaching out to us.
I would love to help you with this topic.

I’m needing to collect a large amount of information on an order for places on a course. It’d be nice to use the attendee info but it’s not quite got the functionality we’d like so we’re using Gravity forms instead.

Out of curiosity (and if you don’t mind), could you tell me what functionalities are missing from the attendee info in order to match your project’s requirements.
That would certainly help us improve on our products.

What we need to be able to do is create a link from the order that carries some details over

• Order Number
• Category the Events is in
• First Name
• Last Name
• Quantity of tickets purchased

I am not sure I understand correctly where you are trying to send the above information ? (Only in the new order email ? Elsewhere ?)
Would you mind expanding on that ?

There seems to be a bit of a disconnect between the order in woocommerce and the ticket plugin so I’m struggling to get all the info I need into the ‘new order’ email.

Full disclosure, I am not sure I would call it a disconnect.
But, I guess what you are saying is that all the information is not necessarily stored in the WooCommerce database tables or in its orders, which is a fair statement.

Just to set expectations, the scope of our support is mostly to get our customers started on the right track and to help them in case of issues.
We unfortunately do not provide complete support for customization.

With that in mind, there are a couple of things you might want to do to add extra information to your new order email:

1. You might want to read our Themer’s guide to get a sense of how we recommend to go about customizations.
2. You might want to check out the following snippet which adds information to the new order email. You can paste it in your child theme’s functions.php to test it out: https://git.io/vKXpE

Let me know if that helps.

Have a great day!

Geoff B.

[Adam Thorp]

Hi Geoff,

Thanks for your reply. Sorry not to be clear enough. First, attendee details and why we’ve chosen Gravity forms instead:
We’re asking for quite a lot of information on each attendee, plus there could be quite a few attendees being added by one person so, to ask for all that information on the initial order is going to put quite a few people off their initial purchase. An ideal solution to these would require quite a complext form builder and the ability to hide less important fields on initial ordering of tickets.
Also, if you change the quantity in the checkout I’m assuming you could miss out the attendee details for any further tickets ordered (I haven’t checked this so, sorry i’f I’m presuming wrong).
What we’re getting by using Gravity forms is a paginated form that breaks the sections up into a much more palatable user experience. We can also export the data very easily by date range and other filters which will help planning and distributing group numbers before courses are run. The ability for an admin to edit the attendee info is also a big benefit of using gravity forms.

I’ve managed to figure out how to get most of the details within the order items loop (as I’m create a custom link that partially fills in the user data for each item ordered within the gravity form), The only info I’m missing is the person that made the order’s email (I didn’t mention needing that in the first post). Any clues as to how you’d get that?

Yes, not meaning there’s a complete disconnect, or to take anything away from your knitting of two very complex systems together! Just that I was struggling to find data from both sources. I’ve had a dig around and I’ve been able to figure it out now. I was just unclear on where it all was when I first came to it.

I found the code you linked to and that went a long way to getting me up and running with the solution I needed. Thanks, it would have helped a lot if I hadn’t already font it.

[Geoff B.]

Good afternoon Adam,

Thank you for writing back and clarifying things.
This is super appreciated.

You are right, for complex forms you are better off with some dedicated form builder plugin such (as Gravity).

Also, if you change the quantity in the checkout I’m assuming you could miss out the attendee details for any further tickets ordered (I haven’t checked this so, sorry i’f I’m presuming wrong).

No, you are not wrong. This is a current limitation of our plugin. Some users decide to make the quantity button disabled at the cart level to prevent such an issue.

I’ve managed to figure out how to get most of the details within the order items loop (as I’m create a custom link that partially fills in the user data for each item ordered within the gravity form), The only info I’m missing is the person that made the order’s email (I didn’t mention needing that in the first post). Any clues as to how you’d get that?

Awesome! Kudos on that.

As per your question, the email address you are looking for is most likely found as part of WooCommerce’s data.
What you will need to do is:

1. Find the post_id in wp_posts for the order
2. Check out the wp_postmeta table for that post_id
3. Look for _billing_email in there

Yes, not meaning there’s a complete disconnect, or to take anything away from your knitting of two very complex systems together! Just that I was struggling to find data from both sources. I’ve had a dig around and I’ve been able to figure it out now. I was just unclear on where it all was when I first came to it.

No worries. I did not take this personally.
I just wanted to make sure we were on the same page here 🙂

Let me know how that goes.

Best regards,
Geoff B.

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts