Post by pappco » Sat Jul 14, 2012 7:27 pm

Take care! Read carefully the version history.

Have you ever had to many products in one category, nobody found anything. If the product has got attributes, why not filter products trough this attributes? This module was developed for a tire shop, we had more than 1000 product in one category and more than 10000 product, there was no option to put in more separated categories, because opencart was really slowed down.

The modification allows you to add UNLIMITED Advanced Attribute Search box to any layout page.

The mod can be found here http://www.opencart.com/index.php?route ... on_id=7297

---------------------------
Advanced Attribute Filter (+Price, +Manufacturer)
version 3.5
vQmod version 2.4.1
written by Péter Papp - Pappco.hu
---------------------------

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 spliting, in this example, by coma. One click and all filters are automatically created.
- Support of select one or select multiple attribute values
- Refresh filter counts with Ajax
- Select multiple categories to filter (it will only filter one categories, but show a dropdown with selected categories)
- Can be placed on almost all layouts (On category layout select categories where module should display)
- Custom title support
- Custom template 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)

Update from 1.*:

- Connect using a FTP program to your hosting/server account and browse the root of your OpenCart installation folder.
- Upload the folders, "admin", "catalog" and "vQmod" 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).
- Remove catalog/model/catalog/attribute.php (we don't need it any more, for safety only rename first!)
- Enter OpenCart's administration menu, Extensions > Modules and "Edit" the module
- Save your settings

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 folders, "admin", "catalog" and "vQmod" 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.


Compatibility:

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

Important: If you click on search button and nothing happens, you may have to update JQuery. If you have version 1.5.1.3.1, you definitely need 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/advattrsearch.php", "catalog/language/english/module/advattrsearch.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/advattrsearch.tpl"
for your custom theme's module folder:
"OC_FOLDER/catalog/view/theme/YOUR_THEME/template/module/advattrsearch.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/advattrsearch.css"
for your custom theme's module folder:
"OC_FOLDER/catalog/view/theme/YOUR_THEME/stylesheet/advattrsearch.css"
and edit it to fit your theme.

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

3.4 (20140124):
- fixed mysql escape issues

3.3 (20131210):
- fixed deprecated function (getCategoriesByParentId)
- fixed paging,sorting problems
- fixed price filter problem occured when the start price was 0

3.2 (20130904):
- fixed sql error when not on category layout
Files affected:
- catalog/controller/module/advattrsearch.php

3.1 (20130830):
- fixed problems when using seo urls
Files affected:
- catalog/controller/module/advattrsearch.php
- catalog/view/theme/default/template/module/advattrsearch.tpl

3.0 (20130823):
- fixed sql error
Files affected:
- catalog/model/tool/advattrsearch.php

2.9 (20130802):
- manufacturer filter fix
- product count fix
- changed .clear class to .clear-filter
- minor css fix

2.8 (20130527) - added multi store support
2.7 (20130516) - bug fix price filter
2.6 (20130306) - bug fix almost same attributes cannot be searched (hello, 1hello)
2.5 (20130129) - bug fix
2.4 (20121030) - bug fix
2.3 (20121027) - feature request: Refresh filter counts with Ajax.
2.2 (20121023) - bug fix
2.1 (20121021) - bug fix
2.0 (20121008) - bug fix, removed feature: display of group attributes, new feature added: attribute count (see how many products have the attribute), price count, manufacturer count, css update, code clean up
1.4 (20120902) - bug fix
1.3 (20120823) - bug fix, new feature added: attribute separator, search by attribute group, help texts, admin minimal design
1.2 (20120809) - new feature added: search by manufacturers, search by price (input fields and multiselect)
1.1 (20120806) - bug fix, compatibility check
1.0 (20120713) - initial release

Some screenshots:
ADMIN
Image

Image

Image

STORE
Image

Image

Image
Last edited by pappco on Tue Jun 03, 2014 7:03 pm, edited 15 times in total.

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by pappco » Wed Jul 18, 2012 12:19 am

I tested it with OpenCart version 1.5.3 it's working. In next days i will test with other versions.

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by aaviya » Fri Jul 20, 2012 10:39 pm

Hi, can you remove this "submit" button and make it with js?

New member

Posts

Joined
Wed Jul 06, 2011 7:47 pm

Post by pappco » Thu Aug 09, 2012 11:21 pm

Hi,

what do you mean with submit button? You dont want to push search?

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by pappco » Thu Aug 09, 2012 11:23 pm

New version is released.

1.2 (20120809) - new feature added: search by manufacturers, search by price (input fields and multiselect)
1.1 (20120806) - bug fix, compatibility check

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by pappco » Thu Aug 23, 2012 5:25 pm

New version is released.

1.3 (20120823) - bug fix, new feature added: attribute separator, search by attribute group, help texts, admin minimal design

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by pappco » Mon Jul 29, 2013 4:57 pm

UPDATE:

2.8 (20130527) - added multi store support
2.7 (20130516) - bug fix price filter
2.6 (20130306) - bug fix almost same attributes cannot be searched (hello, 1hello)
2.5 (20130129) - bug fix
2.4 (20121030) - bug fix
2.3 (20121027) - feature request: Refresh filter counts with Ajax.
2.2 (20121023) - bug fix
2.1 (20121021) - bug fix
2.0 (20121008) - bug fix, removed feature: display of group attributes, new feature added: attribute count (see how many products have the attribute), price count, manufacturer count, css update, code clean up
1.4 (20120902) - bug fix

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by pappco » Fri Aug 02, 2013 7:35 pm

UPDATE:
2.9 (20130527):
- manufacturer filter fix
- product count fix
- changed .clear class to .clear-filter
- minor css fix

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by pappco » Fri Aug 23, 2013 3:16 pm

UPDATE:
3.0 (20130823):
- fixed sql error
Files affected:
- catalog/model/tool/advattrsearch.php

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by pappco » Fri Aug 30, 2013 7:38 pm

UPDATE:
3.1 (20130830):
- fixed problems when using seo urls
Files affected:
- catalog/controller/module/advattrsearch.php
- catalog/view/theme/default/template/module/advattrsearch.tpl

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by pappco » Wed Sep 04, 2013 6:40 pm

UPDATE:
3.2 (20130904):
- fixed sql error when not on category layout
Files affected:
- catalog/controller/module/advattrsearch.php

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by popo » Sun Dec 08, 2013 6:31 am

Hey, when i install this on 1.5.5.1 all of a sudden all catagory pages stop working and the error log shows me vqmod/vqcache/vq2-catalog_controller_product_category.php on line 316

what is going on?

New member

Posts

Joined
Wed Jun 22, 2011 3:27 am

Post by pappco » Tue Dec 10, 2013 4:02 pm

popo wrote:Hey, when i install this on 1.5.5.1 all of a sudden all catagory pages stop working and the error log shows me vqmod/vqcache/vq2-catalog_controller_product_category.php on line 316

what is going on?
Hello,

Please write us an email for the following address: opencart@pappco.hu, and please provide us the following information:

Opencart username:
Opencart version number:
VQMod version number:
Installed module name:
Installed module version number:

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

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by pappco » Tue Dec 10, 2013 5:24 pm

UPDATE:
- fixed deprecated function (getCategoriesByParentId)
- fixed paging,sorting problems
- fixed price filter problem occured when the start price was 0

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by raimond » Thu Dec 12, 2013 7:08 am

hi,

will this extension work on MijoShop?

Newbie

Posts

Joined
Tue Oct 08, 2013 11:36 pm
Location - Wierden

Post by asitha » Sun Dec 15, 2013 6:03 am

Is there a way to have this module show up on the search page when a customer does a normal search query, and then this module allows the search to be filtered further?

Newbie

Posts

Joined
Sun Dec 15, 2013 5:56 am

Post by pappco » Fri Jan 24, 2014 5:56 pm

UPDATE:
3.4 (20140124):
- fixed mysql escape issues

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm

Post by pappco » Thu Mar 06, 2014 3:51 pm

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

New member

Posts

Joined
Sat Jul 14, 2012 6:33 pm
Who is online

Users browsing this forum: No registered users and 134 guests