Discount information for order in Magento

Question

I need information which promotion/coupon changed which item in order and what was the price of this item before discount and the final price of this item. I know, it's complicated so here's an example:

<order>
<items>
<item> <!-- This item have discount in order -->
<sku>1234</sku>
<promotion>
<promo_id>456</promo_id>
<discount_value>10</discount_value><!-- In % or $ -->
</promotion>
<final_price>25</final_price>
</item>
<item><!-- This item don't have discount in order -->
<sku>1234</sku>
<promotion/>
<final_price>35</final_price>
</item>
</items>
</order>

I hope it's comprehensible explanation. Thanks for all help.

EDIT: I forgot about one thing. All i have it's information from sales/order model. It's an interface, so i don't have access to session data, I get validated orders from database.

score 8 · Accepted Answer · answered Aug 09 '12 at 09:13

You can easily retrieve applied shopping cart rule ids from order item model.

You need to walk-though order items to collect all applied rule ids to items:

$collectedRuleIds = array();
$itemRules = array();
foreach ($order->getAllVisibleItems() as $orderItem) {
    if ($orderItem->getAppliedRuleIds()) {
        $itemRules[$orderItem->getId()] = explode(',', $orderItem->getAppliedRuleIds());
        $collectedRuleIds = array_merge($collectedRuleIds, $itemRules[$orderItem->getId()]);
    }
}

Then load rules collection, to retrieve rule information and assign it to order items.

$rules = false;
if ($collectedRuleIds) {
    $rules = Mage::getModel('salesrule/rule')->getCollection()->addFieldToFilter('rule_id', array('in' => $collectedRuleIds));
}

if ($rules) {
    foreach ($itemRules as $itemId => $ruleIds) {
        $orderItem = $order->getItemById($itemId);
        $appliedRules = array();
        foreach ($ruleIds as $ruleId) {
            if ($rules->getItemById($ruleId)) {
                $appliedRules[] = $rules->getItemById($ruleId);
            }
        }
        $orderItem->setAppliedRules($appliedRules);
    }
}

During exporting data, just check getAppliedRules property of order item to get information about type of promotion for building proper export file.

why AllVisibleItems() no AllItems() ? What's the difference? — Iwo Kucharski, Aug 09 '12 at 11:09
All items returns products including children ones. Not sure that you need them, if you don't want export configurable product simple as separate item well. — Ivan Chepurnyi, Aug 09 '12 at 13:03

Discount information for order in Magento

1 Answers1