Auto Remove Incomplete/Unpaid Orders

[Ian Mead]

Hi,

Does anyone have a hook that would automatically remove incomplete/unpaid orders after a set time?

 

Many thanks

[leemahoney3]

I assume you only want this to happen on Pending unpaid orders? If so, the order needs to be cancelled before deleted. The below hook should work

<?php

use Carbon\Carbon;
use WHMCS\Order\Order;

add_hook('DailyCronJob', 1, static function () {
    $daysBeforeDeletion = 14;

    Order::where('status', 'Pending')->each(function (Order $order) use ($daysBeforeDeletion, &$orders) {
        if ($order->isPaid) {
            return;
        }

        if ($order->date->addDays($daysBeforeDeletion)->toDateString() > Carbon::now()->toDateString()) {
            return;
        }

        $cancelResult = localAPI('CancelOrder', ['orderid' => $order->id]);
        if ($cancelResult['result'] === 'success') {
            localAPI('DeleteOrder', ['orderid' => $order->id]);
        }
    });
});

Update the $daysBeforeDeletion variable to how many days you wish to keep the order after its order date before its deleted. This will run once a day on your WHMCS cron job.

[Ian Mead]

Hi Lee

Thank you very much. I have implemented that now.

Perfect solution.

[Carl M]

Does this hook still work? Going to pass it onto our dev team for testing.