Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Insights on columns of catalog_product_entity table
 
srinigenie
Guru
 
Avatar
Total Posts:  539
Joined:  2008-02-04
 

Dear all,

I am trying some denormalization to quicken my search process and was examining the catalog_product_entity table columns and conjured the below meanings
entity_id - Identifier of the product
entity_type_id - Would this not always be the catalog/product?? Would this column store any other value
attribute_set_id - Attribute set attached to the product
parent_id - Not sure when this is used?
store_id - Observed that this always stores the ID=0 which is the default store. Tried adding a new
website, web store and store views and found this to store only the record for the default
website. Is this required at all??
type_id - Simple product or Configurable Product or Grouped Product
sku
created_at
updated_at
is_active - Enabled / Disabled

I am looking for more information on the “store_id” column.

Thanks in advance

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top