Automatic Attribute Filter (+Price, +Manufacturer)

Automated, improved version of Advanced Attribute Search. We removed some features from it to make the module easier to configure, and we improved some of them to be it more useable. The main difference between this module and Advanced Attribute Search is that on the frontend it will display attributes that are enabled on the admin and there are products in the category which connected to the attribute. For example if you have an attribute called "Tire size" enabled on the admin but in the category where you put the module there are no products with "Tire size" attribute, then the "Tire size" filter won't display. The attributes are sorted by their sort order.

The extension can be found here: http://www.opencart.com/index.php?route ... n_id=13049

---------------------------
Automatic Attribute Filter (+Price, +Manufacturer)
version 1.6
vQmod version 2.4.1
written by opencartgeek.com
---------------------------

Features:

- The ability to filter products in a category through they attributes, manufacturers, stock prices (see how many products fits the search criterias - count)
- Attributes can be split by a configurable char. If you have, for example, a ClockSpeed Attribute with values like "100MHZ,200MHZ" you can instruct the module to create multiple filter entries by splitting, in this example, by coma. One click and all filters are automatically created.
- Support of select one or select multiple attribute values
- Can only be displayed on Category layout
- Automatically decides which attribute filters to display. (Will display attribute filters only if they are enabled on the admin, and connected to at least one of the products in the category)
- Custom title/language support
- Selectable attributes
- Unlimited module placement

Support: opencart@pappco.hu
Demo: http://demo.opencartgeek.com/
Admin demo: http://demo.opencartgeek.com/admin/(demo/demo)

Prerequirements:

- vQmod (2.4.1)

Installation:

- First you need install vQmod (http://code.google.com/p/vqmod/)
- Extract the downloaded archive
- Connect using a FTP program to your hosting/server account and browse the root of your OpenCart installation folder.
- Upload the contents of "upload" folder to OpenCart's root folder. You should not get any file replacement warnings. If you do, double check to make sure you are not replacing any critical files (if you had an older version of the modules already installed, you will need to replace the old files).
- Enter OpenCart's administration menu, Extensions > Modules and "Install" the module
- Configure the module.

Update:

- Connect using a FTP program to your hosting/server account and browse the root of your OpenCart installation folder.
- Upload the contents of "upload" folder to OpenCart's root folder. You should not get any file replacement warnings. If you do, double check to make sure you are not replacing any critical files (if you had an older version of the modules already installed, you will need to replace the old files).
- Enter OpenCart's administration menu, Extensions > Modules and "Edit" the module
- Save your settings, even if you didn't make any changes.


Compatibility:

This version is tested with OpenCart 1.5.6.*, 1.5.5.*, 1.5.4.*, 1.5.3.*, 1.5.2.*

Important: If you click on search button and nothing happens, you may have to update JQuery.

How to update JQuery:
- Upload the contents of "jquery_update/upload" folder to your Opencart installation folder.
- Open "catalog/view/theme/YOUR_THEME/template/common/header", and search for the following code snippet: "<script type="text/javascript" src="catalog/view/javascript/jquery/jquery-".
- Change the version number to 1.7.1 and save the file. The modificated line should look like this: "<script type="text/javascript" src="catalog/view/javascript/jquery/jquery-1.7.1.min.js"></script>".


Non-English users:

The english translation file is located at "admin/language/english/module/autoadvattrsearch.php", "catalog/language/english/module/autoadvattrsearch.php"

Important:

take care with turn on count for every attributes, it can lead to performance problems, we did created a good cache, and good sql query, but...

Custom themes:

You will need to copy the included template files:
"OC_FOLDER/catalog/view/theme/default/template/module/autoadvattrsearch.tpl"
for your custom theme's module folder:
"OC_FOLDER/catalog/view/theme/YOUR_THEME/template/module/autoadvattrsearch.tpl"
and edit it to fit your theme.

Custom css:

You will need to copy the included css files:
"OC_FOLDER/catalog/view/theme/default/stylesheet/autoadvattrsearch.css"
for your custom theme's module folder:
"OC_FOLDER/catalog/view/theme/YOUR_THEME/stylesheet/autoadvattrsearch.css"
and edit it to fit your theme.

Version history:
1.6 (20140228)
- fixed problem which we solved before with displaying "Tax settings error"
- added missing helper loader function for older versions of opencart

1.5 (20140218)
- fixed deprecated function (getCategoriesByParentId)

1.4 (20140124)
- fixed mysql escape issues
- fixed pagination, sorting issues

1.3 (20131204)
- attributes are now sorted by their sort order

1.2 (20131120):
- fixed price filter when tax rates are misconfigured

1.1 (20130813):
- fixed display in categories
- bugfix
Files affected:
- catalog/controller/module/autoadvattrsearch.php

1.0 (20130713) - initial release

Screenshots:

I purchased this extension but it is not working. It is showing some SQL Error on my category Page.
Please help

Here is the error message.

UPDATE:
1.1 (20130813):
- fixed display in categories
- bugfix
Files affected:
- catalog/controller/module/autoadvattrsearch.php

I like the script but what I can do to make "Product filter" appears on the search engine (index.php? route = product / search & search = example) and not just in the categories (index.php? route = product / category & path = 5)
thanks for everything, very friendly

I am also getting the SQL error and can't get this to work....

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF(p.tax_class_id = 10, 2.0000,IF(p.tax_class_id = 0, 0,0))))/1 as calcPrice FRO' at line 5
Error No: 1064
SELECT max(lp.calcPrice) as price FROM eashopproduct p join (SELECT p.product_id, @lowestPrice := LEAST(p.price, IFNULL((SELECT price FROM eashopproduct_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1),p.price), IFNULL((SELECT price FROM eashopproduct_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1),p.price)), (@lowestPrice + IF(p.tax_class_id = 9, ,IF(p.tax_class_id = 10, 2.0000,IF(p.tax_class_id = 0, 0,0))))/1 as calcPrice FROM eashopproduct as p) as lp on lp.product_id = p.product_id LEFT JOIN eashopproduct_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN eashopproduct_to_category p2c ON (p.product_id = p2c.product_id) WHERE p2c.category_id IN (84) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

