meta_key变更及自定义过滤器切换致菜单消失求助（附链接及代码）

Hey there! Let's dig into this menu disappearance issue you're facing when switching to the "Price" filter (which modifies the meta_key). From what you described—menu shows fine on "Latest" (no meta_key change) but vanishes on "Price"—here are the most likely culprits and fixes to try:

1. Missing Meta Key Data Filtering Out All Items #

When you switch to price sorting, your query probably specifies a meta_key for price, but if some menu items don't have this meta field saved, they'll get filtered out entirely. If your query doesn't account for items missing the price meta key, you'll end up with an empty menu.

Fix: Update your meta_query to include items both with and without the price key:

$args = array(
    'post_type' => 'menu_item',
    'orderby' => 'meta_value_num',
    'meta_key' => 'your_price_meta_key', // Replace with your actual price key
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'key' => 'your_price_meta_key',
            'compare' => 'EXISTS'
        ),
        array(
            'key' => 'your_price_meta_key',
            'compare' => 'NOT EXISTS'
        )
    ),
    'order' => 'ASC'
);

This ensures items without price data still show up (they'll typically sort to the top/bottom depending on your order setting).

2. Typos or Mismatched meta_key Values #

Double-check that the meta_key you're using in the price sort query exactly matches the key stored in your database. A tiny typo (like menu_price vs menu_prices) will make the query return zero results.

Quick Check: Use a database tool (like phpMyAdmin) to verify the exact meta key name for your menu prices, then cross-reference it with your code.

3. Overwritten Query Parameters in Your Filter Hook #

If you're using a hook like pre_get_posts to modify the menu query, you might be accidentally overwriting critical parameters (like post_type or posts_per_page) when switching to price sort.

Example of a Safe Filter Hook:

add_action('pre_get_posts', 'custom_menu_sort_handler');
function custom_menu_sort_handler($query) {
    // Only target the front-end menu archive query
    if (!is_admin() && $query->is_main_query() && is_post_type_archive('menu_item')) {
        $sort_option = $_GET['sort'] ?? 'latest';
        
        if ($sort_option === 'price') {
            $query->set('orderby', 'meta_value_num');
            $query->set('meta_key', 'your_price_meta_key');
            $query->set('order', 'ASC');
        } else {
            // Revert to default "latest" sort
            $query->set('orderby', 'date');
            $query->set('order', 'DESC');
        }
    }
}

This ensures you only modify the necessary sort parameters and don't break the core query.

4. Debug the Actual SQL Query #

To see exactly what's going wrong, log the SQL query when switching filters. This will show you if the price sort query is excluding all items.

Add This Debug Code:

add_action('posts_request', 'log_menu_query');
function log_menu_query($sql) {
    // Only log the menu archive query
    if (is_post_type_archive('menu_item')) {
        error_log('Menu Sort Query: ' . $sql);
    }
    return $sql;
}

Check your server's error log to compare the SQL for "Latest" vs "Price" sorts. Look for differences in WHERE clauses that might be filtering out all results.

Start with these steps—odds are the issue is related to missing meta key handling or a typo in your query parameters. Let me know if you need help narrowing it down further!

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