product filter module addon

[jye999]

I wrote a sidebox module for product filter by attribute, and price range. I looked all over the places and couldn't find something similar, so ending writing my own. It seems to be working, but only tested using zen-cart v1.37.

Don't forget to read the README file first. I tried to sumit to zen-cart.org. But the file didn't get submitted (don't know why).

Anyways, Here's the download page in my blog. Zen Cart Product Filter by Attribute, Price RangeZen Cart Product Filter by Attribute, Price Range. I wish zen-cart can give me a place to host the file. I've already tried to submit to the download page, but it failed to upload.

[DrByte]

I wish zen-cart can give me a place to host the file. I've already tried to submit to the download page, but it failed to upload.

It uploaded fine:
http://www.zen-cart.com/index.php?ma...roducts_id=760

[alray10]

I have been looking for something like this but found to problems with this mod.

First is no Images show.

The second when you put price lowest to highest it gives this out.

1054 Unknown column 'P.products_price' in 'order clause'
in:
[select DISTINCT p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status FROM zen_products p, zen_products_description pd, zen_products_to_categories p2c, zen_products_attributes pa, zen_products_options po , zen_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 pa.options_id = 1 AND pa.options_values_id = 26 AND p.products_id = pa.products_id AND p.products_status =1 AND p.products_quantity > 0 ) order by P.products_price ASC, p.products_date_added DESC, p.products_date_available DESC limit 0, 15]

If these 2 things are corrected it has the makings of a great mod.

[Ajeh]

The reference P.products_price looks in correct as the alias is p and not P ...

Perhaps a typo and you need this referencing the products table with p vs P ...

[alray10]

The reference P.products_price looks in correct as the alias is p and not P ...

Perhaps a typo and you need this referencing the products table with p vs P ...

Thanks for that it sounds like it could be the problem, I have not tried it because it is the images or lack of them I really need to sort out.
Any ideas on that it just gives a page full of no image available boxes.

[Fireflyz]

I wrote a sidebox module for product filter by attribute, and price range. I looked all over the places and couldn't find something similar, so ending writing my own. It seems to be working, but only tested using zen-cart v1.37. ..........

Thanks! exactly what I was looking for.
Is there a way to exclude certain attributes?

[bigjoed]

I'm having this same problem:


1054 Unknown column 'P.products_price' in 'order clause'
in:
[select DISTINCT p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status FROM zen_products p, zen_products_description pd, zen_products_to_categories p2c, zen_products_attributes pa, zen_products_options po , zen_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 pa.options_id = 1 AND pa.options_values_id = 26 AND p.products_id = pa.products_id AND p.products_status =1 AND p.products_quantity > 0 ) order by P.products_price ASC, p.products_date_added DESC, p.products_date_available DESC limit 0, 15]

It seems that you answered it and corrected the problem but I didn't quite understand how to do so.

Exactly what do I do with:
The reference P.products_price looks in correct as the alias is p and not P ...
Perhaps a typo and you need this referencing the products table with p vs P ...

Thanks

[jomo5280]

I got this module installed - but for some reason when i submit i get this response: TEXT_NO_PRODUCTS

What do i have not configured correctly? eeek!

[yellow1912]

People with the P problem:

Open: includes/modules/pages/product_filter_result/header_php.php
Find:

case 2:
            $order_str = " order by P.products_price ASC, p.products_date_added DESC, p.products_date_available DESC "; 

Replace by:

            $order_str = " order by p.products_price ASC, p.products_date_added DESC, p.products_date_available DESC "; 

[Fireflyz]

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!