Tuesday, 6 November 2012

Magento - How to get all Product details in magento Programmatically?

<?php
require_once 'app/Mage.php';
umask(0);
Mage::app('default');

function empty_pk($data){
if($data!=''){return $data;}
else {return "&nbsp;";}
}
$collection = Mage::getModel('catalog/product')->getCollection();

echo '<table border="1"> ';
echo '<tr>';
echo "<th>sku<th />";
echo "<th>name<th />";
echo "<th>qty<th />";
echo "<th>is_in_stock<th />";
echo "<th>price<th />";
echo '</tr>';

foreach ($collection as $product_all) {
//echo '<pre>';print_r($product);echo '</pre>';

$sku = $product_all['sku'];
// retrieve product id using sku
$product_id = Mage::getModel('catalog/product')->getIdBySku($sku);
// call product model and create product object
$product    = Mage::getModel('catalog/product');
// Load product using product id
$product ->load($product_id);

$pk_sku = empty_pk($product['sku']);
$pk_name = empty_pk($product['name']);

$stockData = $product->getStockData();

$pk_qty = empty_pk($stockData['qty']);
$pk_in_stock = empty_pk($stockData['is_in_stock']);
$pk_price = empty_pk($product['price']);

echo '<tr>';
echo "<td>".$pk_sku."<td />";
echo "<td>".$pk_name."<td />";
echo "<td>".$pk_qty."<td />";
echo "<td>".$pk_in_stock."<td />";
echo "<td>".$pk_price."<td />";

echo '</tr>';

}
echo '</table>';
?>

1 comment:

  1. Hello,
    Thx for this script but unfortunately, i can't get it to work properly on magento 1.6. It seems that "Qty" field and "is in stock" field are empty... Any clue on how to resolve this problem ???

    ReplyDelete