This is a method that we developed to handle custom integration with an inventory management system. This pulls all orders and processes them into an xml feed for processing by the inventory management system. Once it has passed the information it can optionally set each order to closed. Hopefully this helps you.

//External script – Load magento framework
require_once(“../app/Mage.php”);
Mage::app();

/* function for adding new node to xml file  */

function Add_NewDocElement($root, $parent, $name, $value){
$parent->appendChild($root->createElement($name))->appendChild($root->createTextNode($value));
}

#creating new xml-document
$dom = new DomDocument(’1.0′);
$dom->xmlStandalone = true;
$orders = $dom->appendChild($dom->createElement(‘ePosimPCOrders’));

#Magento required models
$myCustomer = Mage::getModel(‘customer/customer’);
$ordersMag = Mage::getModel(‘sales/mysql4_order_collection’);
$ordersInfo = Mage::getModel(‘sales/order_item’)->getCollection();

#Optional filters you might want to use – more available operationsin method _getConditionSql in Varien_Data_Collection_Db.
$ordersMag->addFieldToFilter(‘status’,Array(‘eq’=>”complete”)); //Status is “Completed”

#now we will get all order numbers associated
$allIds = $ordersMag->getAllIds();

#create new xml element

foreach($allIds as $thisId){
#this always needs to be inside the loop. otherwise we end up with bad data.
$myOrder = Mage::getModel(‘sales/order’);
$myOrder->load($thisId);
$getIncrement = $myOrder->getData();
$orderID = $getIncrement['increment_id'];
$myOrder->loadByIncrementId($orderID);
$order = $orders->appendChild($dom->createElement(‘Orders’));
$data = $myOrder->getData();
$address = Mage::getModel(‘sales/order_address’)->load($orderID);
#$customer = Mage::getModel(‘customer/customer’)->load($orderID->getCustomerId());

#first i’ll need to handle the multiple address scenario
$streetBA=$myOrder->getBillingAddress()->getStreet();
$streetSA=$myOrder->getShippingAddress()->getStreet();
if ($data['customer_id']){
$customer = “webCust-”.$data['customer_id'];
}else{
$customer = “web-guest”;
}

Add_NewDocElement($dom, $order, ‘idOrder’, $myOrder->getData(‘increment_id’));
Add_NewDocElement($dom, $order, ‘idCustomer’, $customer);
Add_NewDocElement($dom, $order, ‘CustomerPO’, “NO PO”); # can be left blank
Add_NewDocElement($dom, $order, ‘pcOrd_Time’, strftime(“%m-%d-%Y %H:%M%p”,strtotime($data['created_at'])));
Add_NewDocElement($dom, $order, ‘IPAddress’, $myOrder->getData(‘remote_ip’)); #remote_ip
#Add_NewDocElement($dom, $order, ‘lineBreak’, ‘#####################’); #visual debugging
#Billing Information
Add_NewDocElement($dom, $order, ‘customerCompany’, $myOrder->getBillingAddress()->getCompany());
Add_NewDocElement($dom, $order, ‘name’, $myOrder->getBillingAddress()->getFirstname());
Add_NewDocElement($dom, $order, ‘lastName’,$myOrder->getBillingAddress()->getLastname());
Add_NewDocElement($dom, $order, ‘address’, $streetBA[0]);
Add_NewDocElement($dom, $order, ‘address2′, (count($streetBA)==2)?$streetBA[1]:”);
Add_NewDocElement($dom, $order, ‘city’, $myOrder->getBillingAddress()->getCity());
Add_NewDocElement($dom, $order, ‘zip’,$myOrder->getBillingAddress()->getPostcode());
Add_NewDocElement($dom, $order, ‘stateCode’, $myOrder->getBillingAddress()->getRegion());
Add_NewDocElement($dom, $order, ‘countryCode’, $myOrder->getBillingAddress()->getData(‘country_id’));
Add_NewDocElement($dom, $order, ‘phone’, $myOrder->getBillingAddress()->getData(‘telephone’));
Add_NewDocElement($dom, $order, ‘email’, $data['customer_email']);
#Add_NewDocElement($dom, $order, ‘lineBreak’, ‘#####################’); #visual debugging

#now we pull shipping information
Add_NewDocElement($dom, $order, ‘shippingCompany’, $myOrder->getShippingAddress()->getFirstname());
Add_NewDocElement($dom, $order, ‘ShippingFirst’, $myOrder->getShippingAddress()->getFirstname());
Add_NewDocElement($dom, $order, ‘ShippingLast’, $myOrder->getShippingAddress()->getLastname());
Add_NewDocElement($dom, $order, ‘shippingAddress’, $streetBA[0]);
Add_NewDocElement($dom, $order, ‘shippingAddress2′, (count($streetSA)==2)?$streetSA[1]:”);
Add_NewDocElement($dom, $order, ‘shippingCity’, $myOrder->getShippingAddress()->getCity());
Add_NewDocElement($dom, $order, ‘shippingStateCode’, $myOrder->getShippingAddress()->getRegion());
Add_NewDocElement($dom, $order, ‘shippingZip’,$myOrder->getShippingAddress()->getPostcode());
Add_NewDocElement($dom, $order, ‘shippingCountryCode’, $myOrder->getShippingAddress()->getData(‘country_id’));
Add_NewDocElement($dom, $order, ‘pcOrd_ShippingPhone’, $myOrder->getShippingAddress()->getData(‘telephone’));
# get email
Add_NewDocElement($dom, $order, ‘pcOrd_ShippingEmail’, ” );
#start payment info
Add_NewDocElement($dom, $order, ‘Total’, number_format($myOrder->getTotal_paid(), 2, ‘.’, ”));
Add_NewDocElement($dom, $order, ‘SubTotal’, number_format($data['base_subtotal'], 2, ‘.’, ”));
#start tax info
Add_NewDocElement($dom, $order, ‘TaxRate1′, “.0675″);
Add_NewDocElement($dom, $order, ‘TaxRate2′, “0″);
Add_NewDocElement($dom, $order, ‘TaxAmt1′, number_format($data['base_tax_amount'], 2, ‘.’, ”));
Add_NewDocElement($dom, $order, ‘TaxAmt2′, ’0′);
Add_NewDocElement($dom, $order, ‘TotalTaxAmt’, number_format($data['base_tax_amount'], 2, ‘.’, ”));

Add_NewDocElement($dom, $order, ‘cardtype’, $myOrder->getData(‘cc_type’));
Add_NewDocElement($dom, $order, ‘cardnumber’,$myOrder->getData(‘cc_last4′));
Add_NewDocElement($dom, $order, ‘expiration’, $myOrder->getData(‘exp_month’).$myOrder->getData(‘exp_year’));
#Add_NewDocElement($dom, $order, ‘BatchID’, $BatchID); # not required

/* additional info not used
Add_NewDocElement($dom, $order, ‘TotalInvoiceAmount’, $myOrder->getTotal_paid());
Add_NewDocElement($dom, $order, ‘OrderStatus’, $myOrder->getStatus());
Add_NewDocElement($dom, $order, ‘PaymentMethod’,$myOrder->getPayment()->getData(‘method’));
Add_NewDocElement($dom, $order, ‘ShippingCaptured’, $myOrder->getPayment()->getData(‘shipping_captured’));

*/
#$myOrder->setStatus(Mage_Sales_Model_Order::STATE_CLOSED, true);
}

