Reset failed payout status for CT on Order status toggle

functions.php

<?php


add_action( 'woocommerce_order_status_changed', 'rt_ct_reset_failed_payouts', 9, 4 );

function rt_ct_reset_failed_payouts( $order_id, $status_from, $status_to, $order ) {
	global $wpdb;
	if ( 'completed' == $status_to ) {
		$query = $wpdb->query( "UPDATE $wpdb->posts SET post_status = 'tribe-payout-pending' WHERE post_status = 'tribe-payout-failed'" );
	}
}

This should be deactivated immediately after triggering the status change on the order.