Dynamic Filter [Support Thread]

[Design75]

Is there a way to control the display of prices in the filter,
instead of


to the following,
$25 -- $50
$51 -- $75
$76 -- $100
$100 and over

Not that I know of. It would be useful :)
Also keep in mind that the price used/shown in the filter is the one without tax/vat.

[philip937]

Not that I know of. It would be useful :)
Also keep in mind that the price used/shown in the filter is the one without tax/vat.

cant you set the price limits in the admin settings for dynamic filter?

[Kevin205]

I don't think you can.

[philip937]

I don't think you can.

Maximum Number of Price Ranges ??

[Design75]

Maximum Number of Price Ranges ??

Yes you can, but on the front end the box is showing the ranges in prices excluding tax. So you get price ranges that make no sense.

[flernebunu]

Hi ,
I've just noticed after introducing manufacturers the following error for dynamic filter:
[05-Apr-2013 20:37:49 UTC] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 'Y', 'N') as flag FROM manufacturers WHERE manufacturers_id IN (1,2) ORDER BY' at line 1 :: SELECT manufacturers_id, manufacturers_name, IF(manufacturers_id IN(), 'Y', 'N') as flag FROM manufacturers WHERE manufacturers_id IN (1,2) ORDER BY manufacturers_name in C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php on line 120

Anyone knows how to fix it?
The code is here:
$manufacturers = $db->Execute("SELECT manufacturers_id, manufacturers_name, IF(manufacturers_id IN(" . implode(',', $filteredManufacturers) . "), 'Y', 'N') as flag" .
" FROM " . TABLE_MANUFACTURERS .
" WHERE manufacturers_id IN (" . implode(',', $unfilteredManufacturers) . ")" .
" ORDER BY manufacturers_name");

[IKZAGHET]

My appologizes for my maybe incorrect English, i hope you will understand me.

I have a problem with the dynamic filter. As i understand, you made this filter.

The search by price option, are prices excluding VAT/TAX.

So with a search from 10 till 20, products above 20 (we have 21% tax). So a product with a price of 24 will be shown in the list 10 till 20.
We have been scripting a while now, but can't figure out how we can get to filter for prices including tax.
Is there a way to solve this problem?

[Kevin205]

Is there a way to control the display of prices in the filter,
instead of


to the following,
$25 -- $50
$51 -- $75
$76 -- $100
$100 and over

Not that I know of. It would be useful :)
Also keep in mind that the price used/shown in the filter is the one without tax/vat.

Has anyone resolved or addressed this issue?

[Design75]

Has anyone resolved or addressed this issue?

I think I solved the tax problem

In includes/templates/YOUR_TEMPLATE/sideboxes/tpl_dynamic_filter.php find

            if ($end < $max) $text = $currency_symbol . round($start * $conversion_rate) . ' -- ' . $currency_symbol . round($end * $conversion_rate);
            else $text = $currency_symbol . round($start * $conversion_rate) . ' and over'; 

and replace with

    if ($end < $max)
    {
      $text = $currency_symbol . round((zen_add_tax($start, $products_tax)) * $conversion_rate) . ' -- ' . $currency_symbol . round((zen_add_tax($end, $products_tax)) * $conversion_rate);
    }
    else
    {
      $text = $currency_symbol . round((zen_add_tax($start, $products_tax)) * $conversion_rate) . ' and over';
    } 

It works for me, but some further testing is needed, before releasing an update for this module

If this works, the next step is to replace the hard-coded text for language defines, to make this mod multilingual