Price range widget should check variations too

wp-e-commerce / WP-e-Commerce

WP eCommerce - The most popular independent eCommerce platform for WordPress

https://wpecommerce.org

GNU General Public License v2.0

213 stars 216 forks source link

Price range widget should check variations too #800

Open mihaijoldis opened 10 years ago

mihaijoldis commented 10 years ago

At the moment the price range widget does not show the products if they have a variation price that fits the range. the sql query needs redone.

also when using the All filter a notice is visible:

Notice: Undefined offset: 1 in D:\wamp\www\testwp\wp-content\plugins\wp-e-commerce\wpsc-components\theme-engine-v1\widgets\price_range_widget.php on line 152

JustinSainton commented 10 years ago

We're not quite there yet on this, punting pending further revisions.

mihaijoldis commented 10 years ago

Just an update. I believe there is an issue with the retrieval on products with big prices too. Got a store with products prices like $87,000.00 and higher and when you click the widget to show products Over $13,500.00 it only lists like 6 products while there are lots more.

A review of the SQL would be in order i think