I am trying to find a value of one particular attribute for all products.

enter image description here

Some products have values for this attribute and I can see it here for example:

enter image description here

Where should I look for it in the database to find a product with this attribute's value?

1 Answer 1


I found the answer in table called catalog_product_entity_varchar by running a query:

SELECT * FROM `catalog_product_entity_varchar` WHERE `attribute_id` = 184

I hope someone will find this useful.

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.