<?php
require_once 'app/Mage.php';
umask(0);
Mage::app('default');
function empty_pk($data){
if($data!=''){return $data;}
else {return " ";}
}
$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>';
?>
Hello,
ReplyDeleteThx 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 ???