{"id":47947,"date":"2025-05-12T14:19:54","date_gmt":"2025-05-12T14:19:54","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/?post_type=tips-and-tricks&p=47947"},"modified":"2025-05-12T14:24:10","modified_gmt":"2025-05-12T14:24:10","slug":"deleting-booking-when-external-calendar-entry-deleted","status":"publish","type":"tips-and-tricks","link":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/","title":{"rendered":"Deleting Booking When External Calendar Entry Is Deleted"},"content":{"rendered":"
<\/svg><\/div>
Things to know<\/div>

In this tutorial, we use Google Calendar as an example; however, the same workflow applies to other calendar services as well.<\/p><\/div><\/div>\n\n\n\n

When synchronizing external calendars for apartments, a new booking item is created. However, when we modify the external calendar by deleting the entry and re-synchronizing, it remains in the booking list on the site; therefore, this date range cannot be booked.<\/p>\n\n\n\n

To delete or update the booking status to one that allows you to use the re-selected dates, follow these steps.<\/p>\n\n\n

<\/svg><\/div>
Warning<\/div>

Before proceeding with the tutorial\u2032s steps, create a backup or replicate the actions on the staging site. The backup ensures the website restoration if an error occurs. To learn more, proceed to the How to Backup and Restore a WordPress Website with a Plugin<\/a> article.<\/p><\/div><\/div>\n\n\n\n

Create an Additional Booking Column<\/h2>\n\n\n\n

To create an additional custom column, go to the WordPress Dashboard > Bookings > Settings > Tools<\/em><\/strong> tab, press the \u201cNew DB Column<\/strong>\u201d button, and enter a unique Column name <\/strong>(e.g., \u201c_calendar_id\u201d). Then, push the \u201cUpdate Booking Tables<\/strong>\u201d button to save the changes. The column will be used to save information about the external calendar and in queries.<\/p>\n\n\n

<\/svg><\/div>
Warning<\/div>

Be aware that the Hide DB columns manager <\/strong>toggle in the Advanced<\/strong><\/a> settings tab hides both columns and the \u201cNew DB Column<\/strong>\u201d button. Ensure it is turned off when creating columns.<\/p><\/div><\/div>\n\n\n\n

\"additional<\/a><\/div>\n\n\n\n

Add Hooks<\/h2>\n\n\n\n

After creating the custom column to store calendar information, use the jet-booking\/ical\/import\/node<\/em> hook. This hook runs for each booking during iCal synchronization and allows you to attach the calendar ID (a unique iCal link) to each imported booking.<\/p>\n\n\n\n

Since a single apartment can be synced with multiple external calendars, this ID helps distinguish which bookings come from which source, making it easier to manage various calendar integrations per unit.<\/p>\n\n\n\n

The hook can be added either via a custom code snippets plugin (like Code Snippets<\/em><\/a>) or directly in your theme\u2019s functions.php<\/strong> file (preferably a child theme to prevent overwrite on updates).<\/p>\n\n\n\n

For example, we install and activate the Code Snippets <\/em>plugin, then proceed to the WordPress Dashboard > Snippets<\/em><\/strong> tab and click the \u201cAdd New<\/strong>\u201d button.<\/p>\n\n\n\n

We type the hook name into the title bar (e.g., \u201cJetBooking iCal Calendar ID Hook\u201d) and enter such code into the Functions (PHP) <\/strong>textarea:<\/p>\n\n\n\n

