Order | The Magento Expert

Sorting order items by SKU (Magento 1)

Mex 15. April 2016 Magento Solutions

To display ordered products sorted by SKU in the order view, override the app/design/adminhtml/default/default/template/sales/order/view/items.phtml in your theme and replace

<?php $_items = $this->getItemsCollection() ?>
    <?php $i=0;foreach ($_items as $_item):?>
        <?php if ($_item->getParentItem()) continue; else $i++;?>
        <tbody class="<?php echo $i%2?'even':'odd' ?>">
            <?php echo $this->getItemHtml($_item) ?>
            <?php echo $this->getItemExtraInfoHtml($_item) ?>
        </tbody>
    <?php endforeach; ?>

<?php $_items = $this->getItemsCollection() ?>

<?php $i=0;foreach ($_items as $_item):?>

<?php if ($_item->getParentItem()) continue; else $i++;?>

<?php echo $this->getItemHtml($_item) ?>

<?php echo $this->getItemExtraInfoHtml($_item) ?>

</tbody>

<?php endforeach; ?>

with

<?php $_items = $this->getItemsCollection() ?>
    <?php $_sortedItems = array(); ?>
    <?php foreach ($_items as $_item) : ?>
        <?php $_sortedItems[$_item->getSku()] = $_item;?>
    <?php endforeach;?>
    <?php ksort($_sortedItems); // Sort by array keys ?>
    <?php $i=0;foreach ($_sortedItems as $_item):?>
        <?php if ($_item->getParentItem()) continue; else $i++;?>
        <tbody class="<?php echo $i%2?'even':'odd' ?>">
            <?php echo $this->getItemHtml($_item) ?>
            <?php echo $this->getItemExtraInfoHtml($_item) ?>
        </tbody>
    <?php endforeach; ?>

<?php $_items = $this->getItemsCollection() ?>

<?php $_sortedItems = array(); ?>

<?php foreach ($_items as $_item) : ?>

<?php $_sortedItems[$_item->getSku()] = $_item;?>

<?php endforeach;?>

<?php ksort($_sortedItems); // Sort by array keys ?>

<?php $i=0;foreach ($_sortedItems as $_item):?>

<?php if ($_item->getParentItem()) continue; else $i++;?>

<?php echo $this->getItemHtml($_item) ?>

<?php echo $this->getItemExtraInfoHtml($_item) ?>

</tbody>

<?php endforeach; ?>

That’s it. When you open an order containing two or more products, they will now be displayed in…

View solution

Creating order including custom options programmatically (Magento 1)

Mex 15. Oktober 2014 Magento Solutions

Using the following code, you can create an order including custom options programmatically.

$quote = Mage::getModel('sales/quote')->setStoreId(Mage::app()->getStore('default')->getId());
$quote->setCustomerEmail($mail);
$product = Mage::getModel('catalog/product')->load($productId);
$buyInfo = array(
                    'qty' => 1,
                     'options' => array($optionId => $optionValue)
                );
$quote->addProduct($product, new Varien_Object($buyInfo));
         
$addressData = array(
                'firstname' => $firstName,
                'lastname' => $lastName,
                'street' => $street,
                'city' => $city,
                'postcode' => $postCode,
                'telephone' => '-',
                'country_id' => $country,
                'region_id' => $regionId, 
        );
         
$billingAddress = $quote->getBillingAddress()->addData($addressData);
$shippingAddress = $quote->getShippingAddress()->addData($addressData);
$shippingAddress->setCollectShippingRates(true)->collectShippingRates()
                        ->setShippingMethod('flatrate_flatrate')
                        ->setPaymentMethod('bankpayment');
         
$quote->getPayment()->importData(array('method' => 'bankpayment'));
$quote->collectTotals()->save();
         
$service = Mage::getModel('sales/service_quote', $quote);
$service->submitAll();

$order = $service->getOrder();
// ...

$quote = Mage::getModel('sales/quote')->setStoreId(Mage::app()->getStore('default')->getId());

$quote->setCustomerEmail($mail);

$product = Mage::getModel('catalog/product')->load($productId);

