WooCommerce价格排序功能（升降序）在混合产品场景下的问题咨询

Hey there, I’ve dealt with this exact frustration before—WooCommerce’s default price sorting is way too rigid when you have a mix of simple and variable products. As you noted:

• When sorting from high to low, it grabs the absolute highest variant price for variable products, ignoring the default variant you set via Default Form Values.
• When sorting from low to high, it does the opposite, using the lowest possible variant price instead of your default displayed price.

This creates a disconnect between what customers see (your default variant price) and how products are ordered. Here’s a solid fix:

Custom Code to Override Sorting Logic #

Add this code to your theme’s functions.php file, or use a code snippets plugin (safer, since theme updates won’t wipe it):

add_filter('woocommerce_get_catalog_ordering_args', 'custom_sort_by_default_variant_price');
function custom_sort_by_default_variant_price($args) {
    global $wpdb;

    // Only tweak sorting if price order is selected
    if (isset($_GET['orderby']) && in_array($_GET['orderby'], ['price', 'price-desc'])) {
        $sort_order = ($_GET['orderby'] === 'price-desc') ? 'DESC' : 'ASC';

        // Join postmeta tables to pull in default variant data
        $args['join'] .= " LEFT JOIN {$wpdb->postmeta} AS default_attr ON {$wpdb->posts}.ID = default_attr.post_id AND default_attr.meta_key = '_default_attributes'";
        $args['join'] .= " LEFT JOIN {$wpdb->postmeta} AS variant_price ON (
            CASE 
                WHEN {$wpdb->posts}.post_type = 'product_variation' THEN {$wpdb->posts}.ID
                WHEN {$wpdb->posts}.post_type = 'product' AND default_attr.meta_value != '' THEN (
                    SELECT post_id FROM {$wpdb->postmeta}
                    WHERE meta_key = '_attributes' AND post_parent = {$wpdb->posts}.ID
                    AND meta_value = default_attr.meta_value
                    LIMIT 1
                )
                ELSE {$wpdb->posts}.ID
            END
        ) = variant_price.post_id AND variant_price.meta_key = '_price'";

        // Set sorting to use the default variant price (or simple product price)
        $args['orderby'] = "CAST(variant_price.meta_value AS DECIMAL) {$sort_order}, {$wpdb->posts}.ID ASC";
        $args['order'] = ''; // We've already defined the order in the orderby clause
    }

    return $args;
}

What This Does: #

• Hooks into WooCommerce’s catalog ordering filter to rewrite the sorting query.
• For variable products, it fetches the default variant you configured and uses that variant’s price for sorting—matching what customers see on the product page.
• Simple products keep using their regular price, so your catalog stays consistent across all product types.

Quick Tips: #

• Always backup your site before adding custom code—better safe than sorry!
• If you’re not comfortable editing functions.php, use a plugin like Code Snippets to add this code without touching theme files.
• Test the sorting with both simple and variable products to make sure it behaves exactly how you want.

内容的提问来源于stack exchange，提问作者Brett