Magento 1.7 - setting customer group price programmatically

magento

Solution

If you are actually using the magento object (not the api), these are the behaviors I have found. Hopefully the application makes sense, regardless of how you are acquiring the data.

// get my product 
$product = Mage::getModel('catalog/product')->load(x);
// the group data is expecting an array of arrays that look like.. 
// array ('website_id'=>y, 'cust_group'=>z, 'price'=>n)
$groupPricingData = array (
  // for website 2, customer group 2
  array ('website_id'=>2, 'cust_group'=>2, 'price'=>10),
  // for all websites, not logged in
  array ('website_id'=>0, 'cust_group'=>0, 'price'=>15)
);
$product->setData('group_price',$groupPricingData);
$product->save();

In this example, it would replace all previous group pricing for the product, so like wise.

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

will remove group pricing.

Another behavior I noticed related to setting the store id on the product you are updating will cause the group price to append. This way if you are uploading a bunch of group pricing for a specific store, you don't have to worry about loosing the group pricing set against another store.

// add a pricing to store 4
$product = Mage::getModel('catalog/product')->setStoreId(4)->load(1234);
$product->setData('group_price',array (
    array (
        "website_id" => 3,
        "cust_group" => 4,
        "price" => 99
    )));
$product->save();

// add a pricing to store 1
$product = Mage::getModel('catalog/product')->setStoreId(1)->load(1234);
$product->setData('group_price',array (
    array (
        "website_id" => 1,
        "cust_group" => 2,
        "price" => 105
    )));
$product->save();

// remove group pricing from store 2
$product = Mage::getModel('catalog/product')->setStoreId(2)->load(1234);
$product->setData('group_price',array ());
$product->save();

This is convenient if you are dealing with batches of group pricing on a single store, but don't what to affect other stores group pricing. I don't know if this is the simplest mechanism, but it has worked so far for me.

Problem

In magento's latest version (1.7) there is an option to set customer group prices, however I can't find any documentation on how to do this programmatically. I tried the following code, but it didn't work. Anyone know how to set customer group price? ``` $_product->setCustomerGroupId($_price->getCustomerGroupId()); $_product->setGroupPrice($price); $_product->save(); ```

Original source