Magento 1.9 get all product

//to overwrite limit but you need first to increase your memory limit

 $collection = Mage::getModel('catalog/product')->getCollection()
->addAttributeToSelect('*') // select all attributes
->setPageSize(5000) // limit number of results returned
->setCurPage(1); // set the offset (useful for pagination)

// we iterate through the list of products to get attribute values
foreach ($collection as $product) {
  echo $product->getName(); //get name
  echo (float) $product->getPrice(); //get price as cast to float
  echo $product->getDescription(); //get description
  echo $product->getShortDescription(); //get short description
  echo $product->getTypeId(); //get product type
  echo $product->getStatus(); //get product status

  // getCategoryIds(); returns an array of category IDs associated with the product
  foreach ($product->getCategoryIds() as $category_id) {
      $category = Mage::getModel('catalog/category')->load($category_id);
      echo $category->getName();
      echo $category->getParentCategory()->getName(); // get parent of category
  }
  //gets the image url of the product
  echo Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA).
      'catalog/product'.$product->getImage();
  echo $product->getSpecialPrice();
  echo $product->getProductUrl();  //gets the product url
  echo '<br />';
}

Source: stackoverflow.com

Similar codes

35 votes145 views6 answers
Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))
PHP
0 vote201 views1 answer
How to disable a button in a blade file
PHP
0 vote125 views1 answer
Select posts wordpress wp_query
PHP
3 votes156 views3 answers
Laravel pagination having raw query not working
PHP
8 votes177 views6 answers
Codeigniter get last query
PHP
0 vote148 views2 answers
Php access key stdClass object
PHP
0 vote167 views1 answer
Clear from faild_jobs laravel
PHP
1 vote157 views2 answers
Get current term id
PHP
8 votes192 views5 answers
Laravel route model binding
PHP Laravel
0 vote160 views1 answer
Rest api response 404 wordpress
PHP