{"data":{"id":"ACP2E-4522","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where an intermittent duplicate key error occurs on the quote_coupons table when multiple cart merge or quote save requests run at the same time.","categories":["Shopping Cart"],"components":["magento/module-multicoupon"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-78/acp2e-4522","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-78/acp2e-4522.md","blobSha":"7fa826ff22e0796c9056041e746b68bcbbeda272","description":"An intermittent duplicate key error occurs on the quote_coupons table when multiple cart merge or quote save requests run at the same time.","stepsToReproduce":"1. Enable the maximum number of coupons per order = 10 under the Admin sidebar at Stores > Settings > Configuration > Sales > Multicoupon Settings. 1. Create a Cart Price Rule under Marketing > Promotions > Cart Price Rules > Add New Rule: 1. Rule Name: TESTCOUPON2026 1. Active: Yes; Websites: Main Website; Customer Groups; Select all applicable groups. 1. Coupon: Specific Coupon; Coupon Code: TESTCOUPON2026. 1. Uses per Customer: leave blank. 1. Conditions: No conditions added. 1. Actions > Percent of product price discount; Discount Amount = 10. 1. Add a product with a quantity of at least 7 to a guest cart using GraphQL, and then apply the coupon. 1. Run six concurrent parallel GraphQL mergeCarts calls: mutation { mergeCarts( source_cart_id: \"<GUEST_CART_ID>\" destination_cart_id: \"<DESTINATION_CART_ID>\" ) { id items { id product { sku } } applied_coupons { code } } }","introducedInQpt":"1.1.78","createdFor":["2.4.7-p7"],"documentedRange":"2.4.7 - 2.4.8-p4","scheduledFixRelease":"2.4.9"},"files":[{"package":"magento/magento2-ee-base","constraint":">=2.4.7 <2.4.9","path":"patches/commerce/ACP2E-4522_2.4.7-p7.patch","blobSha":"2c1833f08f5a0e5ef5b3773e9bd1e0a98b0d0dc3","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACP2E-4522_2.4.7-p7.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-multicoupon/Model/ResourceModel/Quote/AddCoupons.php","change":"modified","package":"magento/module-multicoupon"}],"packages":["magento/module-multicoupon"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["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"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"magento-commerce":["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"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACP2E-4522 details"}