MDVA-34665: bundle products disappear storefront category page

The MDVA-34665 patch fixes the issue with missing bundled products on category pages. This patch is available when the Quality Patches Tool (QPT) 1.0.21 is installed. The patch ID is MDVA-34665. Please note that the issue was fixed in Adobe Commerce version 2.4.3.

Affected products and versions

The patch is created for Adobe Commerce version:

Adobe Commerce on cloud infrastructure 2.3.4-p2

Compatible with Adobe Commerce versions:

Adobe Commerce on-premises and Adobe Commerce on cloud infrastructure 2.3.4-2.3.4-p2

NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your Adobe Commerce version, update the magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.

Issue

Case 1:

Prerequisites:

  1. Create 15,000 bundled products with one simple product as a bundle option. Do not use the same simple product with multiple bundled products.
  2. Simple products should be set to Not visible individually.

Steps to reproduce:

  1. Assign 15k bundled products into two categories, 7,500 each.
  2. Select all simple products (15k) and update the stock using product mass attribute updates. Our goal is to have many ids in the search cl table (cl tables are the tables that are used by the indexer to know which records need to be updated.)
  3. Make sure you have 15K ids in the catalogsearch_fulltext_cl table.
  4. Make sure the indexer_update_all_views indexer is executed.
  5. Query the category page continuously and observe the product count.

Expected results:

The product count should remain as it was after the reindexing.

Actual results:

The product counts drops to 7,450 after a while. It remains in 7,450 even after the indexing is finished.

Case 2:

Steps to reproduce:

  1. Create a bundle product with an associated simple product as an option.
  2. Change the indexer modes to update on schedule.
  3. Assign the bundle product to a category.
  4. Change the stock status of the simple product to out of stock.
  5. Execute cron; the bundle product disappears from the storefront.
  6. Add stock back to the simple product and save.
  7. Execute cron indexer.
  8. Refresh the category page.

Expected results:

The product is still absent.

Actual results:

Bundle product reappears.

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

To learn more about Quality Patches Tool, refer to:

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

recommendation-more-help
8bd06ef0-b3d5-4137-b74e-d7b00485808a