Magento以编程方式添加层级价格，但使用自定义字段

Question

I have a problem about add product tier price by code. I did some research that there is a magento API that could be used to add tier price. However, since I have customized our magento and add a new field to the tier price, which is "production time", I don't know how to add tier price via API anymore.

Here is the sample code

$proxy = new SoapClient(Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB).'/api/soap/?wsdl');
$sessionId = $proxy->login('API user','API Key');
$tierPrices[] = array(
    'website'           => 'all',
    'customer_group_id' => 'all',
    'production_time    => $data[2],
    'qty'               => $data[3],
    'price'             => $data[4]
);
 try {
        $proxy->call($sessionId, 'product_tier_price.update', array($sku, $tierPrices));
    } catch (Exception $e) {
        $e->getMessage() . "
";
}

I will get an error says "invalid tier price".

Any idea why does it happen? or is there other ways to add tier prices?

Thank you.

Answer 1

Better than API where are not all the functions you can use standard Magento script, you only need to be placed anywhere in magento folder:

require("../../app/Mage.php");
Mage::init();

// Set an Admin Session
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
Mage::getSingleton('core/session', array('name' => 'adminhtml'));
$userModel = Mage::getModel('admin/user');
$userModel->setUserId(1);
$session = Mage::getSingleton('admin/session');
$session->setUser($userModel);
$session->setAcl(Mage::getResourceModel('admin/acl')->loadAcl());


foreach ($youritemlist as $item) {  


   $product = Mage::getModel('catalog/product')->loadByAttribute('sku',$item);  

    if(is_object($product)) {              


                $product->setTierPrice($yourprice);  
                echo "..(set)..";


                      $product->save();                          

                       echo "..saved
";                                      

      }; // end testing of product exist              


}; // enf foreach