/PHP/Wp wc php out of stock product to bottom

Wp wc php out of stock product to bottom

add_filter('posts_clauses', 'order_by_stock_status');
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;
}

Source: stackoverflow.com

Similar codes

1 vote264 views1 answer
Changer le logo Admin WordPress
PHP
0 vote244 views1 answer
Laravel select option form add please select option
PHP Laravel
0 vote213 views1 answer
Display data from two dimensional array in vew laravel
PHP
1 vote194 views1 answer
Using a php array in jquery
PHP
0 vote203 views4 answers
Today date to ago for the date in php
PHP
19 votes209 views4 answers
Php get ip address of visitor
PHP
12 votes183 views6 answers
Php array push key value
PHP
4 votes232 views3 answers
Wp+get feature image
PHP
5 votes225 views1 answer
Php 8.1 release date
PHP
2 votes205 views2 answers
How to trim white space array in php
PHP