Magento – magento : get tier price of product

apiPHPproducttierprice

i want to get Tier Price via API in magento , i use method described in this Link but i have problam in get tier_price , it`s return only price from catalogProductTierPriceEntity content ! customer_group_id and website and qty is missing

i use this code :

$proxy = new SoapClient('http://magentohost/api/v2_soap/?wsdl'); // TODO : change url
$sessionId = $proxy->login('apiUser', 'apiKey'); 

$result = $proxy->catalogProductInfo($sessionId, '4');
var_dump($result);

Best Answer

You can try following way.


$client = new SoapClient('http://magentohost/api/v2_soap/?wsdl');
$session = $client->login($apiUser,$apiKey);
$productId = 166;
$result = $client->catalogProductAttributeTierPriceInfo(
    $session,
    $productId
);
print_r($result);

For more information click here .

Related Solutions

Magento – Export Product CSV with Tier Price

Here is the script I use:

    //Magento export tier price of all product to csv
require_once 'app/Mage.php';
umask(0);
Mage::app('default');

header("Content-type:text/octect-stream");
header("Content-Disposition:attachment;filename=data.csv");

$tableName = Mage::getSingleton('core/resource')
 ->getTableName('catalog_product_entity_tier_price');
$storeId    = Mage::app()->getStore()->getId();
$product    = Mage::getModel('catalog/product');
$products   = $product->getCollection()->addStoreFilter($storeId)->getAllIds();

$fieldname = array("store","websites","attribute_set","type","sku","name","tier_price_website","tier_price_customer_group","tier_price_qty","tier_price_price");
print stripslashes(implode(',',$fieldname)) . "\n";
foreach($products as $productid)
{
$existingTierPrice = $product ->load($productid)->tier_price;
$sku = $product->getSku();
$name = $product->getName();
foreach($existingTierPrice as $key=>$value)
{
$tierarray = array("admin","base","Default","simple",$sku,$name,"all","all",$value['price_qty'],$value['price']);
print stripslashes(implode(',',$tierarray)) . "\n";
}
}

Courtesy of http://developerafroz.blogspot.com/2011/05/magento-export-tier-price.html

Magento – Tier price update

All the tier prices are stored in the table catalog_product_entity_tier_price. The columns mean the following:

value_id - table auto increment
entity_id - the product id
all_groups - 0/1 flag that tells if the prices apply to all customer groups
customer_group_id - the id of the customer group the prices are applied. If all_groups is 1 this has no value. If you have one price that should apply to only 2 customer groups add 2 different records in the table one for each customer group
qty - represents the minimum quantity for which the tier price is applied.
value - is the actual price value
website_id - the id of the website for which the prices are applied. 0 for all websites.

I know it's not a good practice to edit the DB directly, but in this case, when there is only one table involved, the risk is minimum. I've done this with success in the past. If you manage to format you data in the same format of the columns described above you can directly insert/update data in this table.
If you plan to take this approach backup your database before starting.
After you are done a price reindex is required.

Best Answer

Related Solutions

Magento – Export Product CSV with Tier Price

Magento – Tier price update

Related Topic