Magento – Add Custom Attribute to New Order Email Magento 1.7

magento-1.7

I added a custom attribute in to my default product type like so

Attribute Code: mfgpartnumber
Attribute Label: Manufacturer Part Number

This attribute is used to add products in Magento backend and I want to include this attribute in new order emails. I have researched so far and here is what I finally added

<?php $product = Mage::getModel('catalog/product')->loadByAttribute('sku', $_item->getSku(), array('mfgpartnumber')); ?>
<?php echo $product->getAttributeText('mfgpartnumber'); ?>

To /home/txsystems/store/app/design/frontend/base/default/template/email/order/items/order

That did not work, please can someone point me in the right direction on how to add custom attribute to Magento new order emails.

Best Answer

I prefer not to use loadByAttribute as it returns a resource collection call which uses "select *" by default. Try this instead:

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

Related Solutions

Magento – Determine Page Type and Page

In addition to what @benmarks answered:

Here is a little code to check some of the conditions you mentioned:

// Check if it's a CMS page:
$page = Mage::getSingleton('cms/page');
if ($page->getId()) {
    // The current page is a CMS page

    if ($page->getIdentifier() == Mage::getStoreConfig('web/default/cms_home_page')) {
        // The current page is the CMS home page
    }
}

$product = Mage::registry('current_product');
$category = Mage::registry('current_category');
if ($product && $product->getId()) {
    // The current page is a product page.
    // If you only want the main product detail page, also check for 
    // Mage::app()->getFrontController()->getAction()->getFullActionName() == 'catalog_product_view'
    // Be aware that a current_product and a current_category can be set at the same time.
    // In that case the visitor is viewing a product in a category.
} elseif ($category && $category->getId()) {
    // The current page is a category page
    // If you only want the category list page, also check for 
    // Mage::app()->getFrontController()->getAction()->getFullActionName() == 'catalog_category_view'
}

// Check for cart page
if (Mage::app()->getFrontController()->getAction()->getFullActionName() == 'checkout_cart_index') {
    // The current page is the cart
}

To check if the cart is empty or not use

$isEmpty = Mage::getSingleton('checkout/session')->getQuote()->getItemsCount() > 0

Also you asked if you can check the current page inside a CMS block.
That probably is not a good approach (you would have to include custom blocks, which would defeat the purpose of using CMS blocks in the first page).
Instead it's better to check the current page first, and then choose the CMS block to display based on that.

EDIT: fixed Mage::app()->getRequest()->getFullActionName() to be Mage::app()->getFrontController()->getAction()->getFullActionName() as mentioned by @Joseph in the comments. Thanks!

Magento – Magento Sales Order view Item ordered block

Create a new theme, copy the template, change it. DON'T CHANGE ANY CORE FILES. After that said, you can get the Product from the order item:

$item->getProduct->getTypeId() == Mage_Downloadable_Model_Product_Type::TYPE_DOWNLOADABLE

and if yes you can get the type instance: $type = $item->getProduct()->getTypeInstance() and from there the Links: $type->getLinks()

To have your own template set the package or theme in the backend and then save your files here:

/app/design/<package|default>/<theme|default>/template/custom/sales/order/view/items.phtml

Best Answer

Related Solutions

Magento – Determine Page Type and Page

Magento – Magento Sales Order view Item ordered block

Related Topic