[Resolved] Inconsistent sorting between Chinese and English when choosing to sort by price

function custom_woocommerce_meta_query( $q ) {
    // Only run on main WooCommerce shop or product category/taxonomy pages
    if ( ! is_admin() && is_woocommerce() && is_main_query() && isset($_GET['orderby']) ) {
        // Get current meta query
        $meta_query = $q->get( 'meta_query' );

        // Add your custom meta query (example: show only products with custom_field = 'yes')
        $meta_query[] = array(
            'meta_key'     => '_sku',
            'meta_value' => 'ASC',
        );

        // Set the modified meta query
        $q->set( 'meta_query', $meta_query );
    }
}
add_action( 'woocommerce_product_query', 'custom_woocommerce_meta_query' );

//The following code is used when no sorting option is selected — it defaults to sorting by date and then SKU.
add_action('pre_get_posts', 'custom_modify_shop_query', PHP_INT_MAX); 
function custom_modify_shop_query($query) {
 
    // Only intervene on front-end shop or product category/tag archives
    if ( !isset($_GET['orderby']) && !is_admin() && $query->is_main_query() && ( is_shop() || is_product_category() || is_product_tag() ) ) {
    
        // Set meta_key so SKU ordering works
        $query->set('meta_key', '_sku');

        // Set orderby to array: first by date, then by SKU
        $query->set('orderby', array(
            'date'       => 'DESC',
            'meta_value' => 'ASC',
        ));
    }
}

//Use the below snippet when sorting by price, so that SKU is used as the secondary sort option:
add_filter('posts_clauses', 'custom_orderby_price_then_sku', 20, 2);
function custom_orderby_price_then_sku($clauses, $query) {
    if (!is_admin() && $query->is_main_query() && is_woocommerce() && isset($_GET['orderby'])) {
        $orderby = $_GET['orderby'];

        // Determine price column and sort direction
        if ($orderby === 'price') {
            $price_column = 'wc_product_meta_lookup.min_price';
            $price_direction = 'ASC';
        } elseif ($orderby === 'price-desc') {
            $price_column = 'wc_product_meta_lookup.max_price';
            $price_direction = 'DESC';
        } else {
            return $clauses; // Not price-based ordering, skip
        }

        // Use SKU from meta lookup (already joined by WC)
        $clauses['orderby'] = "
            {$price_column} {$price_direction},
            wc_product_meta_lookup.sku ASC
        ";
    }

    return $clauses;
}

add_filter('posts_clauses', 'custom_orderby_with_secondary_sku', 20, 2);
function custom_orderby_with_secondary_sku($clauses, $query) {
    if (!is_admin() && $query->is_main_query() && is_woocommerce() && isset($_GET['orderby'])) {
        $orderby = $_GET['orderby'];

        // Define primary column and direction based on ordering
        switch ($orderby) {
            case 'price':
                $primary_column = 'wc_product_meta_lookup.min_price';
                $primary_direction = 'ASC';
                break;
            case 'price-desc':
                $primary_column = 'wc_product_meta_lookup.max_price';
                $primary_direction = 'DESC';
                break;
            case 'popularity':
                $primary_column = 'wc_product_meta_lookup.total_sales';
                $primary_direction = 'DESC';
                break;
            default:
                return $clauses; // Not a target orderby value, leave alone
        }

        // Set ORDER BY with SKU as secondary sort
        $clauses['orderby'] = "
            {$primary_column} {$primary_direction},
            wc_product_meta_lookup.sku ASC
        ";
    }

    return $clauses;
}