How to show recent products first and “out of stock in last” in query?

patrick

I use WooCommerce and would like to show the products "out of stock" last on the archive page in the query. How do I get to do that? We are currently making the first show of the newest product with this code

add_action( 'pre_get_posts', 'mik_exclude_category' );
function mik_exclude_category( $query ) {
    if ( $query->is_main_query() ) {
        $query->set( 'orderby', 'date' );
        $query->set( 'order', 'DESC' );
    }
}

We need to do both. newest products first, "out of stock" products last no matter how new they are.

anderson

For two stocks status that is outofstockand instock, it's simple to sort with pre_get_posts

add_action( 'pre_get_posts', function ( $q ) {
    if (   !is_admin()                 // Target only front end 
         && $q->is_main_query()        // Only target the main query
         && $q->is_post_type_archive() // Change to suite your needs
    ) {
        $q->set( 'meta_key', '_stock_status' );
        $q->set( 'orderby',  'meta_value'    );
        $q->set( 'order',    'ASC'           );
    }
}, PHP_INT_MAX );