I want to move all my products and their attributes to my new store

Question

What is the best way to accomplish this? Please don't just say "magmi".

Additionally, my dataflow profiles do not work on my local/vagrant build. It just keeps timing out.

Is there a way to do it through a PHP script to export to CSV file or through MySQL.

Any help would be greatly appreciated. Thank you.

Answer 1

This script will help you to export all product to csv file. The file will be generated in var/inportexport folder.

$data=array(); 
$data['entity'] = 'catalog_product';  
$data['file_format'] = 'csv';  
$data['form_key'] = Mage::getSingleton('core/session')->getFormKey();  
$data['export_filter'] = array();  
$model = Mage::getModel('importexport/export');     
$model->setData($data);

$model->export();  
$model->getContentType();