Hi there,<\/p>\n
Recently I’ve migrated events, tickets, organizers, venues etc from one site to another.
\nI’ve migrated these with the WP All Import\/Export suite so each post type is migrated individually.<\/p>\n
I’ve created a custom script which updates the ID in the new site to the same ID in the old site for all the post types.
\nThis custom mapping is necessary due to the imports being given a new ID on import which results in the different post types not being mapped together.
\nIn other words, without custom ID mapping, an event would import and show as having no venue, organizer etc.<\/p>\n
After the ID mapping, each event shows with a venue and organizer however, tickets are not mapping.<\/p>\n
It appears an event post contains meta data for the organizer and venue so making the id in the venue meta table matche the id of the organizer and venue ensures organizers and venues display correctly on each event.<\/p>\n
The tickets however, are different.
\nEvents don’t contain meta data pointing to a ticket.
\nInstead, it almost appears as though ticket posts contain meta which points to an event and that that meta data pointing to the event is wrapped up in a serialized array.<\/p>\n
My question here is to inquire about exactly how tickets are referenced (or reference) events?
\nI’m confused about how exactly they relate to each other in the database.
\nOnce I know exactly how and why a ticket is able to show up on an event, I can write some functions to update the relevant data to re-map tickets to their respective events.<\/p>\n
Any help or references to documentation outlining the internals of how events reference tickets will be appreciated.<\/p>\n
Many thanks,
\nTom<\/p>\n","protected":false},"template":"","class_list":["post-1498220","topic","type-topic","status-closed","hentry"],"yoast_head":"\n