Integrity constraint violation while products import

Avatar
  • Answered
I am getting an error while importing products on my magento site. It says SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3246' for key 'PRIMARY',....

How do I resolve it?
Avatar
Arn
Hello,

Apologies for the problem with the product import into your database. Unfortunately, just about any ecommerce product has specific constraints concerning the databases that you are trying to add to. In this case, it appears that you are importing values that are causing a constraint violation because they are duplicates. You will need to review the products you're importing and make sure that the entries for that particular value are unique. This means they can 't be duplicated either in the existing table or in the data you're adding.

If you have any further questions or comments, please let us know.

Regards,
Arnel C.