Magento 2 – How to Query Data into Email Template

Var $payment_html is injected in email variables in Mage_Sales_Model_Order::sendNewOrderEmail() and not available for update emails. Since exact block wich is rendered depends on payment method you will need to get that HTML using same way as in Mage_Sales_Model_Order::sendNewOrderEmail(). You can either extend and overwrite Mage_Sales_Model_Order::sendNewOrderEmail() or create your own block and reference it in the email template.

{{block type="your/block_type"}}

The only problem is how to pass order to your block. I am not sure if var order will work in this context.

These depend on the type of discount. If they are catalog based (temporary price on the product or a catalog rule under promotions), then look in Mage_Sales_Model_Order_Item. All magic setters and getters are documented now.

So in your case:

• getOriginalPrice()
• getPrice()
• getDiscountAmount

Each of these have a "Base" version. That is the version in the store currency. If you provide the option to sell in other currencies, then base and normal version will differ.