I have a shop where some customer information is in the eav_attribute_option_value-table. now I want to truncate this table

2 Answers 2


simply run DELETE FROM eav_attribute_option_value in the your sql manager (PHPMyAdmin, adminer or directly)


you can run one of these queries

DELETE FROM eav_attribute_option_value

or directly truncate table.

TRUNCATE eav_attribute_option_value

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.