FooEvents - Output number of canceled tickets

In this article, I will use a code example to show you how to output the number of canceled FooEvents tickets via an SQL query of the WordPress database.

Code Snippets - WordPress - FooEvents

When using third-party plugins, I repeatedly encounter issues that, in my clients„ opinion, “should really be resolved by the premium plugin itself.”.

The „FooEvents“ is no exception. It is an event plugin that enables the management of events and ticket sales via WooCommerce.

I have programmed a dashboard widget for one of my customers that is displayed in the WordPress admin area directly after login and clearly lists all upcoming events together with the number of registered participants, a button for direct download of the participant list as a csv file and also canceled ticket numbers. It also prominently displays for each event as soon as all available tickets have been sold. In the case of this customer, a waiting list functionality is then activated. Whether the waiting list has been activated is clearly displayed in the dashboard widget.

Below I have listed the code component that outputs the number of canceled FooEvents tickets. This may be useful for someone out there:

Do you have questions about the code? Questions about the FooEvents plugin or other comments? Then please use the comment function at the end of this article.

Best regards
Saskia Teichmann (formerly Lund)

About the Author

Saskia Teichmann provides consulting on AI, e-commerce, and digital platforms, and personally verifies technical assumptions in architecture and code.

More About My Work

Discussion on the post

2 comments

Questions, additions, and real-world experiences—developed over time and preserved here in their entirety.

  1. Lars Hansen

    I have exactly the same problem, have installed FooEvents, and lack the ability to extract a participant list of the upcoming events, but Foo doesn't really have anything to offer. Their CSV export can't really help any good.
    It's a bit strange that they don't have such a module 🙁
    Greetings from Bornholm

    Replies
    1. Saskia Teichmann

      Hey Lars,
      Thanks for your comment! I can definitely help with that, but since it takes a bit more effort, I'd need you to book me as a developer. If you're up for it, we can sort out the details and get it done.

      Let me know!

      Cheers,
      Saskia

      Replies

Join the discussion

Your email address will not be published. Required fields are marked.

News from the Studio

New posts via email.

Whenever a new workshop report or guide is published, you'll receive a brief email with a link. No set schedule, no ads.

Prefer to read via RSS

Your registration will not become active until you click on the confirmation link. You can cancel your subscription at any time by clicking the link in any email.