{"id":55147,"date":"2021-10-03T21:11:42","date_gmt":"2021-10-03T19:11:42","guid":{"rendered":"https:\/\/samuelchopard.ch\/wiki\/?p=55147"},"modified":"2022-01-11T20:29:30","modified_gmt":"2022-01-11T19:29:30","slug":"show-out-of-stock-products-at-end-of-product-list","status":"publish","type":"post","link":"https:\/\/samuelchopard.ch\/wiki\/library\/show-out-of-stock-products-at-end-of-product-list\/","title":{"rendered":"Show out of stock products at end of product list"},"content":{"rendered":"<p><!--more--><br \/>\nPaste the following code in functions.php:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"php\">\/* Show out of stock products at end of product list *\/\r\nadd_filter('posts_clauses', 'order_by_stock_status');\r\nfunction order_by_stock_status($posts_clauses) {\r\n    global $wpdb;\r\n    \/\/ only change query on WooCommerce loops\r\n    if (is_woocommerce() &amp;&amp; (is_shop() || is_product_category() || is_product_tag() || is_product_taxonomy())) {\r\n        $posts_clauses['join'] .= \" INNER JOIN $wpdb-&gt;postmeta istockstatus ON ($wpdb-&gt;posts.ID = istockstatus.post_id) \";\r\n        $posts_clauses['orderby'] = \" istockstatus.meta_value ASC, \" . $posts_clauses['orderby'];\r\n        $posts_clauses['where'] = \" AND istockstatus.meta_key = '_stock_status' AND istockstatus.meta_value &lt;&gt; '' \" . $posts_clauses['where'];\r\n    }\r\n    return $posts_clauses;\r\n}\r\n<\/pre>\n<p>Source: <a target=\"_blank\" href=\"https:\/\/stackoverflow.com\/questions\/25113581\/show-out-of-stock-products-at-the-end-in-woocommerce\">https:\/\/stackoverflow.com\/questions\/25113581\/show-out-of-stock-products-at-the-end-in-woocommerce<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"Paste the following code in functions.php: \/* Show out of stock products at end of product list *\/ add_filter('posts_clauses', 'order_by_stock_status'); [...]","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[397,211,234,327],"class_list":["post-55147","post","type-post","status-publish","format-standard","hentry","category-woocommerce","tag-outofstock","tag-php","tag-products","tag-woocommerce"],"_links":{"self":[{"href":"https:\/\/samuelchopard.ch\/wiki\/wp-json\/wp\/v2\/posts\/55147","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/samuelchopard.ch\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/samuelchopard.ch\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/samuelchopard.ch\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/samuelchopard.ch\/wiki\/wp-json\/wp\/v2\/comments?post=55147"}],"version-history":[{"count":4,"href":"https:\/\/samuelchopard.ch\/wiki\/wp-json\/wp\/v2\/posts\/55147\/revisions"}],"predecessor-version":[{"id":55156,"href":"https:\/\/samuelchopard.ch\/wiki\/wp-json\/wp\/v2\/posts\/55147\/revisions\/55156"}],"wp:attachment":[{"href":"https:\/\/samuelchopard.ch\/wiki\/wp-json\/wp\/v2\/media?parent=55147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/samuelchopard.ch\/wiki\/wp-json\/wp\/v2\/categories?post=55147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/samuelchopard.ch\/wiki\/wp-json\/wp\/v2\/tags?post=55147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}