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 [url removed, login to view] 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 [url removed, login to view] , 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 [url removed, login to view], 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.