Dynamic Filter [Support Thread]

[Ajeh]

Could you check, via phpMyAdmin, the products table and see if the Products with Sales/Specials are reflecting those amounts where the field:
products
products_price_sorter

are different ... as in the Sale/Special Price should be in the products_price_sorter ...

If the field:
products_price_sorter

does not contain the Sale/Special Price, do you import your products or manage them all manually in your Zen Cart Admin, as in you do not use Easy Populate or similar programs ...

[philip937]

Could you check, via phpMyAdmin, the products table and see if the Products with Sales/Specials are reflecting those amounts where the field:
products
products_price_sorter

are different ... as in the Sale/Special Price should be in the products_price_sorter ...

If the field:
products_price_sorter

does not contain the Sale/Special Price, do you import your products or manage them all manually in your Zen Cart Admin, as in you do not use Easy Populate or similar programs ...

Thanks for your reply Ajeh, so does Dynamic filter defo use the price sorter field? If so I will have fixed it earlier when I ran an update on it

[Ajeh]

From what I can tell, this is using the products_price_sorter field and the install I have on a play site seems to be working when Sale/Special are used ...

As long as the master_categories_id are setup right, the the fix for the Products Price Sorter in the Store Manager should update that field properly ...

[philip937]

As long as the master_categories_id are setup right,

What do you mean by this?

[Ajeh]

The Products Price Sorter needs to update prices based on Products Price, Specials and SaleMaker and utilizes the master_categories_id in the process ...

The idea behind the products_price_sorter is it holds the base price or displayed price that is pre-calculated in the Zen Cart Admin to avoid the waste of time in the Catalog in making things like sorting by Price faster ...

The Update for the Products Price Sorter is to update this field and is especially needed in most cases of using an Importer or some other processes that might change prices and is not addressed by the default Zen Cart code ...

The master_categories_id is utilized for many things, including how SaleMaker is calculated, Discount Coupons, Products Price Sorter are managed etc.

[Kevin205]

A zen site running 1.5.1 is using a link checker to verify his site's link and on the following urls,

http: //Domain.com/index.php?main_page=products_all&disp_order=1&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_all&disp_order=1&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=21
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=22
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=23

mostly happening on Category[]=19, 20, 21, 22, & 24

he is getting the following warning on lower left hand corner of the page. And the page shows the header info, left category box and the rest is white.

WARNING: An Error occurred, please refresh the page and try again.
Page displays the same when page is refreshed.

It seems to be coming from the dynamic filter. On this site when selecting New Products or All Products and clicking on any of categories 19, 20, 21, 22, 23 & 24.

Any one with any ideas?

[philip937]

The Products Price Sorter needs to update prices based on Products Price, Specials and SaleMaker and utilizes the master_categories_id in the process ...

The idea behind the products_price_sorter is it holds the base price or displayed price that is pre-calculated in the Zen Cart Admin to avoid the waste of time in the Catalog in making things like sorting by Price faster ...

The Update for the Products Price Sorter is to update this field and is especially needed in most cases of using an Importer or some other processes that might change prices and is not addressed by the default Zen Cart code ...

The master_categories_id is utilized for many things, including how SaleMaker is calculated, Discount Coupons, Products Price Sorter are managed etc.

Ah ok I'm with you. Setting the price sorter based on te sale condition against the master category. Happy das understood
Cheers

[philip937]

A zen site running 1.5.1 is using a link checker to verify his site's link and on the following urls,

http: //Domain.com/index.php?main_page=products_all&disp_order=1&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_all&disp_order=1&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=21
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=22
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=23

mostly happening on Category[]=19, 20, 21, 22, & 24

he is getting the following warning on lower left hand corner of the page. And the page shows the header info, left category box and the rest is white.

WARNING: An Error occurred, please refresh the page and try again.
Page displays the same when page is refreshed.

It seems to be coming from the dynamic filter. On this site when selecting New Products or All Products and clicking on any of categories 19, 20, 21, 22, 23 & 24.

Any one with any ideas?

Not encountered anything similar, anything else you can tell us. Has the category got linked products for example ?

[philip937]

A zen site running 1.5.1 is using a link checker to verify his site's link and on the following urls,

http: //Domain.com/index.php?main_page=products_all&disp_order=1&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_all&disp_order=1&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=21
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=22
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=23

mostly happening on Category[]=19, 20, 21, 22, & 24

he is getting the following warning on lower left hand corner of the page. And the page shows the header info, left category box and the rest is white.

WARNING: An Error occurred, please refresh the page and try again.
Page displays the same when page is refreshed.

It seems to be coming from the dynamic filter. On this site when selecting New Products or All Products and clicking on any of categories 19, 20, 21, 22, 23 & 24.

Any one with any ideas?

What happens if you manually replace the [] with %5B%5D

On my site I don't appear to have the [] it posts the %5B%5D value instead

Also are you using links or check boxes?

[Kevin205]

Hey Phil when I use the filter this appears [].

I tried using %5B%5D and it goes back to [].

This is crazy.