To change the Magento upsell product areas column count programmatically, use the following code:
|
1 |
$this->setColumnCount(4); |
Deleting upsell products directly in the database (Magento 1)
Once saved, upsell products can not be removed again easily. Using the following MySQL script, you can delete Magento upsell products from the database.
|
1 2 3 |
DELETE link.* FROM catalog_product_link AS link LEFT JOIN catalog_product_link_type AS linktype ON (linktype.link_type_id = link.link_type_id) WHERE linktype.code = "up_sell" and product_id = 123; |