How to Update Group Price Programmatically Without Product Object Save

group-pricemagento-1.9

To save group price for the products, the following works for me.

$product->setData('group_price', $group_pricing_data);
$product->save();

However, it takes a while for mass updating products. The faster way to save only attributes via saveAttribute() does not seem to work on group price.

$product->setData('group_price', $group_pricing_data);
$product->getResource()->saveAttribute($product, 'group_price');

Is it because group_price is not EAV like the other attributes, and if so, is there any other way to just save only group pricing?

Best Answer

As far as I know, you can't simply update group price data using saveAttribute because it has a custom backend model, catalog/product_attribute_backend_groupprice.

When you load and save a product object, group price's custom resource mode does the work to load and save the data accordingly. If you look at Mage_Catalog_Model_Resource_Product_Attribute_Backend_Groupprice_Abstract, you will see the methods Magento uses to load and save group price data.

Specifically, savePriceData shows how to save the data properly. If you want a fast group price update, you can mimic what's done here. Check how $data looks like, and you have a good place to start.

Related Solutions

Magento – how to get product group price by customer group id, without logged in

Charlie.you can not get Customer group price from item`.

Here $item Mage_Sales_Quote_Item object and it not product object Mage_Catalog_Product .

So, you can not get group price from $item->getGroupPrice() and but you can only item price on here and using $item->getPrice() you can get Product cart price not group price.

Ifyou need to load product Object (Mage::getModel('catalog/product')) by product id($item->getProduct()->getId())

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 – how to get product group price by customer group id, without logged in

Magento – Saving product deletes tier price and group price

Related Topic