Skip to content

Magento 2 : When creating a product – Cannot add or update a child row: a foreign key constraint fails?

When creating a product, it throws this error SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`vbm`.`catalog_product_entity`, CONSTRAINT `FK_CAT_PRD_ENTT_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE), query was: INSERT INTO… Read More »Magento 2 : When creating a product – Cannot add or update a child row: a foreign key constraint fails?

Magento 2.4.6 calling createOrder() causes exception with elasticsearch

In one of my scripts, calling createOrder() ( from vendor/magento/module-sales/Model/AdminOrder/Create.php ) causes an exception: {“error”:{“root_cause”:[{“type”:”action_request_validation_exception”,”reason”:”Validation Failed: 1: id is missing;”}],”type”:”action_request_validation_exception”,”reason”:”Validation Failed: 1: id is missing;”},”status”:400} I’m very confused at these results. Any thoughts? The rest of the exception text: #0… Read More »Magento 2.4.6 calling createOrder() causes exception with elasticsearch

Blank fields in csv product export

I’m trying to export around 6500 products through a csv file and importing it onto another e-commerce platform. However there are blank columns which is interfering with the import. Why are their blank fields?