/PHP/Display out of stock products last (even after sort) - Woocommerce

Display out of stock products last (even after sort) - Woocommerce

add_filter('posts_clauses', 'order_by_stock_status',999);
function order_by_stock_status($posts_clauses) {
    global $wpdb;
    // only change query on WooCommerce loops
    if (is_woocommerce() && (is_shop() || is_product_category() || is_product_tag() || is_product_taxonomy())) {
        $posts_clauses['join'] .= " INNER JOIN $wpdb->postmeta istockstatus ON ($wpdb->posts.ID = istockstatus.post_id) ";
        $posts_clauses['orderby'] = " istockstatus.meta_value ASC, " . $posts_clauses['orderby'];
        $posts_clauses['where'] = " AND istockstatus.meta_key = '_stock_status' AND istockstatus.meta_value <> '' " . $posts_clauses['where'];
    }
    return $posts_clauses;
}

Similar codes

0 vote101 views3 answers
Script @php artisan package:discover --ansi handling the post-autoload-dump event returned with error code 1
PHP
7 votes102 views1 answer
Laravel not in query
PHP Laravel
11 votes202 views1 answer
Wp error log config
PHP Wordpress
0 vote102 views1 answer
Vivo.sx api get file informations php
PHP
1 vote54 views1 answer
Twig replace char in string
PHP
3 votes117 views2 answers
Remove admin bar wordpress front end
PHP Wordpress
2 votes94 views1 answer
Php unset reference
PHP
0 vote86 views3 answers
Caculator
PHP
40 votes90 views6 answers
Laravel drop column
PHP
0 vote115 views1 answer
Everything inside a pair
PHP