Description of requirements/features: I've got a CSV of products that return the following SQL error on import. - Also attached as image.
SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`XXXXXXXX_XXXXXXXXX`.`cataloginventory_stock_item`, CONSTRAINT `FK_CATINV_STOCK_ITEM_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_i), query was: INSERT INTO `cataloginventory_stock_item` (`manage_stock`,`use_config_manage_stock`,`qty`,`min_qty`,`use_config_min_qty`,`min_sale_qty`,`use_config_min_sale_qty`,`max_sale_qty`,`use_config_max_sale_qty`,`is_qty_decimal`,`backorders`,`use_config_backorders`,`notify_stock_qty`,`use_config_notify_stock_qty`,`enable_qty_increments`,`use_config_enable_qty_inc`,`qty_increments`,`use_config_qty_increments`,`is_in_stock`,`low_stock_date`,`stock_status_changed_auto`,`is_decimal_divided`,`product_id`,`stock_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
I've tried tried removing all products already in the DB via SQL Truncate, and re-running the import with no luck.
It seems to import only the first 3800 products, regardless of what they are.
The CSV is saved in UTF-8, also tried MS-DOS CSV - Both with the same result.
Lewis L.98% (37)
Login to your account and send a proposal now to get this project.Log in
Clarification Board Ask a Question
Can we see the structure of the csv pls ?
Are you in a rush or flexible on deadline?
Issue is on the CSV, there is an attribute.
Can you upload the CSV file?
Have you found someone for this fix ?