Search Results for products with part of SKU - Journal 3.0.3.2

Post by alexanderaldev » Fri Nov 22, 2019 1:58 am

Hello there
I am using opencart 3.0.3.2 with Journal 3 and I have problem with seach products when i use SKU number.
There is a product in Catalog with SKU with number 50131001B - when i search it everything is fine, but when i try to search with only part of that SKU for example 50131001 or 50131 search results show me that there is no products with this matching criteria. Is there anyway to change that "exact match" with logic to search even i've entered a part of it.
Thanks in advanced to everyone

https://aldev.bg/

Post by letxobnav » Fri Nov 22, 2019 2:59 am

$sql .= " OR LCASE(p.sku) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";

$sql .= " OR LCASE(p.sku) LIKE '%" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "%'";

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by alexanderaldev » Fri Nov 22, 2019 4:47 pm

https://aldev.bg/

Post by JNeuhoff » Fri Nov 22, 2019 5:53 pm

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

Post by letxobnav » Fri Nov 22, 2019 7:18 pm

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by alexanderaldev » Sat Nov 23, 2019 7:17 pm

Yeah Journal obviously use own logic for search because that functuality i'm looking for is already code in auto-suggest
I've disabled and also change both methods in catalog/product.php with

Code: Select all

$sql .= " OR LCASE(p.sku) LIKE '%" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "%'";

Delete all cache and refresh modifications
But still product doesn't appear in search without B in the sku

Ok .. i change the SKU to Model .. trying to do the same with the model with like '%" method but still nothing

https://aldev.bg/

Post by xxvirusxx » Sat Nov 23, 2019 9:10 pm

$sql .= " OR LCASE(p.sku) LIKE '%" . str_replace(' ', "%' OR LCASE (p.sku) LIKE '%", $data['filter_name']) . "%'";

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

Post by letxobnav » Sat Nov 23, 2019 9:14 pm

error_log($sql);

$this->log->write($sql);

$query = $this->db->query($sql);

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by aitechbg » Wed Feb 17, 2021 6:53 pm

Web Development, Consulting and SEO for Europe by itech.bg

Post by straightlight » Wed Feb 17, 2021 9:25 pm

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester