Apply Ticket Fieldsets to multiple events

[seattleadventuresports]

My client runs multiple after-school programs for dozens of schools. Each event needs to have the same Ticket Fieldset applied (child name, child age, medications and allergies, etc.) For several hundred events per quarter!

Is there a fast way (even a set-a-default way?) to attach fieldsets to events? There doesn’t seem to be a way to do this with your (already daunting cross-referenced multiple-csv-file import technology.)

Current steps seem to be

1) Import the events (100)
2) Import the tickets (100 and hope everything matches)
3) Manually open every event and…
– Click the pencil icon to edit the ticket
– Click the “Attendee Information” accordion
– Choose the saved fieldset
– Click Save Ticket (and possibly the event’s Update button?)
4) Return to the Event List
5) Find the next event (if you can remember your place since there’s no information about tickets at all on the Events list page.)

As you can imagine for very large numbers of events this is extraordinarily time-consuming and comes with a high probability of error! Where the follow-up hassle and legal liability for not collecting student information, including health information, is very high.

---

If there’s not a way to automate this then here are a few feature requests that might be popular with high-volume clients
1) Allow saved tickets the way you allow saved venues, organizers, and, notably, ticket fieldsets.
2) Allow ticket fieldsets to be saved with Tickets
3) Allow saved tickets to be applied to events in Bulk Edit

Or, oh, I don’t know, how about a CREDIBLE DUPLICATE EVENT OPTION THAT INCLUDES DUPLICATING TICKETS AND TICKET FIELDSETS AS WELL AS EVENT INFO!!!!! I have no idea why that’s not a priority! It’s a fairly common feature with other event managers and seems to be a commonly requested feature as well.

---

But really, a way to automatically apply ticket fieldsets to tickets, perhaps by adding another field to the CSV ticket import, would be very helpful.

• This topic was modified 8 years, 2 months ago by seattleadventuresports.

[seattleadventuresports]

Note: even a code snippet would do. A PHP or even SQL way of saying “for all events if category ‘after-school’ then ticket_fieldset = ‘kid-camp-required-info'” I could probably take it from there. Thanks!

[Andras]

Hello there,

Thanks for reaching out!

Yes, this process for extra fields is a bit cumbersome. There is no easy way to to this. I can offer you a possible SQL workaround.

First you need to get the IDs of the tickets that need the fieldset.

With the ticket post_id in hand you can insert lines to the wp_postmeta table that includes the fieldset.

INSERT INTO 'wp_postmeta' ('meta_id', 'post_id', 'meta_key', 'meta_value') VALUES
('', 919, '_tribe_tickets_meta', 'a:3:{i:0;a:5:{s:4:"type";s:4:"text";s:8:"required";s:0:"";s:5:"label";s:4:"Name";s:4:"slug";s:4:"name";s:5:"extra";a:0:{}}i:1;a:5:{s:4:"type";s:4:"text";s:8:"required";s:0:"";s:5:"label";s:3:"Age";s:4:"slug";s:3:"age";s:5:"extra";a:0:{}}i:2;a:5:{s:4:"type";s:4:"text";s:8:"required";s:0:"";s:5:"label";s:10:"Medication";s:4:"slug";s:10:"medication";s:5:"extra";a:0:{}}}');

And run this for every ticket. (The second data, 919 is the ticket ID. That’s what needs to be changed.)

The long end part is the ticket fieldset. The easiest way to get that is to create it for one ticket and then copy it from there.

Hope this helps.

Thanks for the feature requests. I would kindly like to ask you to submit them on our UserVoice page. Or if there is a similar request, then give that a vote. We regularly check the feature requests there and the ones with high votes have a very good chance of making it into the plugin.

Cheers,
Andras

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts