While trying to import custom options for product throws the below error. Please provide me a solution

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4953' for key 'PRIMARY', query was: INSERT INTO catalog_product_option_type_value (option_type_id,sort_order,sku,option_id) VALUES (?, ?, ?, ?), (?, ?, ?, ?), (?,


Error is "Integrity constraint violation: 1062 Duplicate entry '4953'".

So, there is already entry exist with value '4953' for "option_id" column on table "catalog_product_option_type_value". To resolve this error please remove entry with value '4953' from DB and try again with import new value.

Might be this solution will help.


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.