Magento – Price filter in layered navigation not working correctly with price including tax in magento 2.2.3

layered-navigationmagento2.2.3

I am using magento-2.2.3. and showing prices including tax on product list page.

Now the issue is the price filter in layered navigation is considering prices excluding tax. So how to change the layered navigation logic for that?

I am using custom third-party extension for layered navigation, but the same issue also exists with the extension disabled.

This issue has been fixed in later magento versions, but due to some constraints, i cnt go with version upgrade.

For better understanding, check this screenshot.

When i set price to filter between 90-100, the products whose price including tax is 103 (i.e. > 100) are also shown in the result. the price in the layered navigation is not considering price including tax

Can anyone tell me how to implement the solution ?

Thanks in advance.

Best Answer

This issue exists in Magento, For more information.

rewrite this file.

<Vendor>/<Module>/Model/ResourceModel/Product/Indexer/Price/Configurable.php

protected function _applyConfigurableOption()
...
        $select->columns(
            [
                'min_price' => new \Zend_Db_Expr('io.min_price'),
                'max_price' => new \Zend_Db_Expr('io.max_price'),
                'tier_price' => 'io.tier_price',
                /*'min_price' => new \Zend_Db_Expr('i.min_price - i.orig_price + io.min_price'),
                'max_price' => new \Zend_Db_Expr('i.max_price - i.orig_price + io.max_price'),
                'tier_price' => 'io.tier_price',*/
            ]
        );
...

For more information, please see #7367

Related Solutions

Magento – Layered Navigation price filter attribute multiselect check box

One starting point can be this question on stackoverflow: Magento: textbox instead of multi select in layered navigation

Amasty's extension: Improved navigation solves your problem (quite popular extension).

Magento – Custom Attribute in Layered Navigation

There's an issue with app/Mage/Catalog/Model/Resource/Layer/Filter/Attribute.php

Swap out your class with the following and it problem should be solved.

class Mage_Catalog_Model_Resource_Layer_Filter_Attribute extends Mage_Core_Model_Resource_Db_Abstract
{
/**
 * Initialize connection and define main table name
 *
 */
protected function _construct()
{
    $this->_init('catalog/product_index_eav', 'entity_id');
}

/**
 * Apply attribute filter to product collection
 *
 * @param Mage_Catalog_Model_Layer_Filter_Attribute $filter
 * @param int $value
 * @return Mage_Catalog_Model_Resource_Layer_Filter_Attribute
 */
public function applyFilterToCollection($filter, $value)
{

    $filterSingleton = FilterSingleton::singleton();

    if (!isset($filterSingleton->return)) {

        $collection = $filter->getLayer()->getProductCollection();
        $attribute  = $filter->getAttributeModel();
        $connection = $this->_getReadAdapter();
        $tableAlias = $attribute->getAttributeCode() . '_idx';
        $conditions = array(
            "{$tableAlias}.entity_id = e.entity_id",
            $connection->quoteInto("{$tableAlias}.attribute_id = ?", $attribute->getAttributeId()),
            $connection->quoteInto("{$tableAlias}.store_id = ?", $collection->getStoreId()),
            $connection->quoteInto("{$tableAlias}.value = ?", $value)
        );

        $collection->getSelect()->join(
            array($tableAlias => $this->getMainTable()),
            join(' AND ', $conditions),
            array()
        );

        $filterSingleton->return = $this;

        return $this;

    } else {
        return $filterSingleton->return;
    }
}

/**
 * Retrieve array with products counts per attribute option
 *
 * @param Mage_Catalog_Model_Layer_Filter_Attribute $filter
 * @return array
 */
public function getCount($filter)
{
    // clone select from collection with filters
    $select = clone $filter->getLayer()->getProductCollection()->getSelect();
    // reset columns, order and limitation conditions
    $select->reset(Zend_Db_Select::COLUMNS);
    $select->reset(Zend_Db_Select::ORDER);
    $select->reset(Zend_Db_Select::LIMIT_COUNT);
    $select->reset(Zend_Db_Select::LIMIT_OFFSET);

    $connection = $this->_getReadAdapter();
    $attribute  = $filter->getAttributeModel();
    $tableAlias = sprintf('%s_idx', $attribute->getAttributeCode());
    $conditions = array(
        "{$tableAlias}.entity_id = e.entity_id",
        $connection->quoteInto("{$tableAlias}.attribute_id = ?", $attribute->getAttributeId()),
        $connection->quoteInto("{$tableAlias}.store_id = ?", $filter->getStoreId()),
    );

    $select
        ->join(
            array($tableAlias => $this->getMainTable()),
            join(' AND ', $conditions),
            array('value', 'count' => new Zend_Db_Expr("COUNT({$tableAlias}.entity_id)")))
        ->group("{$tableAlias}.value");

    return $connection->fetchPairs($select);
    }
}
class FilterSingleton {

static private $instance;

public $return = null;

    private function __construct() {

}

static public function singleton() {
     if (!isset(self::$instance)) {
        $c = __CLASS__;
        self::$instance = new $c;
    }

    return self::$instance;
}
}

visit:-http://islamic-posters.aceph.me/post/21851233473/magento-you-cannot-define-a-correlation-name

Best Answer

Related Solutions

Magento – Layered Navigation price filter attribute multiselect check box

Magento – Custom Attribute in Layered Navigation

Related Topic