Change order status on a date specified in order ACF field

Hi @nadya-well,

Thanks for reaching out.

I have escalated this with our development team. They will get back to you as soon as possible.

Kind regards,
Moshtafizur

Hi, @nadya-well,

Please try this:

add_filter( 'alg_wc_order_status_rules_do_apply_rule', function( $do_apply, $order, $rule_id, $args ) {
    if ( 1 == $rule_id && $do_apply ) {
        return (
            ( $date_to_check = $order->get_meta( 'reminder_mailing' ) ) &&
            time() >= strtotime( str_replace( '/', '-', $date_to_check ) )
        );
    }
    return $do_apply;
}, 10, 4 );

Please let me know if this is what we need.

I’ve added the code to functins.php and run the order status change rule, but the status didn’t update.

The ‘reminder_mailing’ field value is stored in postmeta table rather than on orders_meta, could that be the reason why the status update failed?

See screenshot: https://pasteboard.co/FTs7HG4vSTSR.png

• This reply was modified 6 months, 2 weeks ago by Nadya Well.

Hi, @nadya-well,

Could you please check the “Order Status History” meta box on the order edit page? Does it say “No order status rules are scheduled to be applied for the current order”, or something like “Status scheduled to be updated from Pending payment to Cancelled (Rule #1) on …”?

Also, could you please post a screenshot of your order rule settings (in “WooCommerce > Settings > Order Status Rules > Rule #X”)?

Hi,

Under the order status history box, it says ‘No order status rules are scheduled to be applied for the current order.‘

Here’s a screenshot of the rule setup: https://pasteboard.co/5Vwcr2I71h7o.png

Sorry, I checked again and it seems to be my mistake… the code you provided seems to be working correctly, I will test it out with a couple more orders but it looks good. Thank you so much for your help!

Hi, @nadya-well,

Happy to help ?? Please let me know if you have any questions.

One more questions – I have now purchased the Pro version of your plugin and would like to trigger 3 different rules in the same way, based on different ACF order field dates. What would be the best way to add several such rules?

Hi, @nadya-well,

You could do something like this:

add_filter( 'alg_wc_order_status_rules_do_apply_rule', function( $do_apply, $order, $rule_id, $args ) {

    if ( ! $do_apply ) {
        return false;
    }

    // Rule #1
    if ( 1 == $rule_id ) {
        return (
            ( $date_to_check = $order->get_meta( 'reminder_mailing_a' ) ) &&
            time() >= strtotime( str_replace( '/', '-', $date_to_check ) )
        );
    }

    // Rule #2
    if ( 2 == $rule_id ) {
        return (
            ( $date_to_check = $order->get_meta( 'reminder_mailing_b' ) ) &&
            time() >= strtotime( str_replace( '/', '-', $date_to_check ) )
        );
    }

    // Rule #3
    if ( 3 == $rule_id ) {
        return (
            ( $date_to_check = $order->get_meta( 'reminder_mailing_c' ) ) &&
            time() >= strtotime( str_replace( '/', '-', $date_to_check ) )
        );
    }

    return $do_apply;
}, 10, 4 );

• This reply was modified 6 months, 2 weeks ago by Algoritmika. Reason: Algorithm improved