0

When I upload CSV file it gives 0 error. After this I click on import button. It gives following error:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (magentostore_dbname.catalog_product_entity_media_gallery, CONSTRAINT FK_CAT_PRD_ENTT_MDA_GLR_ATTR_ID_EAV_ATTR_ATTR_ID FOREIGN KEY (attribute_id) REFERENCES eav_attribute (attribut), query was: INSERT INTOcatalog_product_entity_media_gallery (attribute_id,entity_id,value) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATEentity_id= VALUES(entity_id`)

enter image description here

Does anyone know, how to solve it?

  • seems like you are using Magento default import/export , best option is to go fro magmi to upload products..... – Baby in Magento Jun 28 '17 at 7:06
  • Can you post a sample of the csv? maybe with the line that does not import. – Marius Jun 28 '17 at 7:21
  • csv is work fine in 1.9.3.1. After upgrade to 1.9.3.3 CE it gives error. Single product is not upload with csv. – Chirag Parmar Jun 28 '17 at 9:02
  • @ChiragParmar please update this information in question..... – Baby in Magento Jun 29 '17 at 5:45
0

I solved it. Just put one column in csv. I set value "88" to "_media_attribute_id" enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.