Just a quick note for myself. If we need to find duplicated values for a specific attribute (in this case attribute “taxvat” for the entity “customer” (for Magento 1):

  • First of all, we need to know the attribute id of our attribute code:
select attribute_id,attribute_code from eav_attribute where attribute_code = 'taxvat';
  • And then we execute the following query to find all the entries that are duplicated:
select value, count(*) c from customer_entity_varchar where attribute_id = '15' group by value having c > 1;

Categories: Development


Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.