Birendra Maharjan

Hi @nadya-well,

I’ve reviewed your code and noticed a couple of things that might be causing the issue:

1. Meta mismatch: You mentioned that the date is saved in the product meta, but your code is trying to fetch it from the order item meta. This mismatch can cause unexpected results. If you want to check the date directly from the product, you should retrieve it from the product meta. Otherwise, if the date is saved in the order item when the order is created, your current approach using $item->get_meta() will work.

2. Missing false return: Your code doesn’t explicitly return false when the date check is not valid. Because of this, it falls back to $do_apply, which always follows the plugin’s default rule setting. This could be why the rule is applied earlier than expected.

I’ve adjusted your code based on these points. Please try the following snippet and let us know if it resolves the issue:

add_filter( 'alg_wc_order_status_rules_do_apply_rule', function ( $do_apply, $order, $rule_id, $args ) {
	if ( 1 == $rule_id && $do_apply ) {
		// Use the London timezone (which automatically adjusts for BST/GMT)
		$timezone = new DateTimeZone( 'Europe/London' );

		// Get the current time in the London timezone
		$current_time      = new DateTime( "now", $timezone );
		$current_timestamp = $current_time->getTimestamp();

		// Loop through order items and check the 'Date Of Visit' meta field
		foreach ( $order->get_items() as $item_id => $item ) {
			// Get the 'Date Of Visit' meta field for the current product
			//$product_date = $item->get_meta( 'Date Of Visit' );

			$product_id   = $item->get_product_id();
			$product_date = get_post_meta( $product_id, 'Date Of Visit', true ); // Please ensure that the meta key 'Date Of Visit' is correct

			// Check if the 'Date Of Visit' exists
			if ( $product_date ) {
				// Convert the 'Date Of Visit' from dd/mm/yyyy to yyyy-mm-dd format
				$product_date = str_replace( '/', '-', $product_date );

				// Convert the 'Date Of Visit' to a timestamp in London timezone (BST/GMT)
				$datetime          = DateTime::createFromFormat( 'd-m-Y', $product_date, $timezone );
				$product_timestamp = $datetime ? $datetime->getTimestamp() : false;

				// Check if the date is valid and is in the past (or today)
				if ( $product_timestamp !== false && $current_timestamp >= $product_timestamp ) {
					return true; // Apply the rule as soon as we find one valid date
				}
			}
		}

		return false;
	}

	return $do_apply; // If no valid date is found, return the original decision
}, 10, 4 );

If this doesn’t resolve the issue, please consider reaching out to us via a support ticket at [email protected] so we can review your exact configuration in more detail and provide direct assistance.

Best regards,

Hi @marketingphenom,

Thank you for using our plugin! As you described, the order status will change from ‘Processing‘ to ‘On Hold‘ immediately, and the order will then be manually set back to ‘Processing‘. This can be achieved without automation. Please follow the steps below:

1. Go to the Advanced tab.
2. Set the Save status change on value to Order status changed.
3. Set the Save status change on value to “Thank You” (i.e., “Order received”) page.
4. Disable both the Use WP Cron and Use Action Scheduler options.

Please try these steps and let us know if they work for you. If they don’t meet your requirements or you encounter any issues, please inform us.

Thank you!

Best regards,