Anbei ein kleines Codeschnipsel, der alle Bestellungen inkl. Filterung nach Datum ausliest und entsprechende Werte zurückgibt.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | $from = '2010-11-01 00:00:00' ; $to = '2010-11-30 23:59:59' ; /* @var $orders Mage_Sales_Model_Order */ $orders = Mage::getModel( 'sales/order' ) ->getCollection() ->addAttributeToSelect( array ( 'status' , 'state' )) ->addAttributeToFilter( 'created_at' , array ( 'from' => $from , 'to' => $to , 'datetime' => true) ); echo 'firstname;lastname;email;orderid;orderstatus\n' ; foreach ( $orders as $order ) { $orderId = $order ->getId(); $orderStatus = $order ->getStatusLabel(); $customerId = $order ->getCustomerId(); $customer = Mage::getModel( 'customer/customer' )->load( $customerId ); $lastname = $customer ->getLastname(); $firstname = $customer ->getFirstname(); $email = $customer ->getEmail(); echo $firstname . ';' . $lastname . ';' . $email . ';' . $orderId . ';' . $orderStatus . '\n' ; } ?> |