I would like to list all attributes options that our products don't uses. I prefer to use SQL to do that to learn how to work with.

Right now i use this query to get the ID of my attributs

select * from eav_attribute where attribute_code = 'color_shoes';

After i list all the attributes options with this query.

select * 
from eav_attribute_option eao
join eav_attribute_option_value eaov on eao.option_id = eaov.option_id
where attribute_id = 2294
and eaov.store_id = 1;

It's here where i dont know to fetch all product based on the current list of attributes options.

What is the relation between EAV tables and Catalog product? right now in the 'catalog_product_entity' table, i have a ATTRIBUTE_ID column but there's no product with attribute_id = 2294.

Someone have hint where i need to look for?


I think you should review the EAV structure tutorials.




Still, you required any help, let me know.

Hope this will help you.

| improve this answer | |
  • thanks, i will check your link, i hope this will help. – Stéphane Baribeau Sep 25 '19 at 20:30
  • @StéphaneBaribeau Please accept this as an answer, so it will help to someone else. – Nits Sep 26 '19 at 10:38
  • no problem, i will contact you after my test to see if everything is ok! thanks – Stéphane Baribeau Sep 26 '19 at 14:03
  • Welcome @StéphaneBaribeau – Nits Sep 26 '19 at 16:52

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.