Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,858
    Plugin Contributions
    70

    Default Search: Prioritize Matching Names [Support Thread]

    As this thread highlighted, equal weight is given to all products matching the search keywords ... whether the match was found in the product's name, model-number, manufacturers name, meta tags or (if requested) its description. As @lloyd_borrett indicated in that thread, that can mean that products whose names match those keywords might wind up "below the fold" -- where they're probably the most relevant!

    This simple plugin updates the SQL query used on the "Advanced Search Results" page, giving a higher priority to those products whose names match the keywords.

    Note: Since this plugin makes use of the auto-loaded observers feature introduced in Zen Cart v1.5.3, the plugin will operate properly only on Zen Cart versions v1.5.3 and later.

    I'll be submitting to the Plugins shortly and will update this thread with the download link once I've got it.

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,858
    Plugin Contributions
    70

    Default Re: Search: Prioritize Matching Names [Support Thread]


  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,858
    Plugin Contributions
    70

    Default Re: Search: Prioritize Matching Names [Support Thread]

    The plugin is now available for download!

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,858
    Plugin Contributions
    70

    Default Re: Search: Prioritize Matching Names [Support Thread]

    This plugin is compatible with Zen Cart versions v1.5.3 to v1.5.5.

  5. #5
    Join Date
    Nov 2007
    Posts
    72
    Plugin Contributions
    0

    Default Re: Search: Prioritize Matching Names [Support Thread]

    Do you have any suggestions for how to make this plug in work with the dynamic filter mod? https://www.zen-cart.com/downloads.php?do=file&id=1361

    It works perfectly, but it breaks the dynamic filter.

  6. #6
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,858
    Plugin Contributions
    70

    Default Re: Search: Prioritize Matching Names [Support Thread]

    In what way does it "break" the dynamic filter?

  7. #7
    Join Date
    Nov 2007
    Posts
    72
    Plugin Contributions
    0

    Default Re: Search: Prioritize Matching Names [Support Thread]

    Here is the error from the log ...

    PHP Fatal error: 1054:Unknown column 'in_name' in 'order clause' :: SELECT p.products_id, p.products_price_sorter, p.master_categories_id, p.manufacturers_id FROM products p LEFT JOIN manufacturers m USING(manufacturers_id) LEFT JOIN products_description pd on p.products_id = pd.products_id JOIN products_to_categories p2c on p.products_id = p2c.products_id JOIN categories c on p2c.categories_id = c.categories_id LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1
    AND pd.language_id = 1 AND ((pd.products_name LIKE '%mighty%'
    OR p.products_model
    LIKE '%mighty%'
    OR m.manufacturers_name
    LIKE '%mighty%' OR (mtpd.metatags_keywords
    LIKE '%mighty%'
    AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
    LIKE '%mighty%'
    AND mtpd.metatags_description !='') OR pd.products_description
    LIKE '%mighty%') )) GROUP BY p.products_id order by in_name DESC, p.products_sort_order, pd.products_name ==> (as called by) /home/account/public_html/includes/templates/templatename/sideboxes/tpl_dynamic_filter.php on line 63 <== in /home/account/public_html/includes/classes/db/mysql/query_factory.php on line 167

  8. #8
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,858
    Plugin Contributions
    70

    Default Re: Search: Prioritize Matching Names [Support Thread]

    That's because the Dynamic Filter (whatever version you're running) is stripping out the name-select clause that is added by this plugin.

    I suggest that you take the issue to the Dynamic Filter's support thread (https://www.zen-cart.com/showthread....Support-Thread) for resolution.

 

 

Similar Threads

  1. Hebrew Support - new release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 10
    Last Post: 17 May 2019, 09:18 PM
  2. v154 Multi Language Country Names Support Thread
    By Design75 in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 18 Mar 2017, 08:17 PM
  3. v151 Codetrio Sphinx Search Version 1.0 Support Thread
    By imranulh in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 16 Jul 2014, 01:24 AM
  4. Search Helper Support Thread
    By swguy in forum All Other Contributions/Addons
    Replies: 18
    Last Post: 9 Nov 2011, 11:14 AM
  5. Windows Live Product Search Contribution Support Thread
    By numinix in forum All Other Contributions/Addons
    Replies: 209
    Last Post: 3 Jul 2009, 08:23 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