Order

Getting the PayPal transaction ID (Magento 1)

Mex 2016/12/29 Magento Solutions

Use the following code to get the Magento PayPal transaction ID from an order object:

    $transactionId = $order->getPayment()->getLastTransId();

1	$transactionId = $order->getPayment()->getLastTransId();

Show solution

Sort order items by SKU (Magento 1)

Mex 2016/04/19 Magento Solutions

If you want to change the default sorting of the ordered items on the order detail page, go ahead and override 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); // This is where the sorting by SKU takes place ?>
    <?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); // This is where the sorting by SKU takes place ?>

<?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; ?>

Done. If you open the detail page of an order…

Show solution

Creating order including custom options programmatically (Magento 1)

Mex 2014/10/15 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();

// ...

Show solution

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

Mex 2014/03/03 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

)

Show solution

Getting an orders tracking information (Magento 1)

Mex 2014/01/29 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();

...

Show solution

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

Mex 2013/10/02 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();

// ...

Show solution

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

Mex 2013/08/09 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) {

//...

}

Show solution

Getting the shipping address for an order (Magento 1)

Mex 2013/04/16 Magento Solutions

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

$address = $order->getShippingAddress();

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

Show solution

★★★ The Magento Expert ★★★

Magento Pro with 19536 hours project experience

Getting the PayPal transaction ID (Magento 1)

Sort order items by SKU (Magento 1)

Creating order including custom options programmatically (Magento 1)

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

Getting an orders tracking information (Magento 1)

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

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

Getting the shipping address for an order (Magento 1)