[UPDATED] Smart Search Pro

Current Version: v303.6 (release notes)

OpenCart Versions: 1.5.0.x - 3.0.3.x

Large Database Demo: http://smartsearch.getclearthinking.com

To Purchase: Visit OpenCartX or opencart.com



Improve the accuracy of the search on your OpenCart site! Smart Search will return the most relevant results by performing a search of the selected product fields in four phases: (1) products with the exact phrase, (2) products with ALL keywords, correctly spelled, (3) products with ALL keywords, possibly misspelled, (4) products with ANY keywords, possibly misspelled. It includes advanced search configuration options, an automatic live search dropdown, recording of search history, and more.

• Includes all the features of the standard Smart Search extension.
• Includes pluralization libraries for English, Dutch, French, Italian, Norwegian (Bokmal), Portuguese, Spanish, and Turkish.
• Smart Search your products in the admin panel as well as the front-end.
• For large databases, choose to enable Fulltext search, which is faster but less accurate than the normal Smart Search algorithm
• Choose to display matching categories, information pages, and/or manufacturers along with your product results.
• Display relevant category/information/manufacturer pages in both the regular search and live search.
• Optionally show a "Did you mean...?" section in the live search, with suggestions based on the keywords being searched.

Updated to v230.1

Release Notes:
- NOTE: This version is fully compatible with OpenCart 2.3.0.x by using the OpenCart 2.3 Extension Compatibility Fix, which is provided for free with the purchase of the extension

- Fixed: "Call to a member function isLogged()" and "getId()" errors when using the Admin Smart Search without being logged into the front-end
- Fixed: "Undefined variable" errors on the search page when no search term is entered
- Fixed: duplicate "Search Information Pages" text for "Search Manufacturers"
- Fixed: line breaks in category/manufacturer/information results were not being properly displayed as spaces
- Fixed: issues with creating Fulltext Indexes when using a database prefix

Release notes for this version of the standard Smart Search can be found here: viewtopic.php?f=124&t=35797&p=642737#p642737

Updated to v230.2

Release Notes:
- Added: multi-lingual settings for Category/Information/Manufacturer headings
- Added: HTML support for Category/Information/Manufacturer headings
- Fixed: Category/Information/Manufacturer headings were not showing correctly on the search results page
- Fixed: "Error: could not load model" in the admin when Fulltext searching is enabled


Release notes for this version of the standard Smart Search can be found here: viewtopic.php?f=124&t=35797&p=673170#p673170

Updated to v300.1

Due to limitations in the opencart.com license system, a new extension was released on opencart.com for OpenCart 3.0 compatibility. However, free updates are still available for anyone that has purchased the extension in July 2016 or after --- just contact Clear Thinking here: http://www.getclearthinking.com/contact

Release Notes:
- NOTE: The extension now uses ocMod instead of vQmod, as required by the OpenCart cloud. If upgrading from a previous version, make sure to delete the old vQmod file, and then click "Refresh" in Extensions > Modifications.

- Added: compatibility with OpenCart 3.0.0.x
- Added: native compatibility with OpenCart 2.3.0.x (You can remove the compatibility fix, or keep using it if you want to)
- Fixed: Phase 2 could get skipped with a single search word if Phase 1 was turned off
- Removed: compatibility with OpenCart 1.5.x and 2.0.0.0 for new versions
- Updated: installation no longer requires the base version be installed first

Updated to v302.1

Release Notes:
- NOTE: Starting with this version, all template files will use the .twig extension. These will still work completely fine on OpenCart 2.x versions, and still use the .tpl-type syntax. However, if you've made edits to the .tpl file, you'll need to port those edits over to the new file.

- Confirmed: compatibility with OpenCart 3.0.2.x
- Updated: instructions.txt file to include directions on how to make the Journal filter module compatible (note: compatibility is never guaranteed)
- Updated: the live search URL is no longer accessible if the live search is turned off

Updated to v302.2

