Community Add-Ons

in the instant search the returned results will include products which have been set inactive in the catalog admin area.

in older versions the facilaty to turn a products status off may not have existed so ive only included this as a information file not a complete package.

this bug is very easy to fix - see below



in searches.php replace


$sqlquery = "SELECT distinct(p.products_id),
pd.products_name,
p.products_price,
p.products_tax_class_id
FROM " . TABLE_PRODUCTS_DESCRIPTION . " pd,
" . TABLE_PRODUCTS ." p
WHERE" . $like_statement . " AND
pd.products_id = p.products_id";


with

$sqlquery = "SELECT distinct(p.products_id),
pd.products_name,
p.products_price,
p.products_tax_class_id
FROM " . TABLE_PRODUCTS_DESCRIPTION . " pd,
" . TABLE_PRODUCTS ." p
WHERE" . $like_statement . " AND
pd.products_id = p.products_id AND p.products_status =1";

As I found it hard when search for groups of products which the same naming convention. I included the standard query search as a link option.

I'm not sure if there are any budding Javascript programers out there , but I would love it if someone had the time to include keyboard control for naviagetion like google. I've had a look and I'm lost here!

Fantastic contribution!

Just a small alteration which removes the advanced search and replaces it with the standard search together with what the customer is searching for.

I found that if the model number was different to the title name then you could not find the product!

I had problems with utf-8 and using "tep" functions instead of PDO library solved it

Changes:
- OSC 2.2 style
- added languages files (english, polish)
- categories names are made during "getting higher" on the categories tree (each category's name on the way is used as a part of output category's name)
- added tep_href_link in many places
- works with utf-8 (using "tep" oscommerce mysql functions instead of PDO)

English_______________
Added enhancements in SQL to optimize the categories and products.

Added header for coding for iso-8859-1 or strange characters.

Español______________
Añadidas mejoras de optimización en las SQL de categorías y productos.

Añadido header para codificación de letras iso-8859-1 o con caracteres extraños.


Added screenshot.
Tested with Firefox, IExplorer, Chrome & Safari.

Moved the files around and removed many.
* JQuery Files removed as are older versions of ones already there.
* Moved JQuery files into the JQuery Folder
* Moved the searches.php file to root
* Removed the requires to other files and replaced with application_top.php
* Added Query to get the Tax rate, Price, Specials Price, and the Currency Prefix to show in the Container
* Change currency also changes the results in the Container
* Added wording to the Morresults text and made it bold
* Added populating link to advanced_search from the no results found text.
* Amended the stylesheet links to be correct
* Amended the Script links to be correct
* Moved the stylesheet.css to root

Instant Search For osCommerece 2.3.1

Test and Developed with 2.3.1 but should work with any versions.

By Louis Varley contact@berrywoods.co.uk

Version 2, Added new Features

New Features In This Release.

Ability to Correct Search Phrases (See Searches.php)

Suggests Categories AND products (Only Second Level and Above Categories Are Suggested)

Instant search is more efficent, and now rolls on results without hiding and re-showing the window.

displays prices for products and ability to add to basket.

As original contribution, but with corrected stylesheet linking code for template_top.php (Missing ">" in original release)

Allows Placement of a Search Box which works in the same manor of googles instant search box, where criteria are instantly searched and results displayed in a pretty drop down div.

No Location exampes are given and placement of the searchbar is down to you.