Order history for customer orders in admin?

Hey all.

We need to be able to view a customers order history in admin. Right now we have a custom module in place where it searches the entire order database for other orders made by that customer.

This is starting to be very time consuming though because we have tens of thousands of orders. so doing a database query of ALL those orders is not the best way to go about this.

Is there any way/module for us to just have the customers previous orders by name in admin in customers -> orders?

Any advice would be great!

admin>customers>orders and search on the customer name. It'll give you a list of all their orders.

Sorry, I didn't explain this well enough. We need a way to add comments for a specific customer, and display ALL the comments we have placed for that customer in each order they place. So if they place a new order, we want to be able to see all the comments from previous orders they have placed on that same page.

That's not something you're going to find readily. You might want to post in Commercial Help Wanted to see if anyone can help you with that.