Event Tickets are Not Displaying

[rjjacob]

I see other tickets with this topic but they are marked private. I’ll keep this one public for others having this issue.

I worked on this site back in July and had it all set up and working – each event page had details and an array of ticket options. All was well. There was a delay in getting the payment processor together until yesterday. So now I go back to the site to wrap it up and the ticket options are not displaying.

I have tried everything and I cannot get them to display. Checking the inspector, the form is there, the table is there but there is no content in the table.

I’ve turned off caches and dumped the cache from every browser I have and still not ticket array is displaying.

I’m stumped.

[Andras]

Hi rjjacob,

Thanks for getting in touch!

I’m sorry to hear about this issue. That is definitely unusual. I’d be happy to help you out here.

When you open the tickets for editing and open the “Advanced” part, are the start and end sale dates filled out? Are they set in a way so that the tickets show up today?

If the dates are set up properly, then I could take a look at your database, if you are willing and open to share with me a db dump.

And a sidenote, I see you are using the Duplicate Post plugin. Please note that if you are duplicating events that already have had some ticket sales, then you will likely get some wrong ticket sales numbers. If you do plan to duplicate events with it, then it’s recommended to duplicate it before setting up any tickets, or at least before selling any tickets.

Cheers,
Andras

[rjjacob]

Yes, it is weird. I imported ticket info, ordering date ranges and other data by CSV. I noticed in the wp_postmeta table that meta_key event_orderby shows “meta_value” instead of the dates and times I imported for cut-off times to order tickets for particular event dates. Could that have something to do with it?

When viewing the “Advanced” tab on tickets, there are no fields for start and end sale dates, either.

What’s weird is that the tickets did show up originally and only recently have disappeared, as far as I can tell.

Although I’m using the Duplicate post plugin, I haven’t used it for events. I imported them using the templates at your website.

I’ve attached a dump of the posts/postmeta tables. The whole DB was too big. And the CSV I used to import ticket meta data, including prices, event dates, order by dates and times, IDs for the events they are FK’d to, etc.

[rjjacob]

I’m sorry, I just found what you were referring to in the “Advanced” section under each ticket. I was looking in the wrong place.

Yes, the “End Sale” date was imported to be the same as the “Start Sale” date which was July 6, 2018, so all tickets are past the point of being for sale.

I have 7 ticket types available for about 100 events = 700 tickets to be updated to the correct “order by” times. How can I import that?

[Andras]

Hi,

Thanks for the extra info and the clarification.

Yeah, the event dates likely imported badly. That is likely because of the date format in the csv file. The format used there is MM.DD.YYYY, which can be confusing as it is similar to DD.MM.YYYY.

For date formatting the best option is to use YYYY-MM-DD. That is the clearest and it is the format mostly used in databases.

As for changing the dates, there are some options, although they are not ideal.

Option 1: deleting all tickets and re-importing them. The deletion can take a long time here.

Option 2: Running an SQL script directly in the database that changes the end sale dates to a future date.

For example you can run this to set all the end sale dates to November 30.

UPDATE wp_postmeta SET meta_value='2018-11-30 13:00:00' WHERE meta_key='_ticket_end_date'

It would also be possible to set up different end dates for the different events / tickets, than you will need more commands like the above.

To help you out a bit, I created this excel file for you based on your ticket csv.

https://www.dropbox.com/s/vcpbzv4sxgf2993/rjjacob.xlsx?dl=0

In the last column it contains the sql commands that would update the end sale date for those tickets to what is given in the file. You just need to copy-paste those lines when you run an SQL command on your database. You can also do more or even all at a time, however I would recommend doing batches.

I didn’t test all of the scripts but should work. And of course, create a database backup before running those.

Hope this helps.

Cheers,
Andras

[rjjacob]

Wow, that helped a lot! I really appreciate the time you spent on updating the import CSV and added those update queries. I had to modify the queries a bit because the post_id referenced in “_ticket_end_date” is actually the id for the *product* or individual ticket for a particular date and not the event post_id. But I worked that out, changed the update queries and got all the tickets into the database and displaying on the website.

Now I need to figure out how to add the ticket event dates to the Woocommerce email templates because all that’s going out is the skus and those don’t mean anything to the ticket buyers. But I’ll look at the documentation first and create a new thread if necessary.

[Andras]

I’m so happy to hear that helped you! I had quite some fun tinkering with it. 🙂

As for the emails, if it is a WooCommerce order status email that’s a bit more tricky.

If it is simply the email containing the ticket and ticket information, then you should look at this file:

wp-content/plugins/event-tickets/src/views/tickets/email.php

If you want to make any changes to that, then I recommend a template override.

This should get you started.

I am going to close this ticket for now as this question is resolved. If you need anything else related to this topic or another please create a new ticket and we’ll be happy to help.

Cheers,
Andras

PS: We’d be grateful if you would give us feedback on your satisfaction with support. Just click on one of the classy looking emojis below. 🙂 If you can spare a few words, that’s even better. Thanks!

PS2: If you like our plugins, and you didn’t yet do so 🙂 we would also be happy to receive a review in the wordpress.org repository. Much appreciated!
https://wordpress.org/support/view/plugin-reviews/the-events-calendar/
https://wordpress.org/support/view/plugin-reviews/event-tickets/

 

[Author]

Posts