Product search in admin by part of the name

To make the product show the Canon EOF product for example when you type EOF change the lines in opencart 1.5 in admin/model/catalog/product.php 334-340 to: I will put this as a request in the apropriate area later

Also i added a way to make quantity searchs for > and < like >900 etc:
Changed line 346 to:

Excellent.... the first part of your solution was what I was searching for... really liked the wildcard feature in 1.4.9.3 and bummed that it was missing in 1.5.0.5 ... your solution worked perfect..

Also, love the additional "less than or greater" search for quantity... that was the icing on the cake... its these small features that really makes a difference... two thumbs up! thank you

ps - just curious... change that work for price too? or is price handled differently? Too lazy right now...

You didn't put the code to replace and I know that some of my admin files have been modified by my theme so didn't try this method. Used this mod instead (thought I'd share as I found this thread first so others might too)

http://www.opencart.com/index.php?route ... _license=0

fabioDexus wrote:Also i added a way to make quantity searchs for > and < like >900 etc:
Changed line 346 to:

Code: Select all

	if (isset($data['filter_quantity']) && !is_null($data['filter_quantity'])) {
				$operator='=';
				if(strpos ($data['filter_quantity'],'<')!==false || strpos ($data['filter_quantity'],'<')!==false){
					$operator='<';
				}
				else if(strpos ($data['filter_quantity'],'>')!==false || strpos ($data['filter_quantity'],'>')!==false){
					$operator='>';
				}
				$quantity=trim(str_replace(array('<','>','<','>'), '', $data['filter_quantity']));
				$sql .= ' AND p.quantity '.$operator.'\'' .$this->db->escape( $quantity). '\'';
			}

work for me on 1.5.5.1

To search by a part of the product name in Opencart 2+ you need to change lines 251 - 260 like so:
In a nutshell, you're just adding a % sign to the start of the search term as well as at the end of it.

I would also add and (as can be seen in the first post).

Otherwise the search item has to match exactly the term.

Hello to all,
I use version 1.5.6.4,with a theme installed and this code works for me. Also, after fixing the search problem, I had a problem with the product count and shown at the end of the page: "Showing 0 to 0 of 0 (0 Pages)". If anyone else have the same problem, I show you what I did to fix it.

First I show you what I changed to fix the product search:
The only I did was to add % in the line 345: "AND pd.name LIKE '%" and in line 349 " AND p.model LIKE '%". All the code in lines 344-350 is:
if (!empty($data['filter_name'])) {
$sql .= " AND pd.name LIKE '%" . $this->db->escape($data['filter_name']) . "%'";
}

if (!empty($data['filter_model'])) {
$sql .= " AND p.model LIKE '%" . $this->db->escape($data['filter_model']) . "%'";
}

Second, I show you what I did to fix the procuct count at the end of admin page:

I changed the code in function:"public function getProfiles($product_id)" in the lines 600 to 607. Add % in line 602(" AND pd.name LIKE '%") and in line 606(" AND p.model LIKE '%"). The hole code is:

public function getProfiles($product_id) {
return $this->db->query("SELECT * FROM `" . DB_PREFIX . "product_profile` WHERE product_id = " . (int)$product_id)->rows;
}

public function getTotalProducts($data = array()) {
$sql = "SELECT COUNT(DISTINCT p.product_id) AS total FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id)";

if (!empty($data['filter_category_id'])) {
$sql .= " LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id)";
}

$sql .= " WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "'";

if (!empty($data['filter_name'])) {
$sql .= " AND pd.name LIKE '%" . $this->db->escape($data['filter_name']) . "%'";
}

if (!empty($data['filter_model'])) {
$sql .= " AND p.model LIKE '%" . $this->db->escape($data['filter_model']) . "%'";
}

I hope to help anyone has the same problem.

smarg wrote: ↑

Wed Apr 13, 2016 2:36 pm

Also, after fixing the search problem, I had a problem with the product count and shown at the end of the page: "Showing 0 to 0 of 0 (0 Pages)". If anyone else have the same problem, I show you what I did to fix it.

Thanks!