Page 1 of 2 12 LastLast
Results 1 to 10 of 17
  1. #1
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    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
    12,401
    Plugin Contributions
    87

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


  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    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
    12,401
    Plugin Contributions
    87

    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
    12,401
    Plugin Contributions
    87

    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
    12,401
    Plugin Contributions
    87

    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.

  9. #9
    Join Date
    Jun 2007
    Location
    Texas, USA
    Posts
    1,400
    Plugin Contributions
    1

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

    lat9 you did great with this mod. There is one thing you can do to make it even greater....

    So my customer looks for "Ford Trucks" .... but because all my trucks are sold as a "truck" instead of multiples they do not show up in search. If you could check the keyword and if it ends in "s" or "es" ... if you could strip those last 1 or 2 characters and run it through the "like" it would make this so awesome.

  10. #10
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

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

    Quote Originally Posted by shrimp-gumbo-mmmhhh View Post
    lat9 you did great with this mod. There is one thing you can do to make it even greater....

    So my customer looks for "Ford Trucks" .... but because all my trucks are sold as a "truck" instead of multiples they do not show up in search. If you could check the keyword and if it ends in "s" or "es" ... if you could strip those last 1 or 2 characters and run it through the "like" it would make this so awesome.
    That's, unfortunately, outside the scope of this plugin. There's also the underlying issue that different languages handle plural indications differently.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 19
    Last Post: 23 Jan 2023, 08:04 AM
  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