如果在WooCommerce中没有付款，则在X天后自动取消订单

Question

我在搜索网络后设法将其放在一起，但是它不起作用。我的目标是自动取消所有状态为暂停的订单，无论支付网关如何，如果订单在三天后仍未付款。

代码显然不完整，我正在寻求帮助使其完整。我正在用-1 minute测试它，看看是否发生了什么。它没有。

function get_unpaid_orders() {
global $wpdb;
$unpaid_orders = $wpdb->get_col( $wpdb->prepare( "
SELECT posts.ID
FROM {$wpdb->posts} AS posts
WHERE posts.post_status = 'wc-on-hold'
AND posts.post_date < %s
", date( 'Y-m-d H:i:s', strtotime('-1 minute') ) ) );
return $unpaid_orders;
}
add_action( 'woocommerce_cancel_unpaid_submitted', 'cancel_unpaid_orders' );
function cancel_unpaid_orders() {
$unpaid_orders = get_unpaid_orders();
if ( $unpaid_orders ) {
foreach ( $unpaid_orders as $unpaid_order ) {
$order = wc_get_order( $unpaid_order );
$cancel_order = true;
foreach  ( $order->get_items() as $item_key => $item_values) {
$manage_stock = get_post_meta( $item_values, '_manage_stock', true );
if ( $manage_stock == "yes" ) {
$payment_method = $order->get_payment_method();
if ( $payment_method == "bacs" ) {
$cancel_order = false;
}
}
}
if ( $cancel_order == true ) {
$order -> update_status( 'cancelled', __( 'The order was cancelled due to no payment from customer.', 'woocommerce') );
}
}
}
}

Answer 1

更新 4

注意：在WooCommerce中，已经有一个功能钩woocommerce_cancel_unpaid_orders动作钩子，可以在7天后取消未付订单。

我没有找到woocommerce_cancel_unpaid_submitted动作钩子，所以我不知道它是否存在以及它是否被触发。

现在你的代码中有一些错误，你可以更好地使用 wc_get_orders()，它直接给你正确的WC_Order对象数组......

以下是一些不同的方法(最后一个未经测试)：

1) 最后一个解决方案经过测试并有效当商店经理或管理员用户角色浏览管理员订单列表(每天仅执行一次)时：

add_action( 'restrict_manage_posts', 'cancel_unpaid_orders' );
function cancel_unpaid_orders() {
global $pagenow, $post_type;
// Enable the process to be executed daily when browsing Admin order list 
if( 'shop_order' === $post_type && 'edit.php' === $pagenow 
&& get_option( 'unpaid_orders_daily_process' ) < time() ) :
$days_delay = 5; // <=== SET the delay (number of days to wait before cancelation)
$one_day    = 24 * 60 * 60;
$today      = strtotime( date('Y-m-d') );
// Get unpaid orders (5 days old)
$unpaid_orders = (array) wc_get_orders( array(
'limit'        => -1,
'status'       => 'on-hold',
'date_created' => '<' . ( $today - ($days_delay * $one_day) ),
) );
if ( sizeof($unpaid_orders) > 0 ) {
$cancelled_text = __("The order was cancelled due to no payment from customer.", "woocommerce");
// Loop through orders
foreach ( $unpaid_orders as $unpaid_order ) {
$unpaid_order->update_status( 'cancelled', $cancelled_text );
}
}
// Schedule the process to the next day (executed once restriction)
update_option( 'unpaid_orders_daily_process', $today + $one_day );
endif;
}

代码进入函数.php活动子主题(或活动主题)的文件。

---

2)第三种解决方案经过测试并有效： 当任何订单更改为"正在处理"或"已完成"状态(每天仅执行一次)时，将触发该功能：

// Triggered on orders status change to "processing" or "completed"
add_action( 'woocommerce_order_status_changed', 'daily_cancel_unpaid_orders', 10, 4 );
function daily_cancel_unpaid_orders( $order_id, $old_status, $new_status, $order ) {
// Enable the process to be executed daily
if( in_array( $new_status, array('processing', 'completed') ) 
&& get_option( 'unpaid_orders_daily_process' ) < time() ) :
$days_delay = 5; // <=== SET the delay (number of days to wait before cancelation)
$one_day    = 24 * 60 * 60;
$today      = strtotime( date('Y-m-d') );
// Get unpaid orders (5 days old)
$unpaid_orders = (array) wc_get_orders( array(
'limit'        => -1,
'status'       => 'on-hold',
'date_created' => '<' . ( $today - ($days_delay * $one_day) ),
) );
if ( sizeof($unpaid_orders) > 0 ) {
$cancelled_text = __("The order was cancelled due to no payment from customer.", "woocommerce");
// Loop through WC_Order Objects
foreach ( $unpaid_orders as $order ) {
$order->update_status( 'cancelled', $cancelled_text );
}
}
// Schedule the process to the next day (executed once restriction)
update_option( 'unpaid_orders_daily_process', $today + $one_day );
endif;
}

代码进入函数.php活动子主题(或活动主题)的文件。

---

3)所以你可以尝试使用woocommerce_cancel_unpaid_submitted动作钩子：

add_action( 'woocommerce_cancel_unpaid_submitted', 'cancel_unpaid_orders' );
function cancel_unpaid_orders() {
$days_delay = 5; // <=== SET the delay (number of days to wait before cancelation)
$one_day    = 24 * 60 * 60;
$today      = strtotime( date('Y-m-d') );
// Get unpaid orders (5 days old here)
$unpaid_orders = (array) wc_get_orders( array(
'limit'        => -1,
'status'       => 'on-hold',
'date_created' => '<' . ( $today - ($days_delay * $one_day) ),
) );
if ( sizeof($unpaid_orders) > 0 ) {
$cancelled_text = __("The order was cancelled due to no payment from customer.", "woocommerce");
// Loop through orders
foreach ( $unpaid_orders as $order ) {
$order->update_status( 'cancelled', $cancelled_text );
}
}
}

代码进入函数.php活动子主题(或活动主题)的文件。

函数代码应该更好地工作。对于钩子，我真的不知道。

---

4)您也可以尝试使用woocommerce_cancel_unpaid_orders动作钩

。

Answer 2

只是增加了@LoicTheAztec精彩的答案。我将其修改为插件，并添加了一个设置页面，您可以在其中启用/禁用此功能，以及从管理员设置中更改延迟天数。代码如下：

<?php
/**
* Plugin Name: Cancel On-Hold Orders After X Days
* Plugin URI: https://smartairfilters.com
* Description: Cancel orders that are in an 'on-hold' status after a certain number of days. Uses wordpress cron to trigger
* Version: 1.0.0
* Author: Paddy Robertson
* Author URI: https://patrickrobertson.uk
* Requires at least: 5.3
* Requires PHP: 7.0
*/
add_action('woocommerce_cancel_unpaid_orders', 'cancel_onhold_orders');
function cancel_onhold_orders() {
if (!get_option('cancel_onhold_enable')) {
// only run if feature is enabled
return;
}
$days_delay = get_option('cancel_onhold_days_delay'); // <=== SET the delay (number of days to wait before cancelation)
echo "days delay   xxxx " . $days_delay;
$one_day    = 24 * 60 * 60;
$today      = strtotime( date('Y-m-d') );
// Get unpaid orders (5 days old here)
$unpaid_orders = (array) wc_get_orders(array(
'orderby' => 'date',
'order' => 'DESC',
'limit'        => -1,
'status'       => 'on-hold',
'date_created' => '<' . ($today - ($days_delay * $one_day)),
));
if ( sizeof($unpaid_orders) > 0 ) {
$cancelled_text = __("The order was cancelled due to no payment from customer.", "woocommerce");
// Loop through orders
foreach ( $unpaid_orders as $order ) {
$order->update_status( 'cancelled', $cancelled_text );
}
}
}
// Settings page
function cancel_onhold_register_settings() {
register_setting( 'cancel_onhold_group', 'cancel_onhold_days_delay');
register_setting( 'cancel_onhold_group', 'cancel_onhold_enable');
}
add_action( 'admin_init', 'cancel_onhold_register_settings' );
function cancel_onhold_register_options_page() {
add_options_page('Cancel On-Hold Orders', 'Cancel On-Hold', 'manage_options', 'cancel_onhold_options_page', 'cancel_onhold_options_page');
}
add_action('admin_menu', 'cancel_onhold_register_options_page');
function cancel_onhold_options_page() {
?>
<div>
<h2>Cancel On-Hold Orders after X Days</h2>
<form method="post" action="options.php">
<?php settings_fields( 'cancel_onhold_group' ); ?>
<table class="form-table">
<tr valign="top">
<th scope="row"><label for="cancel_onhold_enable">Enable/Disable this feature</label></th>
<td><input type="checkbox" id="cancel_onhold_enable" name="cancel_onhold_enable" value="1" <?php checked(get_option('cancel_onhold_enable')); ?>" /></td>
</tr>
<tr valign="top">
<th scope="row"><label for="cancel_onhold_days_delay">Enter number of days after which on hold orders will be cancelled</label></th>
<td><input type="number" id="cancel_onhold_days_delay" name="cancel_onhold_days_delay" value="<?php echo get_option('cancel_onhold_days_delay'); ?>" /> days</td>
</tr>
</table>
<?php submit_button(); ?>
</form>
</div>
<?php
}