Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008
    Posts
    3
    Plugin Contributions
    0

    Default [Not a bug] Admin orders product name search is missing wildcard

    OK, maybe not a bug as such, but probably not the intent ?

    Seen in 1.3.8 and still in 1.3.9d.

    ./admin/orders.php

    line 716 (in 1.3.9d):

    $search = " and (op.products_model like '%" . $keywords . "%' or op.products_name like '" . $keywords . "%')";
    does not allow a search match in all parts of product name as leading wildcard is missing on keyword. Can be solved by adding in % as:

    $search = " and (op.products_model like '%" . $keywords . "%' or op.products_name like '%" . $keywords . "%')";
    Note: For 1.3.8, then you need to of applied bugfix http://www.zen-cart.com/forum/showpo...7&postcount=18 for the 'Search by Product Name' field to work.


  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,373
    Plugin Contributions
    6

    Default Re: Admin orders product name search is missing wildcard

    That was by design not a bug so that Product Name searches had to begin with the search word ...

    Many sites will find the first word more useful on a search of a Product than searching within a Product Name ...

    If you need for your specific site this change would do as you have stated ...

    As to making it part of the default setting in Zen Cart, at this time it would really need to be considered as previous checks on large database tables have found that to be more of a bother than a help ...

    Thanks for the suggesting!
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

Similar Threads

  1. Replies: 3
    Last Post: 27 Apr 2015, 03:47 AM
  2. Search box in Admin not searching in product name?
    By rudyh01 in forum Basic Configuration
    Replies: 6
    Last Post: 13 Dec 2011, 03:47 PM
  3. Search box not searching capitalized product name/model number
    By saitomedia in forum General Questions
    Replies: 2
    Last Post: 10 Feb 2010, 08:01 AM
  4. Replies: 11
    Last Post: 9 Sep 2008, 03:21 AM
  5. [Not a bug] Missing product type constants
    By langer in forum Bug Reports
    Replies: 1
    Last Post: 7 Dec 2006, 10:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR