MDVA-28202 Magento patch: out of stock products don't filter properly

The MDVA-28202 patch solves the issue where out of stock products aren't filtered properly using Price filter on a Magento store frontend. This patch is available when the Quality Patches Tool (QPT) v.1.0.6 is installed.

Affected products and versions

• The patch was designed for Magento Commerce Cloud 2.3.5-p1.
• The patch is also compatible with Magento Commerce and Magento Commerce Cloud 2.3.4 - 2.4.1.

Note: the patch can be applicable to other versions with new QPT tool releases. To check if the patch is compatible with your Magento version, run ./vendor/bin/magento-patches status

Issue

Out of stock products do not filter properly using Price filter in Magento Admin.

Prerequisite:

• Set Display Out of Stock Products = " Yes " under Stores > Configuration > CATALOG > Inventory > Stock Options .

Steps to reproduce:

1. Create a configurable product with two simple products (Example: set Price = $1500 ).
2. Both simple products should "out of stock" while creating the configurable product.
3. Assign this configurable product to a category.
4. Reindex and check catalog_product_index_price table using entity id of the above configurable product.
5. Save all the product prices = $0 .
6. Load the category and confirm the availability of the product.
7. Open the Price filter from layered navigation.
8. Notice that the Price filter has an option of " $0.00 - $9.99 ".
9. Click on this above Price filter option and set the Price = $1500 , and you will get the configurable product we created above.

Expected result:

The product filters under the correct price range as expected.

Actual result:

The product falls under wrong price range filter.

Apply the patch

To apply individual patches use the following links depending on your Magento product:

• Magento Commerce: DevDocs Apply patches using Quality Patches Tool .
• Magento Commerce Cloud: DevDocs Upgrades and Patches > Apply patches .

Related reading

To learn more about Quality Patches Tool, refer to:

• Quality Patches Tool released: a new tool to self-serve quality patches .
• Check if patch is available for your Magento issue using Quality Patches Tool .

For info about other patches available in QPT tool, refer to the Patches available in QPT tool section.

To learn more about configurable products, refer to this DevDocs article:

• Create a configurable product tutorial