I am trying to filter product collection by price range:
$this->getLoadedProductCollection()->clear() ->addAttributeToFilter('price', array( 'lt' => 500 ) ) ->addAttributeToFilter('price', array( 'gt' => 100 ) ) ->load();
this works fine however Magento uses price before tax to select the range and I would like to select by price after tax.
Is there a filter property, like 'price_after_tax' that contains this value? If not can somehow the current tax be calculated from the input range values? I could then calculate net price range.
Any other advice would be highly appreciated. Thanks!
- The only option for me is to deal with this issue programmatically, from module's level. I would rather not change Magento's configuration(product's are already uploaded, other custom modules installed).