Hello I would like to set the Description for magento products using data collected from Amazon api. I am calling the API and would like to get the xml response into magento description. I have some code prepared which works:

 require_once ('../app/Mage.php');

 //Create API access object
 $public_key = '*************';
 $secret_key = '*************';
 $associate_tag = '**********-21';
 $amazon_api = new AmazonAPI($public_key, $secret_key, $associate_tag);

$products = Mage::getModel('catalog/product')

//Array of request parameters
foreach($products as $product)
$asin = $product->getAsin();
$product->getResource()->saveAttribute($product, 'description');
$params_array = array(
'Operation' => 'ItemLookup',
'IdType' => 'ASIN',
'ItemId' => $asin ,
'ResponseGroup' => 'Tracks');

// returns a list of items for the search query 'Slow Magic'
$response = $amazon_api->sendRequest($params_array);

foreach ($response as $restponse)

echo '<pre>';
echo '</pre>';

foreach($parsed_xml->OperationRequest->Errors->Error as $error){
 echo "Error code: " . $error->Code . "\r\n";
 echo $error->Message . "\r\n";
 echo "\r\n";

The code is correct the only problem with is the response, the error I am getting in the logs is:

Object of class stdClass could not be converted to string Object of class stdClass could not be converted to string.

Any how to convert to a string?

  • 2
    You have a typo in your code ->addAttributeToSeleXct('asin') where it should be ->addAttributeToSelect('asin') – Raphael at Digital Pianism Feb 10 '16 at 13:49
  • Thank you , I've must of typed it in as I was copying the code over – Bako Gdaniec Feb 10 '16 at 13:54
  • Just change Mage::app(); to Mage::app('admin'); and check what happen! – Amit Bera Feb 10 '16 at 13:58
  • Everything stays the same after I've placed 'admin' . Still no change in product – Bako Gdaniec Feb 10 '16 at 14:03
  • Can u please tell why u use ->load($productId); – Amit Bera Feb 10 '16 at 14:19

Try to use instead


to this code

 $product->getResource()->saveAttribute($product, 'description')
  • Zmage,Good answer – Amit Bera Feb 10 '16 at 14:16
  • Unfortunately , there is no difference in the product description . However the code looks more correct. – Bako Gdaniec Feb 10 '16 at 14:25
  • This is the error that I am getting in the logs : Recoverable Error: Object of class stdClass could not be converted to string in /var/www/html/lib/Varien/Db/Adapter/Pdo/Mysql.php on line 3074 – Bako Gdaniec Feb 10 '16 at 14:51

The real problem here is that you're trying to load a collection like if it was a single product:

$products = Mage::getModel('catalog/product')

You do not need to do so, simply do:

$products = Mage::getModel('catalog/product')
  • Thank you however this doesn't solve the problem as the products are not being updated. – Bako Gdaniec Feb 10 '16 at 13:56
  • Could try adding Mage::log($product->getData()); at the start and the end inside your foreach loop and compare both results please (paste them in your questio if necessary) – Raphael at Digital Pianism Feb 10 '16 at 13:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.