Currently experiencing issue with layered Nav price filter. The price ranges are completely incorrect. Default filter is showing price range -10 to 395


Applying price range filter just seems to throw random products in the results.

Tried: Reindexing via CL Disabling Side bar extension (native magento side bar still having same issue) Checked price attribute setup in admin


  • Magento 2.2.0
  • PHP 7.1
  • Centos 7

Any hints appreciated

  • Migrated from Magento 1.9 using data migration tool – Nadroj467 May 31 '18 at 13:46
  • have u resolve the issue ? – Hafiz Arslan Oct 23 '19 at 11:58

I've seen this before.
This was caused in my case by configurable (it can happen from other composite products maybe) that had a price set.
In magento 2, configurable products should not have price related data. No price, no special price. They are all calculated from the prices of the simeple products.
In Magento 1, each product had a price and the configuration prices were relative to the price of the configurable product.
Because of this price for configurable products, the product price index calculates negative prices and they end up displayed in the frontend.
You can easily check in the db if there are configurable products with specified prices or special prices.

select attribute_id from eav_attribute where attribute_code in ('price', 'special_price');
//this should return 2 ids (let's say they are 75 and 76)
SELECT * FROM catalog_product_entity_decimal d
LEFT JOIN catalog_product_entity e ON d.entity_id = e.entity_id
WHERE d.attribute_id in (75, 76) AND
    d.value IS NOT NULL AND
    e.type_id = 'configurable';

Remove all the entries that you get, but please back up your database first.
After you are done, rerun the price index.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.