display special prices in excel sheet which displaying in site using catalog price rules

Question

we have uploaded about 1000 products in a site.

we used "catalog price rules" to give discount for all products,

so special prices are displaying in site.

we want to get all those special prices in a excel sheet

when i use "export all products", special prices are not displaying in excel sheet in .csv format.

is there any option to display "special prices" in exc el sheet which we gave specail prices by applying

catalog price rules?

thanks in advance

Answer 1

You can create a separate action in a controller that will retrieve the products with special prices and export them in a csv format.

$products = Mage::getModel('catalog/product')->getCollection()
   ->addExpressionAttributeToSelect('discount', '(price_index.price - price_index.min_price)', array());
$products->getSelect()->having('discount > 0');

$pricesBySku = array();
foreach ($products as $product) {
     $pricesBySku[$product->getSku()] = $product->getDiscount();
}
//do what every you want with $pricesBySku. export it as a csv, print it on the screen...