Order Search by Product Name?

[JangoF]

Hi all,

 

Well I know there is acontribution for searching by customer name in the Order page, but was wondering if it is possible to search by Product Name in the Order page - and thus return all the orders that have the product in them? If so, how could this be done?

[JangoF]

Anyone?

[♥Monika in Germany]

You'd need to custom code a module that loops through your orders and grabs all that have that specific item from your search field. I've done similar mods before ... takes to long to code to be done as a free forum answer though.

[JangoF]

I understand. Well I am just trying to tinker around with the code from the original contribution (http://www.oscommerce.com/community/contributions,5197/) to see if I can get it working somehow.

 

$search_query_pn = null;

if ( isset($_GET['pn']) && $_GET['pn']!="" ){

 

$search_query=$_GET['pn'];

 

$pn_array = explode(' ', ($search_query_pn));

$pn_product = '(op.products_name LIKE \'%' . $pn_array[0] . '%\'';

// more than one search term

for ($i = 1 ; $i < sizeof($pn_array) ; $i++) {

$pn_product .= ' OR op.products_name LIKE \'%' . $pn_array[$i] . '%\'';

}

$pn_product .= ')';

$search_query_pn = ' AND (' . $pn_product . ')';

 

}

 

Obviously this won't work as there is no query in orders.php that fetches products_name from orders_orders_products.

[♥Monika in Germany]

yup, that what I meant, you'll need to write it all (takes time, LOL - did I mention that?)