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.

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:

• Adobe Commerce or Magento Open Source on-premises: Software Update Guide > Apply Patches in our developer documentation.
• Adobe Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in our developer documentation.

Related reading

To learn more about Quality Patches Tool, refer to:

• Quality Patches Tool released: a new tool to self-serve quality patches in our support knowledge base.
• Check if patch is available for your Adobe Commerce issue using Quality Patches Tool in our support knowledge base.

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