0

I need to create report or export orders list as csv file, on a specified date range, where each of them have these data:

  • order id
  • date
  • import
  • products quantity
  • payment method

I am tried to Reports>Sales section in the backoffice but I never can get all the above dates.

I'm using Magento ver. 1.9.3.3

1 Answer 1

3

I have create order export script. please review it.

Note -> please update app/Mage.php path as your requirement

ini_set('display_errors', 1);
set_time_limit(0);
ini_set("memory_limit",-1);
ini_set('max_execution_time','1800000000');

define('MAGENTO_ROOT', getcwd());
require_once  (MAGENTO_ROOT . '../../app/Mage.php');

Mage::app();
Mage::app()->getStore()->setId(Mage_Core_Model_App::ADMIN_STORE_ID);
Mage::init();

$fromDate = '2016-12-01 00:00:00';
$toDate = '2017-04-01 00:00:00';//$toDate = '2017-05-31 23:59:59';

$order = Mage::getResourceModel('sales/order_grid_collection');
$order->addAttributeToSelect('*');
$order->addFieldToFilter('created_at', array('from'=>$fromDate,'to'=>$toDate));
$order->setOrder('increment_id', 'DESC');

$fp = fopen('sales-order-export.csv', 'w');
$field = array('OrderNumber','Date','products quantity','payment method');
fputcsv($fp, $field);
echo "<pre>";
foreach($order as $orders)
{
    $countTotalQty = 0; 
    foreach ($orders->getAllItems() as $item)
    {
        $countTotalQty = $countTotalQty + $item->getQtyOrdered();
    }
    $payment = $orders->getPayment();
    $fields = array($orders->getIncrementId(),$orders->getCreatedAt(),$countTotalQty,$payment->getMethod());
    fputcsv($fp, $fields);


}

I hope it will help you

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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