We have a modified oscommerce shop.
What we want is a search in the admin side of the shop, add a search function to the [login to view URL] page, that looks for all the orders that contain a specific product. The search will be done by vendors_prod_id (similar to model_id)
What will be displayed is all the orders that have that product on it.
I have attached a screen shot of how this would work.
So in image [login to view URL] , number 1 shows where the box would be to search for items ordered . The rest of the screen is how it looks already.
In image [login to view URL], it shows how the results page will look. number 2 shows the product code that was typed in, then number 3 shows all the orders where the product E45N* has been ordered.
Please only proffesional oscommerce experts apply.
Thanks