I want to export all product from with the help of dataflow profile in Magento.

In my site I have 3000+ products. When I export product data from dataflow profile, it opens the new window and after 1 or 2 seconds it is showing "500 Internal error".

So I can't export my products.

Please help me, how to export my all products from dataflow? And also, are there any alternative solutions?

  • help to the link:-lero9.co.nz/magento-tips/… – Ashvin Monpara Jul 18 '15 at 11:59
  • I have tried this process again but when click on "run profile", after 2 minute it showing "500 Internal error" because it taking more time. – Rohit Mishra Jul 20 '15 at 7:11
  • Uncomment the #ini_set(‘display_errors’, 1); in your index.php so you can see what's wrong. Also take a look at these hints: techjam.gr/2012/magento/… – RoRo Nov 10 '15 at 14:47

You can use export module feature.

Admin panel -> system -> import/export -> export and select Entity Type as product select the product which is commom for all the product and then select continue, you can export all the product.


Alternatively explicitly you can export products. Here it is.

ini_set('max_execution_time', 0);
ini_set('memory_limit', '-1');

require_once 'app/Mage.php';
$collection = Mage::getModel("catalog/product")->getCollection();
$collection->addAttributeToFilter('status', 1);
$fopen = fopen('exportProducts.csv', 'w');
$csvHeader = array("id","sku", "name", "price","description","categories","image_url");
fputcsv( $fopen , $csvHeader,",");
foreach ($collection as $product){
        $id = $product->getId();
        $sku = $product->getSku();
        $name = $product->getName();
        $description = $product->getDescription();      
        $price = $product->getPrice();      
        $imageurl  = Mage::getModel('catalog/product_media_config')->getMediaUrl( $product->getImage() );           
        $category = $product->getCategoryIds();     
        $catName = array();
        $catname = implode(",",$catName);           
        fputcsv($fp, array($id, $sku, $name, $price, $description, $catname,$imageurl ), ",");
fclose($fopen );


$data['entity'] = 'catalog_product';
$data['file_format'] = 'csv';
$data['form_key'] =Mage::getSingleton('core/session')->getFormKey(); 

$model = Mage::getModel('importexport/export');



you use this script to export all product it will generate csv file in var importexport folder

Not the answer you're looking for? Browse other questions tagged or ask your own question.