I need Magento import expert - SQLSTATE[23000]: Integrity constraint violation: 1452
- or -
Post a project like this$$$
- Posted:
- Proposals: 17
- Remote
- #1471142
- Expired
Top Rated and Well experienced - Full Stack Developer | Web Developer and Designer, Magento, Shopify, CS-Cart, WordPress, OpenCart, Big commerce, PSD to Responsive Design, Bootstrap etc..
Leicester
Laravel | CodeIgniter | Twilio | YII | Wordpress| React.Js (Sr. Software Engineer)
Chandigarh
UK's #1 Magento 2 | Wordpress | Shopify | PHP | eBay Developer & Graphic Designer
Bradford
Magento2 | word press| shopify| Laravel | SalesForce | Mobile App|Ionic | Swift | React Native
Jaipur
Magento Certified Developer | eCommerce Developer | Shopify Developer | Graphic Designer | Wordpress Developer | Website Designer
London
21326795738139853915179081438917307550369315373551520646204102680766170730
Description
Experience Level: Expert
General information for the website: Magento
Description of requirements/features: I've got a CSV of products that return the following SQL error on import. - Also attached as image.
SQLSTATE[23000]: 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.
Extra notes:
Description of requirements/features: I've got a CSV of products that return the following SQL error on import. - Also attached as image.
SQLSTATE[23000]: 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.
Extra notes:
Lewis L.
98% (43)Projects Completed
61
Freelancers worked with
54
Projects awarded
42%
Last project
20 May 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can we see the structure of the csv pls ?
-
Are you in a rush or flexible on deadline?
-
Lewis
Issue is on the CSV, there is an attribute.
Can you upload the CSV file? -
Hi Lewis,
Have you found someone for this fix ?
337625336466335629335562
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies