Question 422066 in Wordpress Question posted in
The official Wordpress documentation can be found here.

WordPress – Add search functionality within WooCommerce My Account > Orders page

I’m trying to add a search bar to the WooCommerce Orders page on the frontend customer account dashboard for specific user roles (don’t want showing for all customers).

I feel like I’m close, but the below code is just not working. I only need to search by order number. This code produces a "No order has been made yet." result despite there being many orders in my test account.

I also notice that when conducting the search, the URL doesn’t change like I’d normally expect it to so I’m wondering if that’s a tip-off to what’s wrong with the code…?

function add_search_to_orders() {
    $allowed_roles = array('administrator', 'shop_manager');

    $user = wp_get_current_user();
    $user_roles = (array) $user->roles;

    if (array_intersect($allowed_roles, $user_roles)) {
        echo '<form method="post" id="orders-search-form">
                <input type="text" name="search_orders" placeholder="Search by order number..." />
                <input type="hidden" name="order_status" value="wc-completed" />
                <button type="submit">Search</button>
              </form>';
    }
}
add_action('woocommerce_before_account_orders', 'add_search_to_orders');

function search_all_orders_by_number($args) {
    if (isset($_POST['search_orders']) && !empty($_POST['search_orders'])) {
        $search_term = sanitize_text_field($_POST['search_orders']);
        $args['meta_query'] = array(
            array(
                'key'     => '_order_number',
                'value'   => $search_term,
                'compare' => 'LIKE'
            )
        );
    }
    return $args;
}
add_filter('woocommerce_my_account_my_orders_query', 'search_all_orders_by_number');
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    For those that stumble on this and are interested, here is the final code I got to work successfully with a WC HPOS store. Worked perfectly and I added some other mods to have a reset ability.

    // Add search field to the top of WooCommerce My Account > Orders list
function add_search_to_orders() {
    $allowed_roles = array('administrator', 'shop_manager'); // Add or remove any other user roles here

    $user = wp_get_current_user();
    $user_roles = (array) $user->roles;

    if (array_intersect($allowed_roles, $user_roles)) {
        $show_clear_link = isset($_GET['search_orders']) && !empty($_GET['search_orders']);
        echo '<form method="get" id="orders-search-form">
                <input type="text" name="search_orders" placeholder="Search by order number..." value="' . (isset($_GET['search_orders']) ? esc_attr($_GET['search_orders']) : '') . '" />
                <button type="submit">Search</button>';
        if ($show_clear_link) {
            echo '<a href="' . esc_url(remove_query_arg('search_orders')) . '">Reset Search</a>';
        }
        echo '</form>';
    }
}
add_action('woocommerce_before_account_orders', 'add_search_to_orders');

// Make the search field function with a WooCommerce HPOS shop
function search_all_orders_by_number($query) {
    if (isset($_GET['search_orders']) && !empty($_GET['search_orders'])) {
        $search_term = sanitize_text_field($_GET['search_orders']);
        
        $query['post__in'] = array($search_term);
    }
    return $query;
}
add_filter('woocommerce_my_account_my_orders_query', 'search_all_orders_by_number');

  2. 0

    Your provided code works just fine for "_order_number" meta_key, but since High Performance Order Storage is now enabled by default and uses a WooCommerce custom database table, all your order numbers need to be saved using WC_Data add_meta_data() or update_meta_data() methods, instead of using WordPress post meta functions.

    See: Order custom field added via checkout is lost after WooCommerce HPOS sync

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search