I have received a tracking pixel from one of our advertising company, and they asked me to place that code in my order confirmation page.

first of all can some one tell me where is the order confirmation file located in magento?

And 2nd if i need to get "order ID" value and "Amount" of the order then what to use in this pixel.

<img src="https://www.emjcd.com/u?AMOUNT=AMOUNT&CID=7777777&OID=OID&TYPE=5555555&CURRENCY=GBP&METHOD=IMG" height="1" width="20"/> 

you can get more information here: http://www.pricerunner.co.uk/about/sales-tracking-instructions.html


You will need to copy your base template file from


To your ultimo theme path


You can put below code in your success.phtml file

    $order_id = Mage::getSingleton('checkout/session')->getLastRealOrderId();
    $order = Mage::getModel('sales/order')->loadByIncrementId($order_id);
    $grandTotal = $order->getGrandTotal();
    $orderCurrency = $order->getOrderCurrencyCode();

<img src="https://www.emjcd.com/u?AMOUNT=<?php echo $grandTotal; ?>&CID=7777777&OID='<?php echo $order_id;?>'&TYPE=5555555&CURRENCY=<?php echo $orderCurrency; ?>&METHOD=IMG" height="1" width="20"/>        
  • Hi @akhilesh thanks for your help but "we need to alter the <AMOUNT> and <OID> (highlighted below) to pull in this information from your site. So you'll need to find out which macros create this information and then enter them here." – shafiq Oct 8 '15 at 11:39
  • did you tried this code? It didn't work for you? I think it will do same as mention in your url pricerunner.co.uk/about/sales-tracking-instructions.html – Akhilesh Patel Oct 8 '15 at 11:57
  • i have tried this code but i cant see this in my success page html, when placed order on front end. – shafiq Oct 8 '15 at 12:08
  • did you clear your magento cache after changing the file? – Ricky Odin Matthews Oct 8 '15 at 12:12
  • also enabled your template path hints and place order so you will get idea if your success.phtml file path is correct and it is not calling from somewhere else. – Akhilesh Patel Oct 8 '15 at 12:16

If you're using the rwd theme, it's in /app/design/frontend/rwd/default/template/checkout/success.phtml

The order object isn't present on the confirmation page - it's already unloaded by this stage. So you could write a module to hook into the order save function, but if you need a quick fix you could load the last order id using something like (in success.phtml):

$lastOrderId = Mage::getSingleton('checkout/session')->getLastOrderId();
$order = Mage::getSingleton('sales/order'); 
$_totalData =$order->getData(); 
$_sub = $_totalData['subtotal'];
  • hi, thanks for your help, but how to use this code togather with above one? – shafiq Oct 8 '15 at 11:01
  • i am using ultimo, but i cant find success.phtml any where in my theme. – shafiq Oct 8 '15 at 11:05
  • Hi, you need to find /app/design/frontend/base/default/teamplte/checkout/success.phtml and copy to your ultimo theme path, as mention below in Akhilesh's answer. You can do print_r($order) to view the order array (but this may be large) – Ricky Odin Matthews Oct 8 '15 at 11:58

Magento v2.1.x

Here's all what you need with some extra values as well

$merchantid = "<ID>";

$objectManager  =  \Magento\Framework\App\ObjectManager::getInstance();
$orderId        = $block->getOrderId();
$order          = $objectManager
$subtotal       = $order->getSubtotal();
$discount       = $order->getDiscountAmount(); 
$affiliateTotal = ($subtotal + $discount);

$ordered_items = $order->getAllVisibleItems();
$skulist = '';
$pricelist = '';
$quantitylist = '';

$last_index = array_search(end($ordered_items), $ordered_items, true);
foreach($ordered_items as $index => $item){
    $delimiter    = $index === $last_index ? '' : ',';
    $skulist      .= $item->getSku() . $delimiter;
    $quantitylist .= ceil($item->getQtyOrdered()) . $delimiter;
    $pricelist    .= ($item->getProduct()->getFinalPrice() - ($item->getDiscountAmount() / $item->getQtyOrdered())) . $delimiter;
$couponcodes = $order->getCouponCode();

$currency = $order->getOrderCurrencyCode();
//render pixel below
<img src="https://www.emjcd.com/u?tracking=<?php echo $orderId ?>&amp;amount=<?php echo $affiliateTotal ?>&amp;transtype=sale&amp;merchantID=<?php echo $merchantid ?>&amp;couponcode=<?php echo $couponcodes ?>&amp;skulist=<?php echo $skulist ?>&amp;quantitylist=<?php echo $quantitylist ?>&amp;pricelist=<?php echo $pricelist ?>&amp;currency=<?php echo $currency ?>&amp;v=2.0" width="1" height="1">

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.