Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    I need Magento import expert - SQLSTATE[23000]: Integrity constraint violation: 1452

    - or -

    Post a project like this
    24/03/2017
    $$$
    • Posted: 6 years ago
    • Proposals: 17
    • Remote
    • #1471142
    • Expired
    David A.
    David A.
    Magento, Shopify, Wordpress Ecommerce Developer
    Top Endorsed
    United Kingdom Nottingham
    Vigneshprabu C.
    Vigneshprabu C.
    Top Seller - Full Stack Developer | Web Developer and Designer, Magento, Shopify, CS-Cart, WordPress, OpenCart, Big commerce, PSD to Responsive Design, Bootstrap etc..
    Top Endorsed
    United Kingdom Leicester
    Satya B.
    Satya B.
    Wordpress |Magento|ExpressionEngine|Joomla|Drupal|AJAX|Responsive expert
    Top Endorsed
    India Jaipur
    Muhammad Shiraz K.
    Muhammad Shiraz K.
    Magento Certified Developer | eCommerce Developer | Shopify Developer | Graphic Designer | Wordpress Developer | Website Designer
    Top Endorsed
    United Kingdom London
    Exploreweb Store
    Exploreweb Store
    UK's #1 Magento 2 | Wordpress | Shopify | PHP | eBay Developer & Graphic Designer
    Top Seller with earnings over £100kTop Endorsed
    United Kingdom Bradford
    I-Verve I.
    I-Verve I.
    Full-Stack Web & Mobile Experts
    Top Endorsed
    India Ahmedabad
    Nimesh P.
    Nimesh P.
    Magento 2, WordPress, Laravel, Shopify Full Stack Developer
    Top Endorsed
    India Ahmedabad
    Advanced W.
    Advanced W.
    Website Design, Developer, Magento and Joomla Expert.
    Top Endorsed
    United Kingdom Midlands
    Jitendra S.
    Jitendra S.
    Web and app developer and designer
    India Jaipur
    Megha C.
    Megha C.
    Magento & Magento2 & Wordpress Developer
    Top Endorsed
    India Surat
    Srinath madusanka K.
    Srinath madusanka K.
    Magento , WordPress Expert
    Top Endorsed
    Sri Lanka Galle
    Malik D.
    Malik D.
    Sr. Android Software Engineer
    Pakistan Lahore
    • 1
    • 2
    73075957381438911707302041022132672171695036931257457128438413021421398539
    David A.Vigneshprabu C.Satya B.Muhammad Shiraz K.Exploreweb Store + 12 others have already sent a proposal.
    • 2
    • 2

    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:
    Lewis L.
    Lewis L.
    98% (37)
    Projects Completed
    58
    Freelancers worked with
    52
    Projects awarded
    40%
    Last project
    13 Nov 2020
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

    • 24 Feb 2017Thanassis Z.

      Can we see the structure of the csv pls ?

    • 23 Feb 2017David B.

      Are you in a rush or flexible on deadline?

    • 22 Feb 2017TSOLUTIONS

      Lewis

      Issue is on the CSV, there is an attribute.

      Can you upload the CSV file?

    • 22 Feb 2017Sufi S.

      Hi Lewis,
      Have you found someone for this fix ?

    337625336466335629335562
    24/03/2017
    $$$

    - or -

    Post a project like this
    Lewis L.
    Lewis L.
    98% (37)
    Projects Completed
    58
    Freelancers worked with
    52
    Projects awarded
    40%
    Last project
    13 Nov 2020
    United Kingdom

    Related project Searches


    structured query language (sql) magento (cms) comma separated values(csv) content management system development (cms development) database e-commerce development image ms-dos Unicode Transformation Format (UTF/ UTF8/ UTF16)

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    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