时间戳

首页 > 解决方案 > 如果在 WooCommerce 中没有付款，X 天后自动取消订单

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

问题描述

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

代码显然不完整，我正在寻求帮助以使其完整。我正在测试它，-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') );
            }
        }
    }
}

标签： phpsqlwordpresswoocommerceorders

解决方案

更新 4

注意：在 WooCommerce 中，已经有一个钩子在woocommerce_cancel_unpaid_ordersaction hook 中的函数，可以在 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;
}

代码位于您的活动子主题（或活动主题）的 function.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;
}

代码位于您的活动子主题（或活动主题）的 function.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 );
        }
    }
}

代码位于您的活动子主题（或活动主题）的 function.php 文件中。

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

4）您也可以尝试使用woocommerce_cancel_unpaid_orders动作挂钩。

推荐阅读