Clever Geek Handbook

What is the relationship between entity_id and product_id

Looking back at the magento 1.5 schema, I cannot figure out how the product_id relates to the entity_id.

In all my test cases, I can check that product_id and entity_id are equal (same int). But I'm guessing it's a relationship somewhere, and although they are equal in my test cases, it's most likely just a coincidence, not something I should depend on.

In what tables or relationships can I find this link so that I can write a robust query.

I'm just looking for something like this ... it probably won't be that easy.

select entity_id from <wherever> where product_id = 1234
+3


source to share


1 answer


According to a Magento forum post from Magento team member, the entity_id on the EAV side is actually the same as the product_id on the product end of the catalog, so you go.



+7


source






More articles:


All Articles