I need to write my own mysql query, where I need to use the attribute Position in the query. But I can not see which table is attribute Position stored in. In my *eav_attribute* table, the attribute Position has attribute_id 56. I have tried to look at the table catalog_product_entity_int, but no attribute_id equals to 56. I wonder which table else could contain the product Position value?

And the possiton attribute I'm taling about is as in this screenshot.

enter image description here


You can find the positions of category products in table catalog_category_product

You can also see more fields like category_id and product_id as well which means which product is assign with which category with position.

| improve this answer | |
  • Thanks. I found it now. I can first accept your answer after 10 minutes. I wonder if theres any good ways to search for a Magento attribute in database? or you just need to know where it is located? – Magento Learner Aug 21 '18 at 11:23
  • You need to know the database architecture and also the eav structure of magento then only you can find the tables very easily. – Sukumar Gorai Aug 21 '18 at 11:25

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.