Magento 1.7 – Programmatically Save Related Products

catalogevent-observermagento-1.7product

I need to set a particular product as related product for all the products.Here is the code that I've tried.

$product=$observer->getProduct();
$id=52;
$data=array(
            $id=>array(
                'position'=>2
            )
        );
$p=Mage::getModel('catalog/product')->load($product->getId());
$p->setRelatedLinkData($data);
$p->save();

But I get error

Fatal error: Maximum function nesting level of '100' reached,
aborting! in
/var/www/magento/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php
on line 205

Any pointers would be helpful.

Best Answer

Use catalog_product_save_before... and update the code so it doesn't end up in an infinite loop.

$product=$observer->getProduct();
$id=52;
$data=array(
            $id=>array(
                'position'=>2
            )
        );
$product->setRelatedLinkData($data);

Related Solutions

Magento – Restrict Number of Products in Collection and Modify Search Filters

Try this : Updated answer

config.xml

<config>
 . . . . . 
<global>  
        <blocks>
            <home>
                <class>Test_Home_Block</class>
            </home>
            <catalog>
                <rewrite>
                    <product_list>Test_Home_Block_Product_List</product_list>
                </rewrite>
            </catalog>
        </blocks> 
 . . . . . .
</global>
 . . . . . 
</config>

~\app\code\local\Test\Home\Block\Product\List.php

<?php
class Test_Home_Block_Product_List extends Mage_Catalog_Block_Product_List
{
     protected function _getProductCollection()
    {
        $collection = parent::_getProductCollection(); 
        $noOfItems = 5; // The number of items which you want to show.
        $count = 0;
        $myProductCollection = new Varien_Data_Collection();
        foreach($collection as $product)
        {
            if($count < $noOfItems) {
                $myProductCollection->addItem($product);
                $count++;
            } else {
                break;
            }
        }

        return $myProductCollection;
    }
}

Magento 1.8 – Uncaught Exception ‘PDOException’

The error message looks like your product is referencing an attribute_set_id which is not present in the database.

Take a look into your database into the table mage_catalog_product_entity, find your product and look for the column attribute_set_id. The number in there e.g. 4 should be present in the table mage_eav_attribute_set in the id column. If not, your product uses an attribute set which is not available any more.

This page kind of explains what attribute sets are: http://inchoo.net/magento/importance-of-planning-attribute-sets/

One remark: Your code totally works around the framework, there might even be some security issues. (using POST, header()). You're also updating stock data. Magento does that when the customer actually finishes the checkout process, there's no need to do it manually.

Best Answer

Related Solutions

Magento – Restrict Number of Products in Collection and Modify Search Filters

Magento 1.8 – Uncaught Exception ‘PDOException’

Related Topic