Cant reindex Product attributes after Magmi CSV import
This project was successfully completed by honeydreams for €100 EUR in a day.Get free quotes for a project like this
Project Budget€30 - €250 EUR
Completed In1 day
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online