For the past couple of weeks I have been trying to get my head around how Magento is working. I have made good progress and I am now facing a re-occuring error that has cropped up on the forums before and as of yet I have not found an actual solution to.
I am using Import from excel. If I add about 200 products to the file and then import them I am seeing the error below when the Import trys to run.
SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`*****`.`mg_catalog_product_option_type_value`, CONSTRAINT `FK_mg_CAT_PRD_OPT_TYPE_VAL_OPT_ID_mg_CAT_PRD_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `mg_catalog_product_option`)
Is there a known fix for this please? Its holding up my publishing of my website and I am keen to find out whats causing this.