im desperate to find solution to SQL error showing while trying to re-index Product attributes in Magento after CSV file import via Magmi.
1) have DB with no products
2) import some products via CSV file with Magmi importing script
3) try to reindex Product attributes via command line
4) during reindexing this error shows up:
Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '612-166-2-85
55' for key 'PRIMARY'' in /home/MY WEBSITE/public_html/lib/Zend/Db/Statement/[url removed, login to view]
I tried few basic tips and scripts found on internet which should find these duplicate entries but NOTHING helped.
I would be glad to find reason of this error and to fix it.
One possible hint: if I import first 10% of products then reindex is without error, but when I import all products from CSV file then error shows up - problem could be somewhere in Magmi CSV file
Please apply only if you have experience with Magmi!!!.
Suggested price for finding and fixing is around 100$ (by fixing I mean it should never happen again because source of error will be removed!). If great service is provided additional tip can be added.
I attached CSV file which is in question.
Thank you in advance,
looking for offers.
7 freelancers are bidding on average €132 for this job
Here are Magento Experts , please check Our Latest Magento work In PMB For Our Experience and skills Regarding Magento projects and Let me start your work , Thanks