add_filter( 'jet-booking\/ical\/import\/node', function( $import_node, $node, $calendar_object, $calendar_url ) {\r\n\r\n\r\n\t$import_node['_calendar_id'] = esc_url( $calendar_url ); \/\/ `_calendar_id` name of custom created DB column via plugin settings.\r\n\r\n\r\n\treturn $import_node;\r\n\r\n\r\n}, 10, 4 );<\/code><\/pre>\n\n\n
<\/svg><\/div>
Warning<\/div>
Ensure to replace the _calendar_id with your JetBooking DB column name set in the previous step.<\/p><\/div><\/div>\n\n\n\n
\"JetBooking<\/a><\/div>\n\n\n
<\/svg><\/div>
Things to know<\/div>
Note that the calendar ID is added only to newly imported bookings. Existing bookings synchronized earlier will not have this ID assigned.<\/p><\/div><\/div>\n\n\n\n
Now, press the \u201cSave Changes and Activ<\/strong>a<\/strong>te<\/strong>\u201d button to save the snippet.<\/p>\n\n\n\n
For final processing, we\u2019ll use the jet-booking\/ical\/import\/log<\/em> hook. While not originally intended for this use case, it fits well due to its execution timing and available parameters. The hook runs once per calendar during synchronization.<\/p>\n\n\n\n
Using it, we can fetch all bookings tied to the current calendar ID and compare them to the latest iCal data. Any bookings no longer present in the external calendar can then be marked as canceled.<\/p>\n\n\n\n
Push the \u201cAdd New<\/strong>\u201d button one more time, type the title (e.g., \u201cCancel iCal Bookings by Calendar ID (JetBooking Hook)\u201d), and enter the following code:<\/p>\n\n\n\n
add_filter( 'jet-booking\/ical\/import\/log', function( $import_log, $post_id, $unit_id, $inserted, $skipped, $calendar_url ) {\r\n\r\n\r\n\t\/\/ Get all bookings that are related to the synced calendar.\r\n\t$calendar_bookings = jet_abaf_get_bookings( [\r\n\t\t'meta_query' => [\r\n\t\t\t[\r\n\t\t\t\t'column'   => '_calendar_id', \/\/ `_calendar_id` name of custom created DB column via plugin settings.\r\n\t\t\t\t'operator' => '=',\r\n\t\t\t\t'value'    => $calendar_url\r\n\t\t\t],\r\n\t\t],\r\n\t\t'return'     => 'arrays',\r\n\t] );\r\n\r\n\r\n\tif ( empty( $calendar_bookings ) ) {\r\n\t\treturn $import_log;\r\n\t}\r\n\r\n\r\n\tforeach ( $calendar_bookings as $booking ) {\r\n\t\t\/\/ Compare synced bookings to existing.\r\n\t\tif ( in_array( $booking['ID'], $inserted ) || in_array( $booking['import_id'], $skipped ) ) {\r\n\t\t\tcontinue;\r\n\t\t}\r\n\r\n\r\n\t\t\/\/ Change status to cancelled for calendar bookings that are not in sync anymore.\r\n\t\tjet_abaf()->db->update_booking( $booking['ID'], [ 'status' => 'cancelled' ] );\r\n\t}\r\n\r\n\r\n\treturn $import_log;\r\n\r\n\r\n}, 10, 6 );\r<\/code><\/pre>\n\n\n\n
If you need to delete the reservation from the site completely, then the line:<\/p>\n\n\n\n
jet_abaf()->db->update_booking( $booking['ID'], [ 'status' => 'cancelled' ] );<\/code><\/pre>\n\n\n\n
can be replaced with:<\/p>\n\n\n\n
jet_abaf()->db->delete_booking( [ 'booking_id' => $booking['ID'] ] );<\/code><\/pre>\n\n\n
<\/svg><\/div>
Warning<\/div>
Once again, ensure to replace the _calendar_id with your JetBooking DB column name set in the previous step.<\/p><\/div><\/div>\n\n\n\n
\"Cancel<\/a><\/div>\n\n\n\n
Check the Result<\/h2>\n\n\n\n
In this case, we set the hook to change the booking status to \u201cCancelled\u201d after deleting a booking from the external calendar.<\/p>\n\n\n\n
First, we created several bookings in the Google Calendar.<\/p>\n\n\n\n
\"bookings<\/a><\/div>\n\n\n\n
Then, we synchronize two calendars in the WordPress Dashboard > Bookings > Calendars <\/em><\/strong>tab by clicking the \u201cSynch<\/strong>\u201d button for the required apartment.<\/p>\n\n\n\n
\"synchronizing<\/a><\/div>\n\n\n\n
After synchronization on the WordPress website, they are displayed in the WordPress Dashboard > Bookings <\/em><\/strong>tab.<\/p>\n\n\n\n
\"bookings<\/a><\/div>\n\n\n\n
Then, we return to the Google Calendar and delete one booking.<\/p>\n\n\n\n
\"deleting<\/a><\/div>\n\n\n\n
After the synchronization, its status was changed to \u201cCancelled\u201d on the WordPress website.<\/p>\n\n\n\n
\"booking<\/a><\/div>\n\n\n\n
That\u2019s all. Now you know how to delete or cancel a booking when an external calendar entry is deleted, using the example of the iCal synchronization between Google Calendar and JetBooking<\/em> on the WordPress website.<\/p>\n","protected":false},"excerpt":{"rendered":"
Learn how to delete or cancel a booking when an external calendar entry is deleted, using the example of the iCal synchronization between Google Calendar and JetBooking.<\/p>\n","protected":false},"author":8,"featured_media":0,"template":"","format":"standard","tipstricks-tags":[578],"yoast_head":"\nDeleting Booking When External Calendar Entry Deleted \u2014 JetBooking | Crocoblock<\/title>\n<meta name=\"description\" content=\"Learn how to delete or cancel a booking when an external calendar entry is deleted, using the example of the iCal synchronization between Google Calendar and JetBooking on the WordPress website.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Deleting Booking When External Calendar Entry Deleted \u2014 JetBooking | Crocoblock\" \/>\n<meta property=\"og:description\" content=\"Learn how to delete or cancel a booking when an external calendar entry is deleted, using the example of the iCal synchronization between Google Calendar and JetBooking on the WordPress website.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-12T14:24:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/05\/additional-booking-table-column-for-external-calendar.webp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/\",\"name\":\"Deleting Booking When External Calendar Entry Deleted \u2014 JetBooking | Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2025-05-12T14:19:54+00:00\",\"dateModified\":\"2025-05-12T14:24:10+00:00\",\"description\":\"Learn how to delete or cancel a booking when an external calendar entry is deleted, using the example of the iCal synchronization between Google Calendar and JetBooking on the WordPress website.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tips & tricks\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Deleting Booking When External Calendar Entry Is Deleted\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/\",\"name\":\"Help Center\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/crocoblock.com\/knowledge-base\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#organization\",\"name\":\"Help Center\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg\",\"contentUrl\":\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg\",\"caption\":\"Help Center\"},\"image\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Deleting Booking When External Calendar Entry Deleted \u2014 JetBooking | Crocoblock","description":"Learn how to delete or cancel a booking when an external calendar entry is deleted, using the example of the iCal synchronization between Google Calendar and JetBooking on the WordPress website.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/","og_locale":"en_US","og_type":"article","og_title":"Deleting Booking When External Calendar Entry Deleted \u2014 JetBooking | Crocoblock","og_description":"Learn how to delete or cancel a booking when an external calendar entry is deleted, using the example of the iCal synchronization between Google Calendar and JetBooking on the WordPress website.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/","og_site_name":"Help Center","article_modified_time":"2025-05-12T14:24:10+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/05\/additional-booking-table-column-for-external-calendar.webp"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/","url":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/","name":"Deleting Booking When External Calendar Entry Deleted \u2014 JetBooking | Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2025-05-12T14:19:54+00:00","dateModified":"2025-05-12T14:24:10+00:00","description":"Learn how to delete or cancel a booking when an external calendar entry is deleted, using the example of the iCal synchronization between Google Calendar and JetBooking on the WordPress website.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/deleting-booking-when-external-calendar-entry-deleted\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/crocoblock.com\/knowledge-base\/"},{"@type":"ListItem","position":2,"name":"Tips & tricks","item":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/"},{"@type":"ListItem","position":3,"name":"Deleting Booking When External Calendar Entry Is Deleted"}]},{"@type":"WebSite","@id":"https:\/\/crocoblock.com\/knowledge-base\/#website","url":"https:\/\/crocoblock.com\/knowledge-base\/","name":"Help Center","description":"","publisher":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/crocoblock.com\/knowledge-base\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/crocoblock.com\/knowledge-base\/#organization","name":"Help Center","url":"https:\/\/crocoblock.com\/knowledge-base\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/","url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg","contentUrl":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg","caption":"Help Center"},"image":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/tips-and-tricks\/47947"}],"collection":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/tips-and-tricks"}],"about":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/types\/tips-and-tricks"}],"author":[{"embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/users\/8"}],"wp:attachment":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/media?parent=47947"}],"wp:term":[{"taxonomy":"tipstricks-tags","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/tipstricks-tags?post=47947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}