1//to overwrite limit but you need first to increase your memory limit
2
3 $collection = Mage::getModel('catalog/product')->getCollection()
4->addAttributeToSelect('*') // select all attributes
5->setPageSize(5000) // limit number of results returned
6->setCurPage(1); // set the offset (useful for pagination)
7
8// we iterate through the list of products to get attribute values
9foreach ($collection as $product) {
10 echo $product->getName(); //get name
11 echo (float) $product->getPrice(); //get price as cast to float
12 echo $product->getDescription(); //get description
13 echo $product->getShortDescription(); //get short description
14 echo $product->getTypeId(); //get product type
15 echo $product->getStatus(); //get product status
16
17 // getCategoryIds(); returns an array of category IDs associated with the product
18 foreach ($product->getCategoryIds() as $category_id) {
19 $category = Mage::getModel('catalog/category')->load($category_id);
20 echo $category->getName();
21 echo $category->getParentCategory()->getName(); // get parent of category
22 }
23 //gets the image url of the product
24 echo Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA).
25 'catalog/product'.$product->getImage();
26 echo $product->getSpecialPrice();
27 echo $product->getProductUrl(); //gets the product url
28 echo '<br />';
29}
30