Magento – Get tiered price by customer group id

customer-groupmagento-1.9tierprice

I'm writing a maintenance script to tidy up unused customer group tiered prices. How can I programatically get either:
All products that have a tiered price for the selected customer group and then delete the tiered price for that group
OR
Check if a product has a tiered price for the selected customer group and then delete the tiered price for that group.

Bear in mind I don't know the quantity, only the group id so I can't use getTierPrice() as that needs a quantity.

How do I delete the tiered price? Can I just use setTierPrice() and set the price and quantity to 0?

Best Answer

$roleId = Mage::getSingleton('customer/session')->getCustomerGroupId();
$TierPrice = $product->getData('tier_price');
$customer_grouptier = array_column($TierPrice, 'price','cust_group');
$customer_tier = $customer_grouptier[$roleId];

$product is the product Object.

More information click below. Getting Current Customer Group Price, and Tier Price

Related Solutions

Magento – Multi Select Customer Group Promotion Price Rules Not Applied

CustomerGroup is a select field and I'm sure everywhere is checked for ONE value.

e.g. here \Mage_SalesRule_Model_Validator::init

this means, everywhere where magento expects (int)7 you pass either (array) [0] => (int) 1, [1] => (int) 2, [2] => (int)3 or (string)1,2,3,4 and both is wrong.

Magento is not built to use more than one customer group and you can change this setting, then it may work on some places, but on MOST places you get a lot of problems.

TL;DR You want to invest a lot of money to fix all problems or just revert/let it as it is.

Magento – Saving product deletes tier price and group price

you should never call save without calling load first on a product instance.
A save without a load (on a product from a collection for example) will lead to loss of data.
If you only want to update a single attribute value for a product do this:

Mage::getSingleton('catalog/product_action')->updateAttributes(
    array($attributeId),
    array('attribute_code' => 'attribute_value'),
    $storeId
);

$storeId is the storeview for which you want to update the value. For default values use 0.

Best Answer

Related Solutions

Magento – Multi Select Customer Group Promotion Price Rules Not Applied

Magento – Saving product deletes tier price and group price

Related Topic