Product Tier Price add/update in Magento

Magento has strong features to set Tier price. If you are interested to set multiple prices of a product for combination of customer group and product quantities, you can set by Magento Tier price option.

We can handle tier price in many ways. Here I am describing basic logic to add/update tier price in modular way. At first define all tier prices as an array. Ofcourse mind one thing about quantity. Quantity format must be four decimal precision. Like 100.0000. For this you can use below formatting.

$qty = number_format($qty, 4, ‘.’, ”);

//Define tier price as an array
$tierPrices[] = array(
		     'website_id'  => 0,
		     'cust_group'  => $customer_group_id,
		     'price_qty'   => $qty,
		     'price'       => $price 
		   );

Ex.
$tierPrices[0] = array(
		     'website_id'  => 0,
		     'cust_group'  => 1,
		     'price_qty'   => 100.0000,
		     'price'       => 12.0000 
		   );

$tierPrices[1] = array(
		     'website_id'  => 0,
		     'cust_group'  => 2,
		     'price_qty'   => 100.0000,
		     'price'       => 10.0000 
		   );


//get productid for corresponding SKU.
$productid = Mage::getModel('catalog/product')
                  ->getIdBySku($sku);

// Initiate product model 
$product = Mage::getModel('catalog/product');

// Load specific product whose tier price want to update
$product ->load($productid);

// take existing tier prices of that product
$existingTierPrice = $product->tier_price;
		
// Marge existing and new tier prices to update
$tierPrices=array_merge($existingTierPrice,$newTierPrices);
		
// Assign all tier prices to product's tier_price object
$product->tier_price = $tierPrices;

// Save you product with all tier prices
$product->save(); 

Also Magento has web service API support to handle tier price. If you are expert in web service work then you can do the same thing using Magento API. To handle tier price with api call do something like below.

$proxy = new SoapClient('http://127.0.0.1/magento/api/soap/?wsdl');
$sessionId = $proxy->login('apiUser', 'apiKey');
 
// Get tier prices
$tierPrices = $proxy->call($sessionId, 'product_tier_price.info', 'Sku');
 
// Add new
$tierPrices[] = array(
    'website'           => 'all',
    'customer_group_id' => 'all',
    'qty'               => 68,
    'price'             => 18.20
);
 
// Update tier prices
$proxy->call($sessionId, 'product_tier_price.update', array('Sku', $tierPrices));

Advertisement