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, ‘.’, ”);

01	//Define tier price as an array

02	$tierPrices[] = array(

03	'website_id'  => 0,

04	'cust_group'  => $customer_group_id,

05	'price_qty'   => $qty,

06	'price'       => $price

07

);

08

09

Ex.

10	$tierPrices[0] = array(

11	'website_id'  => 0,

12	'cust_group'  => 1,

13	'price_qty'   => 100.0000,

14	'price'       => 12.0000

15

);

16

17	$tierPrices[1] = array(

18	'website_id'  => 0,

19	'cust_group'  => 2,

20	'price_qty'   => 100.0000,

21	'price'       => 10.0000

22

);

23

24	//get productid for corresponding SKU.

25	$productid = Mage::getModel('catalog/product')

26	->getIdBySku($sku);

27

28	// Initiate product model

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

30

31	// Load specific product whose tier price want to update

32	$product ->load($productid);

33

34	// take existing tier prices of that product

35	$existingTierPrice = $product->tier_price;

36

37	// Marge existing and new tier prices to update

38	$tierPrices=array_merge($existingTierPrice,$newTierPrices);

39

40	// Assign all tier prices to product's tier_price object

41	$product->tier_price = $tierPrices;

42

43	// Save you product with all tier prices

44	$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.

01	$proxy = new SoapClient('http://127.0.0.1/magento/api/soap/?wsdl');

02	$sessionId = $proxy->login('apiUser', 'apiKey');

03

04	// Get tier prices

05	$tierPrices = $proxy->call($sessionId, 'product_tier_price.info', 'Sku');

06

07	// Add new

08	$tierPrices[] = array(

09	'website'           => 'all',

10	'customer_group_id' => 'all',

11	'qty'               => 68,

12	'price'             => 18.20

13

);

14

15	// Update tier prices

16	$proxy->call($sessionId, 'product_tier_price.update', array('Sku', $tierPrices));

→ 5 Comments

Posted in Magento Products

Tagged add tier price, Customer group price, Group Price, Magento Product, Magento tier price, Magento tier price update, Product price, product tier price, Tier price, Tier price api, update tier price