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

Disabled product - where is this flag stored in the database? 
 
adityak
Member
 
Total Posts:  63
Joined:  2008-02-10
India
 

When a product is disabled, where is the value which signifies this stored in the database?

 
Magento Community Magento Community
Magento Community
Magento Community
 
adityak
Member
 
Total Posts:  63
Joined:  2008-02-10
India
 

In the table “catalog_product_status” status_id=2 signifies disabled, but in which table is the indicator that a particular product is disabled?

 
Magento Community Magento Community
Magento Community
Magento Community
 
nicolas46
Sr. Member
 
Total Posts:  210
Joined:  2008-04-09
Toulouse
 

with the eav model is sometime difficult to find the kind of think smirk

Look in ‘eav_attribute’ to find the attribute_id of the attribute ‘status’ (in my base is “69")
Next go in ‘catalog_product_entity_int’ and you will see the value of your’s product’s status (’attribute_id’="69" and ‘entity_id’ represent the product id)

 
Magento Community Magento Community
Magento Community
Magento Community
 
adityak
Member
 
Total Posts:  63
Joined:  2008-02-10
India
 

Thanks nicolas46 grin

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