product filter module addon

thanks man fobes77 it's work for me very well

Mike Shaw

fobes77:

Hello, this is a very useful module and I'm glad I managed to get images to show up in the results.

Add p.products_image to the following line in your includes/modules/pages/product_filter_result/header_php.php file -

Change line 132

from -

$listing_sql .= "p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status ";

> 
> to -
> 
> ```
$listing_sql .= "p.products_id, pd.products_name, [B]p.products_image[/B], p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status ";

Worked for me :smile:

thanks me too

I love this mod, but..

The search results have "No Image Available"!
I also get "TEXT_NO_PRODUCTS", on some searches. Does anyone have any thoughts?

Thanks in advance!

I've installed this mod, it works, but not completly, i cannot filter products by price, when i do that it show all products, i've only changed pricing to higher ones, does somebody have similiar problems?

Next thing that i noticed - you can filter products by only one attribute, if you add second one filter will show nothing

I really need this thing to get working, i can pay for that, if authot or some programmer is intrested please write me your proposition on private message

Has anyone figured out how to get the price filter to work. I am still trying to figure out the coding myself (I'm very much a beginner, too) so customers could search by price.

To remove TEXT_NO_PRODUCTS follow these steps:

go to file manager in cPanel
includes/languages/english/extra_definitions/YOUR_TEMPLATE/product_filter_defines.php
find:

define('SHOW_CATEGORIES',true);
define('SHOW_ATTRIBUTES',true);
define('SHOW_PRICE_RANGE',true);
define('SHOW_AVAILABLE',false);
define('SHOW_SORT',true);
?>

change to:

define('SHOW_CATEGORIES',true);
define('SHOW_ATTRIBUTES',true);
define('SHOW_PRICE_RANGE',true);
define('SHOW_AVAILABLE',false);
define('SHOW_SORT',true);

define('TEXT_NO_PRODUCTS', 'Sorry, no items to list for your search criteria');
?>

You can change the above define for TEXT_NO_PRODUCTS to whatever you want the page to say when there are no matches for the search criteria you have set. There might be another way to do this, but as a novice, this has worked for me.

Ok, I figured out how to get the price filter to work. I had to actually open the header_php.php file (includes/modules/pages/product_filter_result/header_php.php) and set the line:

$enable_price_filter = true;
switch($price_range){

to true (as shown above). It was set to false. :P

Now to figure out how to get the CATEGORIES section to filter. I can only filter by subcategories. If a category does not have a subcategory, then it will filter fine. But if the category has a sub, it will not filter. I assume (I know that's bad to do) that I need to link the items in my subcategories to its parent category. Back to the hunt.

I'm sure all of this is basic to those who are currently using this mod, but I'll continue to document my findings for those who are new and want this info.

Does anyone have a link to this mod working?

I am setting up a clothing shop and need to be able to filter by price / color and size (color and size being attribs) so will this work?

Does it filter inside categories? (if you are in cat A for example and then select a filter will it only show the results for cat A?)

Is the images issue fixed yet?

Thanks! :)

twdhosting:

Does anyone have a link to this mod working?

I am setting up a clothing shop and need to be able to filter by price / color and size (color and size being attribs) so will this work?

Does it filter inside categories? (if you are in cat A for example and then select a filter will it only show the results for cat A?)

Is the images issue fixed yet?

Thanks! :)

See my site for example, http://www.elitebralingerie.com . BUT I do not use filtering by Price and by Sort. They work if configured correctly (see this thread and my http://www.zen-cart.com/forum/showthread.php?t=116349&highlight=product+filter )

Yes, if you are choose cat A, the results will be only from cat A.

One notice more, if your currency is not $, you have to change "product_filter_defines.php" - for example, to GBP or \pound
\euro .

I have a question too.

The attributes appear in a "broken" order (see for example, https://www.elitebralingerie.com). Note that the attributes have the correct default order in "Option Values".

Does someone had a similar problem, and how was it fixed?

No disrespect, but this mod sucks. After reading the post and in spite of everyone having problems making it work, I tried to install it. Needless to say, nichts, nada, nothing! It's not worth a download.

If you're looking for a really, really good product filter then download and install the css_horizontal_drop_down_menu_1-5 from here.

It's not only a fantastic header menu with css fly out and completely customisable links, but it adds a rather amazing sort by filter to all of your pages!

I just thought I'd share this with you as I'd been searching in vain for a good product filter and had given up the chase when I stumbled on this by complete accident.

I'm trying to get this module to work - the sidebox displays fine with the attributes dropdowns listed but as soon as I try and filter by any of the attribute options I get this error on the page:

1054 Unknown column 'options_1' in 'where clause'
in:
[select count(distinct p.products_id) as total FROM products p, products_description pd, products_to_categories p2c, products_attributes pa, products_options po , products_options_values pov WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = options_1 AND p.products_status =1 AND p.products_quantity > 0 )]

I've Googled this and up to now I have only found a reference to SQL5 and the JOIN function - but this server is SQL4.x and this script doesn't use the JOIN function as far as I can see...?

Any ideas anyone?

Can anyone see anything wrong with the above SQL or have any ideas?

Thanks

I installed this mod on 1.3.8 and it seems to work pretty well with only one little glitch which I fixed by altering the language file that was generating page headings on all my ezpages.

My question to the forum is whether or not anyone knows a way to filter the filter... That is to say, is there a way of making the size dropdown show only certain sizes? At the moment it shows all possible combination of sizes, regardless of whether they're in stock or not. This is the only real problem with what is otherwise a great add-on.

milobloom:

set to true and got same results.... Just times out.

Hello,

Did you managed to fix it ? i have the same problem

Regards,

Ok, I hope someone can answer. I can't get the filter to come back with any items.

My Site: https://www.zenwinedesign.com/catalog

Whenever you click on one or more attribute, no items come back. I have changed everything that is in this thread with no avail. I only have a few of my items currently setup with attributes so far. I will set the rest up if I can get the filter working.

hi,

did anyone managed to make this work ? i have the same problem...no products are displaying at all..

please help..

Kyli

hi all,

any update on this...i tried everything but impossibel to get any results...

any idea ?

Kyli

hi all,

for some strange reason i think i'm getting close... nothing was working at all but now i create attributes (that i was not using before at all) and it seems that i have product showing while making a search...except 2 issues...

• in Fact all products appears, so the filter does not work.,.it does not filter at all..
• while make a sorting by attributes this is what is have :

1146 Table 'eq74179.zs_products_attributes' doesn't exist
in:
[select count(distinct p.products_id) as total FROM products p, products_description pd, products_to_categories p2c, products_attributes pa, products_options po , products_options_values pov WHERE (p.products_status = 1 AND ((pa.products_id In (SELECT pa.products_id FROM zs_products_attributes pa WHERE ( pa.options_id = 1 AND pa.options_values_id = 3 )))) AND p.products_id = pa.products_id AND p.products_quantity > 0 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id)	]

1146 Table 'eq74179.zs_products_attributes' doesn't exist
in:
[select count(distinct p.products_id) as total FROM products p, products_description pd, products_to_categories p2c, products_attributes pa, products_options po , products_options_values pov WHERE (p.products_status = 1 AND ((pa.products_id In (SELECT pa.products_id FROM zs_products_attributes pa WHERE ( pa.options_id = 1 AND pa.options_values_id = 3 )))) AND p.products_id = pa.products_id AND p.products_quantity > 0 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id)	]
```\[/QUOTE]

Hi,

This is the first time I ever posted my input on any coding forum and I have to say that the best way to get over these little hurdles is to actually learn the coding language (PHP in this case).  I've struggled for a while myself.  


The way to fix the problem (and most other problems) in Zen Cart is two steps:
1. Read the error message
2. Use the Developers Toolkit to find the thing referenced in the error message

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...

Likely right.

I would suggest that it might be even better to use the constant for the tablename, since that will already include the correct prefix, like this:```
... SELECT pa.products_id FROM [B]" . TABLE_PRODUCTS_ATTRIBUTES . "[/B] pa WHERE ...