baras

Hi,

My best solution so far is to remove the coupon usage from the database.

/**
 * Executed when the status is changed to failed.
 *
 * @param int $order_id
 * @param \WC_Order $order
 */
function ladida_woocommerce_order_status_failed( $order_id, $order ) {
	global $wpdb;

	foreach ( $order->get_coupon_codes() as $coupon_code ) {
		$coupon_object = new WC_Coupon( $coupon_code );

		$sql = "DELETE FROM {$wpdb->postmeta}
				WHERE post_id = %d AND meta_value = %d
				LIMIT 1;";
		$wpdb->query( $wpdb->prepare( $sql, $coupon_object->get_id(), $order->get_user_id() ) );

		$sql = "DELETE FROM {$wpdb->prefix}wc_order_coupon_lookup
				WHERE order_id = %d AND coupon_id = %d
				LIMIT 1;";
		$wpdb->query( $wpdb->prepare( $sql, $order->get_id(), $coupon_object->get_id() ) );
	}
}

add_action( 'woocommerce_order_status_failed', 'ladida_woocommerce_order_status_failed', 15, 2 );

This works well most of the time, however sometimes, if I continue to other pages and attempt checkout again, the usage returns to the database somehow.

Any input on how that might happen?

Thanks!