Layered Navigation Showing wrong price filter after upgrade M 2.1.4 to 2.2.5

[jayanta88]

Related issue magento/magento2#15654

Steps to reproduce

1. upgraded Magento 2.1.4 database with Magento 2.2.5 installation.
2. Then added a custom theme. Nothing Major.
3. You can see price filter is not showing correct data in the layered navigation.

Expected result

1. It should show the correct price filter.

Actual result

[Screenshot, logs]

[victor-v-rad]

Hi @jayanta88

I was able to reproduce this issue on vanilla Magento 2 by creating configurable products with custom option which has negative price in Layered Navigation. It means the issue is in Magento 2 code base and not in the tool

[sarjangautam]

I also had negative price in price index table for configurable products and this was happening because of Magento1 product price data for config products. In M1 , we used to store price data for config products and when we migrated that data to M2 those M1 price were carried over to M2. After reindexing i used to get negative price in the index table for config products. Since we do not need price for config products in M2 as M2 should calculate the config price based on simple products price i removed the config product price from catalog_product_entity_decimal table and reindexed. After that i no longer have negative price in price index table.

But i still have issue with price filter . Price filter is showing invalid range for certain category (e.g $0 - $200) . I do not any products with $0 price in that category and max price in $500 not $200.