Migrating Ticket Information

[niallflynn]

Hi,

I am looking to migrate ticket information including attendees to our new website. I have tried to import using WordPress import/export but the attendee information has not migrated successfully. Would it be possible to move this information from the database instead and if so, are there any guides in your forums to do so. Would just like to grab that information for tickets/attendees as we they are bookings for courses on our site.

Many thanks,

Martin.

[Andras]

Hi Martin,

Thanks for using our plugins and for reaching out to us!

There is no easy way migrating the attendee information as you saw. That mainly has to do with the post IDs. If the original IDs are taken, then the event / ticket / attendee will get a new post ID but the references do not get updated. This can cause the unsuccessful migration.

The only way I can imagine moving the information successfully is copy-pasting first the database, or at least the wp_posts and the wp_postmeta tables. And then importing the rest of the content. This can ensure that the events, tickets and attendees are correctly linked.

If you are using WooCommerce and you need order data as well, then you will need to include those tables as well.

I hope this helps. Let me know if I can be of further help.

Cheers,
Andras

[niallflynn]

Hi András,

Thanks for your advice on how to proceed.

So if i am clear the process would be

1. Migrate wp_posts and the wp_postmeta tables
2. Import Venues and Organizers then Events
3. Import Woocomerce order data tables

I already have everything imported on the site and restyled for new design…including events pages etc. I have everything finalized except the updated Attendee info. Will I loose this progress by following the steps above?

Many thanks,

Martin

[Andras]

Actually, once you migrate wp_posts and wp_postmeta, your venues and organizers will be migrated as well.

Also, part of the WooCommerce data will be there, but you will still  need the specific WooCommerce tables.

Will I loose this progress by following the steps above?

Migrating the data / tables will not (should not) affect the design of your page. Any design related info is saved in the wp_options table, to the best of my knowledge. Unless you have a theme that uses its own data tables, but I never really saw a theme like that.

You will ‘lose’ your data, like pages and blog posts, except if you have them in the original wp_posts and postmeta tables. Then they will be transferred over as well.

Before proceeding I strongly recommend that you create a backup of your database, just in case something would go South.

Let me know how you end up.

Cheers,
Andras

[niallflynn]

Thanks very much Andras,

I really appreciate you time and guidance on this. I have a clearer understanding on how to proceed and of course, will backup everything beforehand. I will let you know how I get on.

Have a great day,

Martin

[niallflynn]

Hi Andras,

I used the plugin WP Migrate DB which successfully migrated the whole database but unfortunately the ticket attendee information still has not updated. This is a big problem for us. Under pressure timewise to launch our new site but need the attendee information.

Martin

[niallflynn]

Hi,

Just to further explain how i reached this dilemma. I copied or live site a few weeks back to work on design improvements. While I was working on the new site ticket orders / attendees were still coming into the live site. Now that I am ready to migrate the new site back to our domain, it’s missing these orders. Managed to import the Woocommerce orders but can’t update the Attendees, having tried export/importing through WordPress and also importing the database into the new site but the attendees still didn’t update. Hope to have the site live this week but this is holding of the launch.

Any further assistance would be greatly appreciated.

Many thanks,
Martin

[Andras]

Hi Martin,

What I understand is:

You have an original / live site where you are receiving orders.

You created a new site where you developed a new design. During this time orders were still coming to the original / live site.

Now you want to apply the “new” design to the original / live site.

Is this it?

In this case you only need to transfer the new design back to your live site and the orders will still be there untouched.

Do I see this correctly?

Andras

[niallflynn]

Hi Andras,

Preferable I wanted to import the order/attendees to my newly designed site. I think it would be a lot more work to bring the ‘New’ design to the original site as all the event layouts have changed on the new design etc. This would be a final option if it’s not possible to bring the ticket / attendee information into the newly designed site.

Thanks,
Martin

[Andras]

Okay, I understand.

In that case I would do the following after a db backup:

On the old site create an export of your database. To make a full transfer you will likely need all tables, except for wp_options.

Careful with wp_users and wp_usermeta so that you don’t lock yourself out from the new site.

On the new site, delete (or rename) these tables. (All, except wp_options, and wp_users if you want.)

Import these table to the new site.

Best would be working directly in your database (phpMyAdmin or similar). Using a plugin to do this might alter the IDs of the different entries resulting in tickets not being connected to the events.

This is about as much as I can think of. The other would be migrating the design. Not sure what changes you made… for me copying the parent and child theme over and exporting / importing theme settings (if there are any) seems easier than the above with the database. But again, I don’t know what changes you made.

Let me know how you end up. If needed I can try to help you further, though I’m running out of ideas. 🙂

Cheers,
Andras

[niallflynn]

Hi Andras,

Thanks again for your advice. I will try your recommendations. When I migrated the database previously I used a plugin so maybe that was the problem. Sounds like it should work using phpMyAdmin.

I will let you know how I get on.

Many thanks, ?

Martin.

[Andras]

Sure thing. Looking forward to hearing the result!

A.

[niallflynn]

Hi Andras,

Just to let you know I tried importing the database except for wp_options, and wp_users into the new site (using phpmyadmin) and following suggested. For some reason when I view, it brought over the styles from the old site. This has me baffled.

Running out of ideas myself on this.

Thanks,
Martin

[Andras]

What styles? On pages, posts, products, events?

Can you share a before / after screenshot?

A.

[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