$buyInfo = array(

'qty' => 1,

'options' => array($optionId => $optionValue)

);

$quote->addProduct($product, new Varien_Object($buyInfo));

$addressData = array(

'firstname' => $firstName,

'lastname' => $lastName,

'street' => $street,

'city' => $city,

'postcode' => $postCode,

'telephone' => '-',

'country_id' => $country,

'region_id' => $regionId,

);

$billingAddress = $quote->getBillingAddress()->addData($addressData);

$shippingAddress = $quote->getShippingAddress()->addData($addressData);

$shippingAddress->setCollectShippingRates(true)->collectShippingRates()

->setShippingMethod('flatrate_flatrate')

->setPaymentMethod('bankpayment');

$quote->getPayment()->importData(array('method' => 'bankpayment'));

$quote->collectTotals()->save();

$service = Mage::getModel('sales/service_quote', $quote);

$service->submitAll();

$order = $service->getOrder();

// ...

View solution

Getting orders with items that have a certain attribute set (Magento 1)

Mex 3. März 2014 Magento Solutions

The following MySQL query returns all Magento orders that have at least one item with attribute set id 9.

/* 9 = attribute set Id */
select
	increment_id,
	created_at,
	entity_id 
from
	sales_flat_order 
where
	entity_id not in (
		SELECT
			o.entity_id      
		FROM
			sales_flat_order o      
		LEFT JOIN
			sales_flat_order_item i        
				ON o.entity_id = i.order_id      
		LEFT JOIN
			catalog_product_entity p        
				ON i.product_id = p.entity_id      
		WHERE
			p.attribute_set_id = 9
	)

/* 9 = attribute set Id */

select

increment_id,

created_at,

entity_id

from

sales_flat_order

where

entity_id not in (

SELECT

o.entity_id

FROM

sales_flat_order o

LEFT JOIN

sales_flat_order_item i

ON o.entity_id = i.order_id

LEFT JOIN

catalog_product_entity p

ON i.product_id = p.entity_id

WHERE

p.attribute_set_id = 9

)

View solution

Getting an orders tracking information (Magento 1)

Mex 29. Januar 2014 Magento Solutions

Using the following code, you can obtain the tracking information of a Magento order.

$trackingCollection = $order->getTracksCollection();
$firstItem = $trackingCollection->getFirstItem();
$trackingNumber = $firstItem->getNumber();
...

$trackingCollection = $order->getTracksCollection();

$firstItem = $trackingCollection->getFirstItem();

$trackingNumber = $firstItem->getNumber();

...

View solution

Getting order data on success page (success.phtml) (Magento 1)

Mex 2. Oktober 2013 Magento Solutions

To get the order data on the Magento success page, use the following code. The key here is to create an order object and get the data from there.

$order = Mage::getModel('sales/order')->loadByIncrementId($this->getOrderId());
$date = $order->getCreatedAtStoreDate();
// ...

$order = Mage::getModel('sales/order')->loadByIncrementId($this->getOrderId());

$date = $order->getCreatedAtStoreDate();

// ...

View solution

Getting order items on success page (success.phtml) (Magento 1)

Mex 9. August 2013 Magento Solutions

Use the following code to get all ordered items on the Magento success page.

$order = Mage::getModel('sales/order')->loadByIncrementId($this->getOrderId());
$items = $order->getAllItems();
foreach($items as $item) {
    //...                   
}

$order = Mage::getModel('sales/order')->loadByIncrementId($this->getOrderId());

$items = $order->getAllItems();

foreach($items as $item) {

//...

}

View solution

Getting the shipping address for an order (Magento 1)

Mex 16. April 2013 Magento Solutions

Use the following code to get the shipping address of a Magento order:

$address = $order->getShippingAddress();

1	$address = $order->getShippingAddress();

View solution

Setting the order state to Complete or Closed (Magento 1)

Mex 25. März 2013 Magento Solutions

Normally Magento does not permit changing an order state to COMPLETE or CLOSED directly. Instead, you receive an error message (The Order State “complete” must not be set manually). You can work around this by overriding Order.php and View.php. 1.…

View solution