WooCommerce Scheduled Actions Tab

public static function sale_products( $atts ) {
    global $woocommerce_loop;

    return '<div class="woocommerce columns-' . $columns . '">' . ob_get_clean() . '</div>';
}

public static function sale_products( $atts ) {

function scheduled_sale_products( $atts ) {

add_shortcode( 'scheduled_sale_products', 'scheduled_sale_products' );

$product_ids_on_sale = wc_get_product_ids_on_sale();

$product_ids_raw = $wpdb->get_results(
"SELECT posts.ID, posts.post_parent
FROM `$wpdb->posts` posts
INNER JOIN `$wpdb->postmeta` ON (posts.ID = wp_postmeta.post_id)
INNER JOIN `$wpdb->postmeta` AS mt1 ON (posts.ID = mt1.post_id)
WHERE
    posts.post_status = 'publish'
    AND  (mt1.meta_key = '_sale_price_dates_to' AND mt1.meta_value >= ".time().") 
    GROUP BY posts.ID 
    ORDER BY posts.post_title ASC LIMIT 0,12");

$product_ids_on_sale = array();

foreach ( $product_ids_raw as $product_raw ) 
{
    if(!empty($product_raw->post_parent))
    {
        $product_ids_on_sale[] = $product_raw->post_parent;
    }
    else
    {
        $product_ids_on_sale[] = $product_raw->ID;  
    }
}
$product_ids_on_sale = array_unique($product_ids_on_sale);

[scheduled_sale_products per_page="12"]

add_action( 'my_custom_email', array( $this, 'trigger' ), 10, 1 );

do_action( 'my_custom_email', $order_id );

global $woocommerce;
$mailer = WC()->mailer();

function my_scheduled_function() {
    global $woocommerce;
    $mailer = WC()->mailer();
    // Lookup $order_id from somewhere
    do_action( 'my_custom_email', $order_id );
}

add_filter( 'bulk_actions-edit-shop_order', 'custom_shop_order_bulk_actions', 20 );

    function custom_shop_order_bulk_actions( $actions ) {
        unset( $actions['mark_processing'] ); // remove action

        $actions['mark_new_status'] = __( 'Change status to new status' );

        return $actions;
    }