Hello,
I would like to search the keyword also in product_sku, so I have modified the file "core/helper.php" from line 40 to line 45:
if($search_category_id != 0)
{
$query .= " LEFT JOIN `#__virtuemart_product_categories` pc ON (p.virtuemart_product_id = pc.virtuemart_product_id) WHERE pc.virtuemart_category_id = ".$search_category_id." AND (p.product_name LIKE '%".$search_name."%' OR [what prefix?].product_sku LIKE '%".$search_name."%' OR p.product_s_desc LIKE '%".$search_name."%' OR p.product_desc LIKE '%".$search_name."%')";
}else{
$query .= " LEFT JOIN `#__virtuemart_products` pd ON (p.virtuemart_product_id = pd.virtuemart_product_id) WHERE pd.published = 1 AND (p.product_name LIKE '%".$search_name."%' OR pd.product_sku LIKE '%".$search_name."%' OR p.product_s_desc LIKE '%".$search_name."%' OR p.product_desc LIKE '%".$search_name."%')";
}
i added "OR pd.product_sku LIKE '%".$search_name."%'" in ELSE section and it works;
but in THEN section i don't know what is the prefix for "product_sku" field, and i wrote "OR [what prefix?].product_sku LIKE '%".$search_name."%' "
Anyone can help me?
thanks!