Products Listing Based on Price Range

[alihelp]

Hi,

 

I want help regarding Products Listing Based on Price Range. In my project i have to display catagories list and as well as products price range like:

1. less then $100

2. $100 - 200

3. $200 - 300

4. Above $300.

 

And when i click on any price range like ($100 -200), it will display all products as well as price range will be sub-categoried as,

 

1. $100 - 150

2. $150 - 200

 

I not able descide how to design my table structure.

 

I want to include this feature with osCommerce.

 

Thanks in advance.

[GraphicsGuy]

I think this is what you are looking for:

 

Shop by price infobox

 

You can see it in action on my site.

[alihelp]

I think this is what you are looking for:

 

Shop by price infobox

 

You can see it in action on my site.

 

 

Dear GraphicsGuy,

 

In your website you have this feature "Shop By Price", http://www.sullisys-ihs.com. But i am looking for different one. You price range link statically defined, i want it be dynamically generated by PHP program. For example, if some one click on a category, it will list all products under that category and also generate a "Shop By Price" for that category like

less than $100 (no. of pruducts in this category)

$100 - 200 (no. of pruducts in this category)

$200 - 300 (no. of pruducts in this category).

 

This price range will be based on category's products.

[GraphicsGuy]

I am not aware of any contributions that provide that exact functionality. That contribution, like most everything in osc is dynamically generated. You may be able to adapt the Shop by Price Infobox contrib by adding code to limit the results to the current category.

Edited October 21, 2005 by GraphicsGuy