Tickets that were created after the FooEvents Bookings plugin was updated to version 1.4.0 include a custom field called ‘WooCommerceEventsBookingDateTimestamp‘. Only tickets that include this custom field can be filtered down to a date level using the FooEvents Bookings management screen (Go to FooEvents > Bookings).
In order to filter past tickets by booking date, you will need to run a script that adds the relevant custom fields to all tickets that were generated before the custom meta was implemented. To make it easier for you to do this, we have created a simple plugin that will allow you to run the updates in small batches. If you would like to proceed and add the timestamp custom field to previous tickets, please follow these steps:
NB: We highly recommend that you first create a back-up of your current website files and database before proceeding beyond this point and make use of a staging site if possible
Go to FooEvents Bookings Timestamp Updater in the main menu
This screen will allow you to add the custom field timestamp that can be used to filter the tickets by booking date. By default, the FooEvents Bookings Timestamp Updater will update 100 orders at a time. This is a safe limit and should only take a second to complete. Depending on the size of your database and the capacity of your server, you can adjust the amount as needed.
Once you have set the preferred amount, click the Run Updater button. The FooEvents Bookings Timestamp Updater plugin will then update the specified number of tickets.
After each batch has completed, continue to run the updater by clicking the Run Updater button until there are no remaining tickets that require updates.
When zero tickets remain, please remove the FooEvents Bookings Timestamp Updater plugin by going to Plugins in the main menu and then deactivating and deleting the FooEvents Bookings Timestamp Updater plugin.
All tickets that did not previously include the timestamp custom field should now include this field and reflect when filtering bookings by date.
To provide the best user experience, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
