product filter module addon

[kyli51]

hi all,
thanks for the reply...yes i do understand the issue...the thing is i already tried..and it works...but only half of it..means i obviously dont have the error anymore but i can't still filter only by price...otherwise i have all the result..no matter the value..

any other ideas ?

[pelasgos]

The same for me..
Every price-range value that I select, the filter shows all products as a result.
Any ideas?

[dropbop]

The solution is to (probably) remove the "zs_" prefix on the table "zs_products_attributes" in the SQL statement. If you know how to view your SQL tables, view them and look for the correct table name. My tables do not have a "zs_" prefix, but your tables may have another prefix.

Go to:
"includes/modules/pages/product_filter_result/header_php.php"

Change the line:
<code>$where_str .= " AND ((pa.products_id In (SELECT pa.products_id FROM zs_products_attributes pa WHERE ("; </code>

To:
<code>$where_str .= " AND ((pa.products_id In (SELECT pa.products_id FROM products_attributes pa WHERE ("; </code>

OR change it to the product_attribute table name in your system.

Hope it works and you understand what I'm talking about...

Perfect - cheers for that, Worked perfectly!

Such a simple thing to miss.

And for people who installed Zen using fantastico.. you may have to change the table prefix to 'zen_' as fantastico can add it automaticly to your tables.

To find out what the table prefix is.. open cpanel

http://www.yourdomain.com/cpanel

scroll down to phpMyAdmin and click it.

Find the database your zencart is using.

you will see at the start of each table a prefex ie: 'zen_'


copy the prefix and change the prefix in the header_php.php supplied with this addon

Find this line

$where_str .= " AND ((pa.products_id In (SELECT pa.products_id FROM zs_products_attributes pa WHERE (";

and change zs_products_attributes to zen_products_attributes (or what ever your database prefix is)


Hope this is of some help....

DB

[DrByte]

Or just use the much simpler universal fix i posted earlier ...

[BikeTuna]

Can anyone tell me how to install this? I cant seem to get it working....

thanks

[pajur]

Hi, I have the same problem as some other people here. Filter is not working at all. No error message, it just will not get any results, no matter what you set as a condition.

[BikeTuna]

Hi all,

I'm still having problems getting this working, I've got a lot further than before from following all the fixes on here, but have 3 remaining issues

1 - How do you limit the search box so it only searches by one specific attribute?

2 - The results are not showing anything, and I believe this is because it is not searching subcategories

3 - The order of the attribute options are not in the same order as the default sort order, instead they are in the order that they were entered into the database.

Any help would be appreciated

[pajur]

2 - results are not showing anything - In my case, it does not matter if products are in categories or subcategories. No errors, but also no results at all.

[BikeTuna]

2 I have now done further testing and found it not working regardless of subcategory

Please help!!! I dont want to launch the site without this functionality!!!

[frumfell]

hi, i would like to ask you about some problem with filter module addon. i have installed last version 0.7 where are files to czech version, beside english.
i have changed chech files to polish, but i have this kind of problem, that filter see all attributes doubled, regardless which language version is on. i mean, on polish version for example atributes are doubled, and in both, you can choose both attribute values.
im not sure, but if you can have a look
malowanaszafa.pl
if there is any one who installed this addon in multi language sites? and how to solve this problem?
my zencart version 1.3.8
with polish language module from zencart.com.pl

i have one idea, what can couse this problem. when i add new option value to option name in option value manager in admin , they seem to be doubled ?