MDVA-30977: missing products from categories, indexing related

The MDVA-30977 patch fixes the issues with products displayed on storefront category pages during reindex or mass actions with a big number of products. This patch is available when the Quality Patches Tool (QPT) v.1.0.6 is installed. The issues are scheduled to be fixed in Adobe Commerce 2.4.2.

Affected products and versions

The patch was created for Adobe Commerce on cloud infrastructure 2.3.4. It is also compatible with Adobe Commerce on-premises 2.3.4.

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.

Issues

Issue 1

The number of products displayed on the category page on the storefront is different after each page reload during mass product update.

Steps to reproduce:

  1. Create at least 30000 products in two categories - at least 15000 products in each category.
  2. Go to Catalog > Products in the Commerce Admin.
  3. Select all products from the grid and perform a mass attribute update. For example, set New = Yes attribute.
  4. Run Magento cron job using the bin/magento cron:run command twice.
  5. Refresh category pages on Storefront while Adobe Commerce performs 30000 products update.

Expected result:

The number of products in categories is always 15000 on each category page refresh.

Actual result:

The number of products in categories is different on each category page refresh.

Issue 2

When the full reindex of the inventory is executed, category pages become empty and the We can’t find products matching the selection message is displayed.

Steps to reproduce:

  1. Configure Adobe Commerce with Elasticsearch.
  2. Add a new website.
  3. Create a new source and assign it to the new website using Manage stock.
  4. Create 30000 configurable products.
  5. Assign all the products to the new website and also add inventory to the new inventory source.
  6. Execute a full reindex.
  7. Execute the inventory reindex by running bin/magento indexer:reindex inventory
  8. Browse a category with big number of products.

Expected result:

Category pages display products as usual during reindex.

Actual result:

Category pages become empty during reindex.

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