Please send an email us with the following informations:

Opencart username:
Opencart version number:
VQMod version number:
Installed module name:
Installed module version number:
Detailed description of the issue:

Please note that we can't help you until we didn't get these informations.

opencart@pappco.hu

klakieros wrote:I am also getting the SQL error and can't get this to work....

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF(p.tax_class_id = 10, 2.0000,IF(p.tax_class_id = 0, 0,0))))/1 as calcPrice FRO' at line 5
Error No: 1064
SELECT max(lp.calcPrice) as price FROM eashopproduct p join (SELECT p.product_id, @lowestPrice := LEAST(p.price, IFNULL((SELECT price FROM eashopproduct_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1),p.price), IFNULL((SELECT price FROM eashopproduct_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1),p.price)), (@lowestPrice + IF(p.tax_class_id = 9, ,IF(p.tax_class_id = 10, 2.0000,IF(p.tax_class_id = 0, 0,0))))/1 as calcPrice FROM eashopproduct as p) as lp on lp.product_id = p.product_id LEFT JOIN eashopproduct_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN eashopproduct_to_category p2c ON (p.product_id = p2c.product_id) WHERE p2c.category_id IN (84) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

Great Plugin, works really well, however I would like to arrange the filter settings in a custom order so they are not displayed Alphabetically.

For Example, the above shows the following

Aspect Ratio
Finish
Max Resolution
Panel Type
Size
Price

From a retail point of view you would want to promote the most relevent feature first.

e.g Customers wants a 40" TV with 1080i resolution in a light finish for $1000. Therefore the order would be

Size
Max Resolution
Finish
Aspect Ratio
Panel Type
Price

Can you advise me what I need to do?

Thanks

Did any one solved the SQL issue? Or has an idea how to solve it? I`ve purchased this extension and with OC 1.5.5.2 it doesn`t works:/

Update about the problem. Issue lies in the controller with the price selector. I commented out all the price range selectors code and it works. Except the price slicer. Hope it will help for somebody

UPDATE:
1.2 (20131120):
- fixed price filter when tax rates are misconfigured

UPDATE:
1.3 (20131204)
- attributes are now sorted by their sort order

UPDATE:
1.4 (20140124)
- fixed mysql escape issues
- fixed pagination, sorting issues

UPDATE:
1.5 (20140218)
- fixed deprecated function (getCategoriesByParentId)

UPDATE:
1.6 (20140228)
- fixed problem which we solved before with displaying "Tax settings error"
- added missing helper loader function for older versions of opencart

Will an attribute as filter work on subcategories as well?
What I mean see on this example:
Parent Category with name AIR GUNS - there have no linked products to this category
1. Subcategory BULLETS - there have many linked products to this category
attributes:
- weight1
- size1
- color1
2. Subcategory RIFLES - there have many linked products to this category
attributes:
- weight2
- size2
- color2
3. Subcategory ACCESSORIES - there have many linked products to this category
attributes:
- weight3
- size3
- color3

So, If the user is in subcategory BULLETS he will see only the attributes weight1, size1, color1 belong only to the products in this subcategory.
Or to can he see weight1, size1, color1 as filters the products must be linked to the parent category + subcategory?