Magento 1.9 – Display Order Details Using Increment ID

magento-1.9orders

I've created a module to track orders, But the order details such as ( Product Name, Image, Size, Color, Quantity) are not displaying in the result page.

I'm getting the shipping address and Price of the product

Code

<?php $order = Mage::registry('current_order');?>
<?php
    $OrderNumber = $order->getIncrementId();
        $getOrder = Mage::getModel('sales/order')->load($OrderNumber);
        $getOrder->getAllVisibleItems();
        $orderItems = $getOrder->getItemsCollection()
        ->addAttributeToSelect('*')
        ->addAttributeToFilter('product_type', array('eq'=>'simple'))
        ->load();

    ?>
    <?php
        $order = new Mage_Sales_Model_Order();
        $order_id = $OrderNumber;
        $order->loadByIncrementId($order_id);
        $payment_method = $order->getPayment()->getMethodInstance()->getTitle();
        $formattedPriceSubtotal = Mage::helper('core')->currency($order->getSubtotal(), true, false);
        $formattedPriceShipping = Mage::helper('core')->currency($order->getShippingAmount(), true, false);
        $formattedPriceDiscount = Mage::helper('core')->currency($order->getDiscountAmount(), true, false);
        $formattedPriceTax = Mage::helper('core')->currency($order->getTaxAmount(), true, false);
        $formattedPriceGrandtotal = Mage::helper('core')->currency($order->getGrandTotal(), true, false);
        $_shippingAddress = $order->getShippingAddress();

        foreach($orderItems as $sItem) {
            if($sItem->getProductType() == "simple")
            {
                $orderIdArray[$orderCount] = $this->escapeHtml($this->getIncrementId());
               // code for size and color
                $Get_product= Mage::getSingleton('catalog/product')->load($sItem->getProductId());
                $productSize = $Get_product->getResource()->getAttribute('size')->getFrontend()->getValue($Get_product);
                $productColor =  $Get_product->getResource()->getAttribute('color')->getFrontend()->getValue($Get_product);
                $pItemId = $sItem->getParentItemId();

                $item = Mage::getModel('sales/order_item')->load("$pItemId");

                $qty = intval($item->getQtyOrdered());


    //get Active Product Data
    $nProduct = Mage::getModel('catalog/product')->load($sItem->getProductId());
    $nSku = $nProduct->getSku();


    $obj = Mage::getModel('catalog/product');
    $Parent_product = Mage::getModel('catalog/product')->loadByAttribute('sku','product-sku');
    $formattedPrice = Mage::helper('core')->currency($Parent_product->getPrice(), true, false);
?>

Best Answer

$OrderNumber give order increment id not order id that

Use loadByIncrementId() instead of load().

 $getOrder = Mage::getModel('sales/order')->loadByIncrementId($OrderNumber);

You done lot of code,Several time load product model/order object,you need to optimized:

<?php
        $OrderNumber = $order->getIncrementId();
        $getOrder = Mage::getModel('sales/order')->loadByIncrementId($OrderNumber);
        $orderItems= $getOrder->getAllVisibleItems();


        $payment_method = $getOrder->getPayment()->getMethodInstance()->getTitle();
        $formattedPriceSubtotal = Mage::helper('core')->currency($getOrder->getSubtotal(), true, false);
        $formattedPriceShipping = Mage::helper('core')->currency($getOrder->getShippingAmount(), true, false);
        $formattedPriceDiscount = Mage::helper('core')->currency($getOrder->getDiscountAmount(), true, false);
        $formattedPriceTax = Mage::helper('core')->currency($getOrder->getTaxAmount(), true, false);
        $formattedPriceGrandtotal = Mage::helper('core')->currency($getOrder->getGrandTotal(), true, false);
        $_shippingAddress = $order->getShippingAddress();

        foreach($orderItems as $sItem) {
                $Get_product= Mage::getModel('catalog/product')->load($sItem->getProductId());
                $productSize = $Get_product->getResource()->getAttribute('size')->getFrontend()->getValue($Get_product);
                $productColor =  $Get_product->getResource()->getAttribute('color')->getFrontend()->getValue($Get_product);
                $qty = intval($sItem->getQtyOrdered()); // order qty 
                $formattedPrice = Mage::helper('core')->currency($Get_product->getPrice(), true, false);


        }
?>

Related Solutions

Magento – Alphanumeric order increment id’s

Yes, we had this issue too.

Quick fix is the following: go to in app\code\core\Mage\Sales\Model\Resource\Quote.php, in the function isOrderIncrementIdUsed replace the row

$bind      = array(':increment_id' => (int)$orderIncrementId);

with

$bind      = array(':increment_id' => $orderIncrementId);

Everything should work now.

It's a core file fix, but it's possible to override this functionality with extension (unfortunately till now we have not had time for this)..

Regards.

Magento – Create invoice and shipment in magento via cron based on store view and order age

user1618341,According magento an order can place from one store,Magento is save order store id at sales_flat_order,sales_flat_grid order.

At your collection you need get store_id.Also need rectify collection query,Please use * instead of some field

<?php
    try {
        $orders = Mage::getModel('sales/order')->getCollection()
            ->addFieldToFilter(
                'status',
                array(
                    'nin' => array('complete', 'canceled', 'processing', 'holded', 'fraud'),
                    'in' => 'pending',
                ))
            ->addAttributeToSelect('store_id')
            ->addAttributeToSelect('status');
    }
catch (Mage_Core_Exception $e) {
}

I have put the condition to skip create shipment for one store view[if($eachorder->getData('store_id')!=='YOUSKIPSTOREID'):]

see code:

try {

    foreach ($orders as $eachorder) {


        $order = Mage::getModel("sales/order")->load($eachorder->getId());
        if (!$order->canInvoice()) {
            Mage::throwException(Mage::helper('core')->__('Cannot create an invoice.'));
        }
        $invoice = Mage::getModel('sales/service_order', $order)->prepareInvoice();
        if (!$invoice->getTotalQty()) {
            Mage::throwException(Mage::helper('core')->__('Cannot create an invoice without products.'));
        }
        $invoice->setRequestedCaptureCase(Mage_Sales_Model_Order_Invoice::CAPTURE_ONLINE);
        $invoice->register();
        $transactionSave = Mage::getModel('core/resource_transaction')
            ->addObject($invoice)
            ->addObject($invoice->getOrder());
        $transactionSave->save();
        /* put code for skip for one store */
        if($eachorder->getData('store_id')!=='YOUSKIPSTOREID'):

            $shipment = $order->prepareShipment();

            if ($shipment) {
                $shipment->register();
                $order->setIsInProcess(true);

                $transaction_save = Mage::getModel('core/resource_transaction')
                    ->addObject($shipment)
                    ->addObject($shipment->getOrder())
                    ->save();
            } else {
                throw new Exception("Cant get shipment");
            }
        endif;

        $order->setState(Mage_Sales_Model_Order::STATE_COMPLETE);
        $order->save();
    }

}catch (Mage_Core_Exception $e) {

}

If you getting the issues for create invoice and shipment,Please see my Blog:

Create invoice:

Create Shipment:

Best Answer

Related Solutions

Magento – Alphanumeric order increment id’s

Magento – Create invoice and shipment in magento via cron based on store view and order age

Related Topic