I have a store where the owner creates orders for hi staff uniforms, and would like to be able to run a search in admin to say perhaps,
"Joe Bloggs" as the staff member to see all the products given to Joe Bloggs over time.
Any ideas? I initially thought about adding a text field on the product detail page and adding the name to that, but it wont search that.
The idea is that the order manager can see if "joe bloggs" has asked for another pair of safety boots, then he can check and say "hang on you only had a pair 2 weeks ago" etc etc.