Contributions
Search for email address, etc in Orders v1.0
Do you have customers who call in with questions about their order but do not have their Order ID?
Do you have enough customers to realize the Customer search on the Admin page is a resource hog that takes forever and affects performance for the entire site?
Do you wish you could look up order information using the customer's email address, name or another field from the Orders table?
This is the contrib for you. Three easy changes. Two of them in the same file.
FYI - You can add more Order fields to search by adding additional 'or' clauses in the 'where' clause of the select statement in step 3. For instance, we have a custom field in the Orders table called po_number. We store eBay item number in it because we get lots of calls from customer that only have that number available to them. We can look it up because I added an 'or' clause that references that field.
Most of the credit needs to go to enigma1. I just modified some of his code that I found in a thread on a support forum.
 Search for email address, etc in Orders v1.0 |
23 Dec 2011 |
As clarification, this contrib will simply add another search box at the top of the Orders view in the Admin panel.
As delivered, you will be able to type in all or part of an email address or customer name, hit enter and it will display the orders that contain the search string in either the customer_name field or the customer_email_address field in the orders table.
Same file. No changes.
 Search for email address, etc in Orders v1.0 |
22 Dec 2011 |
Note: Contributions are used at own risk.
