In Progress

Cant reindex Product attributes after Magmi CSV import

Hi freelancer,

im desperate to find solution to SQL error showing while trying to re-index Product attributes in Magento after CSV file import via Magmi.

Error scenario:

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[23000]: 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.

Skills: Magento, MySQL, PHP

See more: csv magmi, next exception zend_db_statement_exception message sqlstate 23000, magmi price import error, magmi problem, magmi import script, magmi reindex script, magmi reindex problem, cant reindex product attributes magmi csv import magento, tips on freelancer, tips freelancer, pdo website, hint freelancer, freelancer zend, freelancer with magento 2, freelancer tip, freelancer statement, freelancer product, freelancer magento price, freelancer home products, freelancer fix price, freelancer 4.85, finding freelancer it, db freelancer, csv freelancer, php pdo

About the Employer:
( 29 reviews ) Rimavska Sobota, Slovakia

Project ID: #4402317

Awarded to:


Ready to start now

€100 EUR in 1 day
(18 Reviews)

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

€250 EUR in 5 days
(89 Reviews)

Hi, We're ready to take up your project. Kindly check PMB for more details. Awaiting your kind response.

€144 EUR in 3 days
(13 Reviews)

please check the [url removed, login to view]

€105 EUR in 2 days
(29 Reviews)

Hi, I can do it for you. Let me do it. Thanks.

€100 EUR in 3 days
(13 Reviews)

Hi, Please check your private message board . Thanks Sam

€103 EUR in 12 days
(3 Reviews)

Hi I can do this work. Ready to start.

€120 EUR in 3 days
(2 Reviews)