ACSD-67643: Duplicate entries occur when creating scheduled updates for environments that have…

Categories

Catalog/Product

Components

magento/module-catalog

Origin

adobe-commerce-support

Since QPT

1.1.71

Issue

Duplicate entries occur when creating scheduled updates for environments that have a large number of nested categories.

Steps to reproduce

1. Generate sample data: Use a performance fixtures file (For example: small.xml) with modifications: Categories: 2,500 Products: 250,000 1. Run the following command: bin/magento setup:performance:generate-fixtures var/performance-toolkit/profiles/ce/small.xml 1. After creating products and categories, ensure all categories are anchors by running: UPDATE catalog_category_entity_int SET value = 1 WHERE attribute_id = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'is_anchor'); 1. Run a full reindex. 1. Log into the backend and open the Categories page. 1. Move Category 2 to Category 1 to increase tree nesting. 1. Go to the most nested category (For example: Category 2.1.1). 1. Create a Scheduled Update and save the category.

Adobe's page lists 2.4.8 - 2.4.8-p2 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

Adobe scheduled the permanent fix for 2.4.9.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-67643. On Cloud, add ACSD-67643 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-67643/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.

Patch files and compatible versions

Sources

• Adobe documentation for ACSD-67643
• JSON API: /api/v1/patches/ACSD-67643