{"data":{"id":"ACP2E-5009","source":"qpt","sourceRef":"magento/quality-patches@1.1.85","title":"Fixes the issue where data migration from Magento Open Source to Adobe Commerce does not correctly migrate category scheduled design changes and product Special Price scheduled updates, causing some scheduled updates to be missing or skipped during migration, and improves migration performance.","categories":["Content","Performance"],"components":["magento/module-catalog-staging"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-84/acp2e-5009","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-84/acp2e-5009.md","blobSha":"ee2729f1a6fc938ed97ecb5edffa671de72e159a","description":"The data patch that migrates Magento Open Source category and product dates to Content Staging scheduled updates in Adobe Commerce creates empty scheduled updates for categories, skips all product dates when empty date values remain from a previous run, and makes setup:upgrade very slow on catalogs with many categories and store views.","stepsToReproduce":"Migration from Magento Open Source: 1. On Magento Open Source, set Schedule Update From and To in the Schedule Design Update section of several categories. Leave To empty on some of them, and use both past and future dates. 1. On several products, set a Special Price with Special Price From and To in Advanced Pricing, and set Set Product as New From and To, using both past and future dates. 1. Install Adobe Commerce on this Magento Open Source database and run bin/magento setup:upgrade. 1. Go to Content > Content Staging > Dashboard and check the scheduled updates created for the categories and products. Open the categories and products and check their Scheduled Changes box. 1. Run the data patch again: remove it from the patch_list table (see Prerequisites), run bin/magento setup:upgrade, and check var/log/exception.log. Performance: 1. On Adobe Commerce, create 180 store views and 8,000 categories. 1. Run time bin/magento setup:upgrade and record the elapsed time. 1. Remove the data patch from the patch_list table (see Prerequisites) and run time bin/magento setup:upgrade again.","introducedInQpt":"1.1.84","createdFor":["2.4.8-p3"],"documentedRange":"2.4.5 - 2.4.9","scheduledFixRelease":"2.4.10"},"files":[{"package":"magento/magento2-ee-base","constraint":">=2.4.5 <2.4.10","path":"patches/commerce/ACP2E-5010_2.4.8-p3.patch","blobSha":"ece00c96e07b4a4e91b62f2a0aea4a2eeda18786","url":"https://raw.githubusercontent.com/magento/quality-patches/3610179336d510e38921cb84f6c8a8ea7d9b60b5/patches/commerce/ACP2E-5010_2.4.8-p3.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog-staging/Setup/CatalogProductSetup.php","change":"modified","package":"magento/module-catalog-staging"},{"path":"vendor/magento/module-catalog-staging/Setup/Patch/Data/MigrateCatalogProducts.php","change":"modified","package":"magento/module-catalog-staging"}],"packages":["magento/module-catalog-staging"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.9","2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8","2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6","2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.9","2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8","2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6","2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACP2E-5009 details"}