Magento export tier price

Below is the code to Magento export tier price of all product to csv

//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";
   }  
 }

No comments:

Post a Comment