WordPress产品排序求助：按可用性分组+价格升序排列

Got it, let's fix this sorting issue for your products. Here's the exact WP_Query argument setup you need to first show available (Y) products sorted by price ascending, then unavailable (N) products also sorted by price ascending:

$args = array(
    'post_type' => 'products',
    'meta_query' => array(
        // Named clauses for precise sorting control
        'available_clause' => array(
            'key' => 'available',
            'value' => array('Y', 'N'),
            'compare' => 'IN'
        ),
        'price_clause' => array(
            'key' => 'price',
            'type' => 'NUMERIC' // Critical for proper numeric price sorting (avoids string-based errors)
        )
    ),
    'orderby' => array(
        // First sort by availability: Y comes before N
        'available_clause' => 'DESC',
        // Then sort within each availability group by price (low to high)
        'price_clause' => 'ASC'
    )
);

// Execute the query
$products_query = new WP_Query($args);

Breakdown of How This Works: #

• Meta Query Clauses: We define two named clauses (available_clause and price_clause) to target your custom fields. The available_clause ensures we only include products marked Y/N, while price_clause tells WordPress to treat price as a numeric value—this prevents weird sorting where "20" would come after "100" due to string comparison logic.
• Dual Sort Order: The orderby array is the key to your desired behavior. We first sort by available_clause in descending order: since "Y" has a higher ASCII value than "N", this pushes all available products to the top. Then, within each availability group, we sort by price_clause in ascending order to get the low-to-high price sorting you want.

If you have products missing either the available or price meta fields and want to exclude them entirely, this setup already handles that. If you need to include those products, you can adjust the compare values to EXISTS, but that's probably not necessary for your use case.

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