Hi @ravi-chandra3197. Thank you for your contribution
Here is some useful tips how you can test your changes using Magento test environment.
Add the comment under your pull request to deploy test or vanilla Magento instance:

• @magento give me test instance - deploy test instance based on PR changes
• @magento give me 2.3-develop instance - deploy vanilla Magento instance

For more details, please, review the Magento Contributor Guide documentation.

Resolve this issue using single PR #24535, #15609, #14443

Negative prices in layered navigation #24535

Magento 2.2.4 Product sorting list by price on category page wrong when configurable product has special price set by mass action. #15609

Final min_price and max_price calculation on configurable product with special price #14443

The mentioned expression doesn't result in "0 - 0 + X" every time, i.price field contains base product price, but i.min_price field contains base price plus price of required custom options.
With those changes, minimal price of configurable product will not contain price of required custom options. As a result, minimal price will not be actual minimal price of configurable product and it will be inconsistent with minimal price of other product types.

The mentioned expression doesn't result in "0 - 0 + X" every time, i.price field contains base product price, but i.min_price field contains base price plus price of required custom options.
With those changes, minimal price of configurable product will not contain price of required custom options. As a result, minimal price will not be actual minimal price of configurable product and it will be inconsistent with minimal price of other product types.

Hello @dhorytskyi
in Magento2 there is no base price option for a configurable product, old expression conflict when the configurable product has a base price.
as a normal situation, the configurable product has no price option in M2 but when you migration with M1 Data it will create an issue.

step-1: create any configurable product in M1 set price and special price
step-2: perform migration in M2 so we get the same product in M2
step-3: run reindexing
step-4: check the 'catalog_product_index_price' table in the database it has a
negative value for configurable products.
in frontend filter by price not working as expected due to negative price

@akaplya, any chance you could review this? It would be great to get this resolved.

At least in my case this resolved the issue (#24535)

We are having the same issue - I thought it was because of M1 import but other items updated via api are also showing the issue .

This has been pending for 6 months now. Any chance this can be merged?

@magento run all tests

Hello @ihor-sviziev

I am working on failing integration tests

@ravi-chandra3197 will you be able to update your PR? Or maybe you have some questions / need some help?

@ihor-sviziev I have need help to fix integration tests.

@engcom-Charlie could you help with failing tests?

Hello @ravi-chandra3197, will try to help you with Integration Tests.

@engcom-Hotel make sure that these changes didn't break some functionality.

@magento run all tests

Hello @ravi-chandra3197 @ihor-sviziev.
I have checked the integration test and it is fine.
Unfortunately, the offered solution is not perfect. As a result prices calculation process doesn't work properly. It is quite risky optimization.

Risk: high since the configurable indexation process is affected

Looks like we have another PR that fixes the same issue. #26810

@ravi-chandra3197 will you be able to update your PR?

@ravi-chandra3197 I am closing this PR now due to inactivity.
Please reopen and update if you wish to continue.
Thank you for the collaboration!

Hi @ravi-chandra3197, thank you for your contribution!
Please, complete Contribution Survey, it will take less than a minute.
Your feedback will help us to improve contribution process.