pettrushkov

I found solution for my problem (orderby featured product and after them by date)

Use “featured_products” as ‘orderby’ value

// Add custom orderby by featured products and other by date - 'featured_products'
function featured_products_orderby( $orderby, $query ) {
    global $wpdb;

    if ( 'featured_products' == $query->get( 'orderby' ) ) {
        $featured_product_ids = (array) wc_get_featured_product_ids();
        if ( count( $featured_product_ids ) ) {
            $string_of_ids = '(' . implode( ',', $featured_product_ids ) . ')';
            $orderby = "( {$wpdb->posts}.ID IN {$string_of_ids}) " . $query->get( 'order' )." , post_date DESC";
        }
    }

    return $orderby;
}
add_filter( 'posts_orderby', 'featured_products_orderby', 10, 2 );

Hi!

Can u share example pls? Can’t find anything in google with this filter

Thanks

This code not resolve problem – it was ignored.. I tried something similar earlier. https://take.ms/NFeo3
Adding line breaks to tooltip also failed https://take.ms/SA4ER