#next, for each order we retreive the specifics.

# first we’ll pull items information
$allIds = $ordersMag->getAllIds();
foreach($allIds as $thisId)
{      $myOrder->load($thisId);
foreach ($myOrder->getItemsCollection() as $item)
{

$order = $orders->appendChild($dom->createElement(‘OrdersItems’));
$data = $item->getOrigData();

Add_NewDocElement($dom, $order, ‘idOrder’, $myOrder->getData(‘increment_id’));
Add_NewDocElement($dom, $order, ‘LineOrder’, ’100′);
Add_NewDocElement($dom, $order, ‘sku’, $data['sku']);
Add_NewDocElement($dom, $order, ‘quantity’, $item->getQtyOrdered());
Add_NewDocElement($dom, $order, ‘unitPrice’, $item->getPrice());
Add_NewDocElement($dom, $order, ‘ns_TransCode’, “S” );//TODO pull all trans types.
Add_NewDocElement($dom, $order, ‘ns_Description’, $item->getName());
Add_NewDocElement($dom, $order, ‘ns_PriceCode’,  “A”);
#Add_NewDocElement($dom, $order, ‘TaxCode’,  $data['tax_percent']);// we may need this for later.

}
}

# next we’ll pull shipping information
$allIds = $ordersMag->getAllIds();
foreach($allIds as $thisId)
{
$myOrder->load($thisId);
$order = $orders->appendChild($dom->createElement(‘OrdersItems’));
$data = $myOrder->getOrigData();

Add_NewDocElement($dom, $order, ‘idOrder’, $myOrder->getData(‘increment_id’));
Add_NewDocElement($dom, $order, ‘LineOrder’, ’500′); #TODO ask brad about the significance of this.
Add_NewDocElement($dom, $order, ‘quantity’, ’1′);
Add_NewDocElement($dom, $order, ‘unitPrice’, $myOrder->getPayment()->getData(‘shipping_captured’));
Add_NewDocElement($dom, $order, ‘sku’, ‘AxloShipping’);
Add_NewDocElement($dom, $order, ‘ns_TransCode’, “F” );//POSIM specific freight code.
Add_NewDocElement($dom, $order, ‘ns_Description’, ‘per order shipping charge’ );
Add_NewDocElement($dom, $order, ‘ns_PriceCode’,  “A”);
#Add_NewDocElement($dom, $order, ‘TaxCode’,  $data['tax_percent']);// we may need this for later.
}
}

#now we’ll start the output.

#this method is for debugging. uncomment when testing.
/* $dom->formatOutput = true; ?> <pre> <? echo $dom->saveXML(); ?>  </pre> <? */

# this method is for live version. comment out when teting for easier debugging.
$dom->formatOutput = true;
return $dom->saveXML();