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

sql to remove associated products
 
dave stockmann
Jr. Member
 
Total Posts:  28
Joined:  2009-04-26
 

Does anyone know which table(s) are updated when a simple product is added to a configurable product?  I have many products that need to be removed as associated products from a configurable product.

I thought the catalog_product_super_link table was the correct table however, when I delete a record from that table, the association is still displaying.

Any thoughts?

 
Magento Community Magento Community
Magento Community
Magento Community
 
dave stockmann
Jr. Member
 
Total Posts:  28
Joined:  2009-04-26
 

Thanks!  I was looking at the wrong database (test vs prod) while doing my queries.  I was able to remove associated products by deleting rows from the catalog_product_super_link table.

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