{"data":{"id":"ACSD-47669","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes \"Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails\" error when importing products CSV.","categories":["Import/Export"],"components":["magento/module-catalog-import-export"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-38/acsd-47669-customizable-product-import-error","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-38/acsd-47669-customizable-product-import-error.md","blobSha":"21f2217b204b30d05dbdec8cadc10b1275b091d8","description":"There is an internal server error when importing products with customizable options.","stepsToReproduce":"1. Create an additional store view. Make sure you have 2 store views, e.g., en, UK. 1. Create two simple products, e.g., prod1 and prod2. 1. Prepare a csv file that adds custom options for both products in each store view and for the All Store View scope. Import this csv file. 1. Prepare another csv file that includes two records. The first record should be to update the custom options of 'prod1' specifically for the UK store view scope and the second record should be to update the custom options of 'prod2' for the All Store View scope. Import this second csv file.","introducedInQpt":"1.1.38","createdFor":["2.4.4-p1"],"documentedRange":"2.4.2 - 2.4.5-p4","scheduledFixRelease":null},"files":[{"package":"magento/magento2-base","constraint":">=2.4.2 <2.4.4","path":"patches/os/ACSD-47669_2.4.3-p3.patch","blobSha":"f2be41bb2c69a304c6647ef5bbaa3f8332931b16","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-47669_2.4.3-p3.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog-import-export/Model/Import/Product/Option.php","change":"modified","package":"magento/module-catalog-import-export"}],"packages":["magento/module-catalog-import-export"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2"],"magento-commerce":["2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false},{"package":"magento/magento2-base","constraint":">=2.4.4 <2.4.6","path":"patches/os/ACSD-54179_2.4.4-p1.patch","blobSha":"b4d0691337deb573d12cd5dd41d921314293490a","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-54179_2.4.4-p1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog-import-export/Model/Import/Product/Option.php","change":"modified","package":"magento/module-catalog-import-export"}],"packages":["magento/module-catalog-import-export"],"hasTests":false,"applicableVersions":{"magento-community":["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","2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"magento-commerce":["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","2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["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","2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2"],"magento-commerce":["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","2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-47669 details"}