Calculate the price for each product in an order in Magento

Question

I want to calculate the base price of all products in an order. The price for each (1 quantity) should include any discount/bonuses but NOT tax. The total of all product prices times their quantity + tax should be exactly the same as $order->getGrandTotal().

I’ve managed to get the individual prices including shipping fee with only a small precision error. Of course, this is not acceptable when dealing with currency. Also I’ve not taken into account bundled products and such.

So I ask you to help me, I need to make the exact same calculation as Magento do, and still get out the values that I need (each product/shipping with discounts but without tax).

Thanks in advance

Answer 1

I've done this, and it gives me exactly the information I need. But I'm not sure if this is the right way to do it. Also my $total seem to be different from $grand_total with a few decimals such as 0.005 or similar sometimes.

$store = Mage::app()->getStore($order->getStoreId());

$customer = Mage::getModel('customer/customer')
    ->load($order->getCustomerId());

$tax_calc = Mage::getSingleton('tax/calculation');

$tax_rate_req = $tax_calc->getRateRequest(
    $order->getShippingAddress(), 
    $order->getBillingAddress(), 
    $customer->getTaxClassId(), 
    $store);

$args = array();
$total = 0;

// Calculate price of each item in the order
foreach($order->getAllVisibleItems() as $item)
{
    $product = Mage::getModel('catalog/product')
        ->load($item->getProductId());

    $children = $item->getChildrenItems();

    if(count($children) && ($product->getData('price_type') != 1))
    {
        foreach($children as $child)
        {
            $product = Mage::getModel('catalog/product')
                ->load($child->getProductId());

            /* If tax_percent is not set?
            Mage::getSingleton('tax/calculation')->getRate(
                $tax_rate_req->setProductClassId($product->getTaxClassId()))
            */
            $tax_mod = (float)$child->getData('tax_percent');
            $tax_mod /= 100;

            $qty = (float)$child->getData('qty_ordered');

            $price = (float)$child->getData('row_total_incl_tax');
            $price -= (float)$child->getData('discount_amount');

            $base_price = (($price / (1 + $tax_mod)) / $qty);
            $base_price = $store->roundPrice($base_price);

            $total += (($base_price * (1 + $tax_mod)) * $qty);

            $args[] = array
                (
                    'name'          => $product->getData('name'),
                    'sku'           => $child->getData('sku'),
                    'tax_mod'       => $tax_mod,
                    'qty'           => $qty,
                    'price'         => $price,
                    'base_price'    => $base_price
                );
        }
    }
    else
    {
        /* If tax_percent is not set?
        Mage::getSingleton('tax/calculation')->getRate(
            $tax_rate_req->setProductClassId($product->getTaxClassId()))
        */
        $tax_mod = (float)$item->getData('tax_percent');
        $tax_mod /= 100;

        $qty = (float)$item->getData('qty_ordered');

        $price = (float)$item->getData('row_total_incl_tax');
        $price -= (float)$item->getData('discount_amount');

        $base_price = (($price / (1 + $tax_mod)) / $qty);
        $base_price = $store->roundPrice($base_price);

        $total += (($base_price * (1 + $tax_mod)) * $qty);

        $args[] = array
            (
                'name'          => $product->getData('name'),
                'sku'           => $item->getData('sku'),
                'tax_mod'       => $tax_mod,
                'qty'           => $qty,
                'price'         => $price,
                'base_price'    => $base_price
            );
    }
}

// Calculate price for shipping
if(($price = (float)$order->getData('shipping_incl_tax')) > 0)
{
    $tax_mod = $tax_calc->getRate($tax_rate_req->setProductClassId(
        Mage::getStoreConfig('tax/classes/shipping_tax_class')));
    $tax_mod /= 100;

    $price -= (float)$order->getData('shipping_discount_amount');

    $base_price = ($price / (1 + $tax_mod));

    $base_price = $store->roundPrice($base_price);

    $total += ($base_price * (1 + $tax_mod));

    $args[] = array
        (
            'name'          => $order->getData('shipping_description'),
            'sku'           => $order->getData('shipping_method'),
            'tax_mod'       => $tax_mod,
            'qty'           => 1,
            'price'         => $price,
            'base_price'    => $base_price
        );
}

$total = $store->roundPrice($total);

echo('<pre>');
print_r($args);
//print_r($order->getData());
echo('</pre>');

$grand_total = (float)$order->getData('grand_total');
//$grand_total = $store->roundPrice($grand_total);

echo('<p><strong>My total</strong>: ' . $total . '</p>');
echo('<p><strong>Grand total</strong>: ' . $grand_total . '</p>');

exit;