Tom Anbinder

Hi, Lisa,

Yes, I think this is doable – try enabling the “Meta > Multiple meta values” checkbox and setting the “Meta > Meta value” option to:

,0

Please give it a try and let me know what you think.

P.P.S. Could you please check if “WordPress cron” is enabled on your site (in “WooCommerce > Status > System status”)? If it’s disabled, could you please enable it?

You could also try switching from “Use WP cron” to “Use Action Scheduler” in “WooCommerce > Settings > Order Status Rules > Advanced > Periodical Processing Options”. However, as far as I understand, “Action Scheduler” uses WP cron, so I’m not sure if it’ll help.

Also, did you try running the rules manually in “WooCommerce > Settings > Order Status Rules > Tools > Run all rules now”? What happens then? Are orders processed as expected?

Update: Since the latest plugin v2.9.3, we can now achieve what we need without custom triggers and code. There are two new “Extra” triggers: “Customer address saved” and “Customer address changed”. The first one is the same as the woocommerce_after_save_address_validation custom trigger I mentioned earlier. The second one is fired only if the address was actually changed (i.e., not just saved without any changes).

Please give it a try and let me know what you think.

P.S. I’ve just noticed that you posted a screenshot earlier – your settings look ok there. If it’s not working – would it be possible to share access to your site, so I could log in and check what’s going on (my email is [email protected])?

Hi,

I think what you need is the woocommerce_after_save_address_validation trigger:

1. add it to the “Custom triggers” option (in “WooCommerce > Settings > Custom Emails > General”),
2. select it in your custom email’s “Triggers” option (in “WooCommerce > Settings > Emails > Custom email #X”).

P.S. If you want to use the [user_prop] shortcode in the custom email’s “Email content” option – add this PHP snippet to your site:

add_filter( 'alg_wc_custom_emails_is_user_email', function ( $is_user_email, $current_filter ) {
    return ( 'woocommerce_after_save_address_validation_notification' === $current_filter ? true : $is_user_email );
}, 10, 2 );

And then you can use this in your email’s content:

[user_prop key="nickname"]
[user_prop key="description"]
[user_prop key="first_name"]
[user_prop key="last_name"]
[user_prop key="user_login"]
[user_prop key="user_nicename"]
[user_prop key="user_email"]
[user_prop key="user_url"]
[user_prop key="display_name"]

Please give it a try and let me know what you think.

Hi, Liviu,

Please update the plugin to the latest v2.9.1 and add this snippet to your site:

add_action( 'alg_wc_custom_emails_email_sent', function ( $email ) {

    global $wpdb;

    $option_name = "woocommerce_{$email->id}_settings";

    // Start MySQL transaction
    $wpdb->query( 'START TRANSACTION' );

    // Get current settings
    $row = $wpdb->get_row( $wpdb->prepare( "SELECT option_value FROM {$wpdb->options} WHERE option_name = %s LIMIT 1", $option_name ) );

    // Exclude recipients
    $settings = ( isset( $row->option_value ) && '' !== $row->option_value ? unserialize( $row->option_value ) : array() );
    $settings['exclude_recipients'] = $email->get_recipient() . ',' . ( $settings['exclude_recipients'] ?? '' );
    $settings = serialize( $settings );

    // Update (or Insert)
    if ( 0 === ( $result = $wpdb->update( $wpdb->options, array( 'option_value' => $settings, 'autoload' => 'yes' ), array( 'option_name' => $option_name ) ) ) ) {
        $result = $wpdb->insert( $wpdb->options, array( 'option_value' => $settings, 'autoload' => 'yes', 'option_name' => $option_name ) );
    }

    // Commit (or Rollback) MySQL transaction
    $wpdb->query( ( $result ? 'COMMIT' : 'ROLLBACK' ) );

} );

This snippet will automatically append the current recipient to the “Exclude recipients” option (in “WooCommerce > Settings > Emails > Custom email #X > Advanced Options”). This way, you can manually edit it if needed. However, the option may become too long if you send a lot of emails.

P.S. Generally, the snippet does this:

add_action( 'alg_wc_custom_emails_email_sent', function ( $email ) {
    $email->update_option(
        'exclude_recipients',
        $email->get_recipient() . ',' . $email->get_option( 'exclude_recipients', '' )
    );
} );

However, I think this shorter version has a problem – it may skip adding a recipient if two different custom emails are sent at (almost) the same time. To solve this, in the first snippet we are using MySQL transactions and executing DB queries directly.

Please give it a try and let me know what you think.

Hi, Jesse,

Sorry for not getting back to you sooner.

Could you please enable the “Debug” checkbox in “WooCommerce > Settings > Custom Emails > General > Advanced Options”, trigger automatic email, and then check today’s log in “WooCommerce > Status > Logs” (the log will start with custom-emails-for-woocommerce-...). What does it say?

P.S. If this won’t help – would it be possible to share access to your site, so I could log in and check what’s going on (my email is [email protected])?