wp wc php out of stock product to bottom

Solutions on MaxInterview for wp wc php out of stock product to bottom by the best coders in the world

Search
showing results for - "wp wc php out of stock product to bottom"
Arthur
10 May 2020
1add_filter('posts_clauses', 'order_by_stock_status');
2function order_by_stock_status($posts_clauses) {
3    global $wpdb;
4    // only change query on WooCommerce loops
5    if (is_woocommerce() && (is_shop() || is_product_category() || is_product_tag() || is_product_taxonomy())) {
6        $posts_clauses['join'] .= " INNER JOIN $wpdb->postmeta istockstatus ON ($wpdb->posts.ID = istockstatus.post_id) ";
7        $posts_clauses['orderby'] = " istockstatus.meta_value ASC, " . $posts_clauses['orderby'];
8        $posts_clauses['where'] = " AND istockstatus.meta_key = '_stock_status' AND istockstatus.meta_value <> '' " . $posts_clauses['where'];
9    }
10    return $posts_clauses;
11}
12
source
similar questions
wc php if is product category pagehow to add product to wordpress programmaticallyhow to add wc 28 29 function in my custom pageget stock product woocommerce by idwp wc php remove product from cart if amount is 0woocommerce add text after price to specific product or productswc productwc php free shipping functionwp wc php if not is single product pageget product price wordpress
queries leading to this page
wp wc out of stock products to bottomwp wc php out of stock product to bottom