Release Notes:
- Fixed: Filter and Export CSV buttons were not working for the search history
- Fixed: compatibility issues with Ultimate Filters and Filter by Attribute on OpenCart 3.0
- Fixed: admin Smart Search was not properly checking the Status filter

- Updated: <br /> tags are no longer recorded in the search history export
- Updated: admin searches no longer return cached results, since that can show inaccurate information

Updated to v302.3

Release Notes:
- Added: ability to search the "Meta Tag Title" field
- Added: "Testing Mode" and its log are now in their own tab
- Added: support for YMM filter by Xsecrets

- Fixed: "preg_filter(): Unknown modifier" when using / in a search query
- Fixed: "Undefined index: token" when clearing the search history
- Fixed: incorrect highlighting of characters in the &amp; character
- Fixed: "count(): Parameter must be an array or an object" error
- Fixed: "Undefined index: manufacturer_id" error
- Fixed: issue with creating Fulltext Indexes when searching on the Tags field

- Updated: Testing Mode now always ignores the keyword cache

Updated to v303.1

Release Notes:
- Added: compatibility with Journal 3 (though not its filter module; that's going to be too hard to add compatibility for, so if you need a filter module look into Filter by Attribute or Ultimate Filters Module)

- Confirmed: compatibility with OpenCart 3.0.3.x

- Fixed: customer names not being recorded for searches when logged in
- Fixed: category, information, and manufacturer results were not being restricted by store_id correctly
- Fixed: using Fulltext Searching with "meta_title" wasn't working
- Fixed: bugs with admin panel searching when certain filters were applied

- Removed: some old code for OpenCart 1.5 that's no longer needed

- Updated: Testing Mode now has a button to download the log when over 1 MB
- Updated: Testing Mode log is now cleared automatically when over 50 MB

Updated to v303.2

Release Notes:
- NOTE: The 1.5.x version is now feature-comparable with the 2.x/3.x version. The extension uses a vQmod file to accomplish this, which has been tested but might have some issues in the initial version. If you're using OpenCart 1.5.x and have any trouble with it, please contact Clear Thinking.

- Added: full compatibility with OpenCart 1.5.x again
- Added: ability to hide out of stock products in the search results

- Fixed: multi-store searches weren't working correctly in all versions
- Fixed: issues when special characters are in the search phrase when choosing to not include partial matches
- Fixed: bug related to Ultimate Filters when "only relevant values" is used
- Fixed: bug related to "only relevant values" when no results were found
- Fixed: pagination not working on OpenCart 3 versions
- Fixed: "Undefined variable: smartsearch_pro" error when no search parameters are set in the URL
- Fixed: bug related to category/manufacturer image settings in the Smart Search Pro tab resetting themselves if they were set to 0 or blank

- Updated: modified database queries to help with speed in certain situations
- Updated: misspelling searches for categories/manufacturer/information pages are now limited to 15 character search phrases, to avoid performance issues
- Updated: added a work-around for a conflicting extension
- Updated: improved admin search so it wouldn't ignore certain products

Updated to v303.3

Release Notes:
- Added: ability to generate Keyword Cache values based on the last 100 unique search queries from the Smart Search history
- Added: ability to search in all languages instead of just the language selected by the customer
- Added: ability to start the live search only after a certain number of characters have been enterd by the customer
- Added: some minor improvements for the English pluralization code
- Added: inflection/pluralization code for Dutch, French, Italian, Norwegian (Bokmal), Portuguese, Spanish, and Turkish (I don't speak any of these languages so please contact me if you see problems with them)

- Fixed: issues with "&" character in search phrases
- Fixed: turning off partial word matches could cause issues with search phrases that have more than one word in them
- Fixed: hiding individual products or out of stock products would also hide them from the admin panel search
- Fixed: category/information/manufacturer results may not show up if there was only 1 search term and the extension was set to skip Phase 1
- Fixed: admin-side "Smart Search enabled" text was showing up even when the admin search or the extension was disabled

- Removed: unnecessary $relevance variable
- Removed: MijoShop fix from ocMod file (you can contact me if you want this)

- Updated: the live search will now be hidden when hitting the Enter key
- Updated: the number of results and completion time is now shown in the Testing Mode log
- Updated: improved search speed for large databases by changing the LEFT JOIN queries for the "product_description" and "product_to_store" tables so they are only joined on one variable, and moved the other one to the WHERE clause

Updated to v303.4

Release Notes:
- Added: compatibility with some "filter by manufacturer" extensions
- Added: Azeri now uses the Turkish pluralization library
- Added: very simple pluralization support for Russian

- Fixed: occasional sorting issues in the live search
- Fixed: cache files not getting deleted until the same search was performed
- Fixed: very rare bug causing pre-search replacements not to work
- Fixed: "Undefined index: description" error when searching on the field "Description (Phases 3 & 4)" and finding a product that has no description
- Fixed: under certain circumstances Phase 3 could still be run even when the misspelling tolerance was set to 100%
- Fixed: Phases 3 and 4 were not working with the non-chosen language when set to search in all languages
- Fixed: "Invalid default value for 'date_added'" error when MySQL is set for NO_ZERO_DATE for DATETIME fields
- Fixed: heading appearing in the Live Search for category/manufacturer/ information page results when they were enabled but set to show 0 results
- Fixed: "Trying to access array offset on value of type null" error

- Updated: iOS doesn't report keycodes for Cyrillic characters properly, so I added a work-around so that the live search will detect them
- Updated: styling improvements for live search row height

Updated to v303.5

Release Notes:
- Added: option to put Out of Stock products at the end of the results list, instead of just showing or hiding them
- Added: the language is now recorded in the search history if the OpenCart installation has more than 1 language
- Added: option for Fulltext Searches to proceed onto the normal search when no results are found in the Fulltext search process
- Added: ability to include category and manufacturer results based on the products found from the search process

- Fixed: some search ordering wasn't working correctly when choosing DESC
- Fixed: live search incompatibility with Add to Cart Button Switcher
- Fixed: category/manufacturer/information page results were not using the new Azeri and Russian pluralization settings

- Updated: improved logging for Fulltext Searches
- Updated: category/manufacturer/information page results now show results with names that exactly match the search phrase ahead of other results

Updated to v303.5

Release Notes:
- Added: option to put Out of Stock products at the end of the results list, instead of just showing or hiding them
- Added: the language is now recorded in the search history if the OpenCart installation has more than 1 language
- Added: option for Fulltext Searches to proceed onto the normal search when no results are found in the Fulltext search process
- Added: ability to include category and manufacturer results based on the products found from the search process

- Fixed: some search ordering wasn't working correctly when choosing DESC
- Fixed: live search incompatibility with Add to Cart Button Switcher
- Fixed: category/manufacturer/information page results were not using the new Azeri and Russian pluralization settings

- Updated: improved logging for Fulltext Searches
- Updated: category/manufacturer/information page results now show results with names that exactly match the search phrase ahead of other results

Updated to v303.6

Release Notes:
- Added: option to show a "Did you mean...?" section at the top of the live search results, based on words from the misspelling cache files
- Added: option to ignore certain categories, information pages, and manfuacturers in the search results
- Added: if the "Include Categories/Manufacturers From Product Results" setting is enabled, the live search category/manufacturer links will now be to a search page that will display the relevant product results filtered by that specific category/manufacturer

- Fixed: DESC sorting was not working sometimes
- Fixed: Safari-specific issue with the live search z-index layering
- Fixed: duplicate results were occasionally showing from the new settings
- Fixed: database query error when using the "Include Categories From Product Results" feature and there are no product results
- Fixed: error when generating keyword cache from the admin panel when Ultimate Filters is installed and set to only show relevant values
- Fixed: admin sorting by Quantity or Status was not working properly

- Updated: styling fixes in the live search for RTL languages
- Updated: the "ip" column of the "smartsearch" table now fits IPv6 values
- Updated: empty categories/manufacturers/information pages will no longer be displayed if there is a corrupted entry in the OpenCart database