Sorting Products: Display Sale Items at the Top & Sort by Price

Hello,

Navigate to Appearance > Customize > WooCommerce > Product Catalog > set the default product sorting.
https://ibb.co/CK9TQdd

Best Regards,

Hello,

There is no option available for this in the theme settings. This requires customization, which is beyond our support policy.

I have searched for a possible solution and found a custom function that you can add to your functions.php file. I have tested this code on our test site, and it is working fine.

If the provided code does not work as expected, unfortunately, we are unable to modify it further.

Add this to your theme’s functions.php file of the theme.

add_action( 'woocommerce_product_query', 'custom_sort_sale_first_then_price', 10, 2 );
function custom_sort_sale_first_then_price( $q, $query ) {
    if ( is_admin() || ! $q->is_main_query() || ! is_shop() && ! is_product_category() ) {
        return;
    }

    // Get meta queries
    $meta_query = $q->get( 'meta_query' );

    // Set custom sorting
    $q->set( 'meta_query', $meta_query );
    $q->set( 'orderby', array(
        'sale_items' => 'DESC',
        'price' => 'ASC'
    ));

    $q->set( 'meta_key', '_price' );

    // Join sale price data
    add_filter( 'posts_clauses', 'custom_sale_products_first_clauses', 20, 2 );
}

function custom_sale_products_first_clauses( $clauses, $query ) {
    global $wpdb;

    if ( is_shop() || is_product_category() ) {
        $clauses['join'] .= " LEFT JOIN {$wpdb->postmeta} AS sale_price_meta ON {$wpdb->posts}.ID = sale_price_meta.post_id AND sale_price_meta.meta_key = '_sale_price' ";
        $clauses['orderby'] = " (sale_price_meta.meta_value + 0) > 0 DESC, {$wpdb->postmeta}.meta_value + 0 ASC ";
    }

    return $clauses;
}

This code will modify the main WooCommerce shop query to:
Show sale products first,
Then, sort everything by ascending price.

Hope this Helps!

Best Regards,