What hook to be used for cancelled booking in WooCommerce Bookings?

Question

I'm trying to make an SQL query to run upon cancellation of a booking, via a custom plugin, updating custom user meta data.

Here's my code:

function wporg_callback() {
    global $wpdb;

    $wpdb->query("UPDATE usermeta SET meta_value = 15 WHERE umeta_id = 131");
}

add_action('woocommerce_bookings_cancelled_booking', 'wporg_callback');

But It's not working.
Is there something wrong with the query? Is the right action not being used?

---

Edit - I Also tried the following without success:

add_action('woocommerce_bookings_cancelled_booking', 'wporg_callback'); 
function wporg_callback( $booking_id ) { 
    // Add/Update custom user meta data 
    update_user_meta( 2, 'download_credits', 17 ); 
} 

Answer 1

Updated:

The correct hook to be used is woocommerce_booking_cancelled (a composite hook) that will allow you to retrieve the user ID and to Add/update custom user meta data like below:

add_action('woocommerce_booking_cancelled', 'booking_cancelled_transition_to_callback', 10, 2 );
function booking_cancelled_transition_to_callback( $booking_id, $booking ) {
    // Get the user ID from the Booking ID
    $user_id = get_post_field ('post_author', $booking_id);
    
    $download_credits = get_post_meta( $booking_id, '_booking_cost', true );
    
    // Add/Update custom user meta data
    update_user_meta( $user_id, 'download_credits', $download_credits );
}

Code goes in functions.php file of your active child theme (or theme). Tested and works.

---

How to get the booking data (from the booking ID displayed in the order):

• Go to your database under wp_postmeta table to get the desired meta_key from the post_id (that is the booking ID)

• Use that meta key in get_post_meta() WordPress function like:

   $meta_value = get_post_meta($booking_id, 'the_meta_key', true); 
  

---

Notes:

• An SQL query is not needed to add/update custom user meta data, as you can use instead the dedicated Wordpress function update_user_meta().

• I couldn't make it work using woocommerce_bookings_cancelled_booking hook.

---

WooCommerce Bookings action and filters hooks developer documentation