Order Total excluding VAT

[michael_s]

I wanted to change my order total using this modification to

Subtotal:
Shipping:
Subtotal Excl VAT Incl Shipping:
VAT:
Total Incl VAT:

To give the Sub-Total ex VAT but including the shipping,

catalog/includes/modules/order_total/ot_subtotal_ex.php

Find:

if (DISPLAY_PRICE_WITH_TAX == 'true')
{
$this->output[] = array('title' => $this->title . ':',
'text' => $currencies->format($order->info['subtotal']-$order->info['tax'], true, $order->info['currency'], $order->info['currency_value']),
'value' => $order->info['subtotal']);
}
else
{
$this->output[] = array('title' => $this->title . ':',
'text' => $currencies->format($order->info['subtotal'], true, $order->info['currency'], $order->info['currency_value']),
'value' => $order->info['subtotal']);
}

Change to:
if (DISPLAY_PRICE_WITH_TAX == 'true')
{
// Changed to added shipping cost to the subtotal - added +$order->info['shipping_cost'] into both lines below
$this->output[] = array('title' => $this->title . ':',
'text' => $currencies->format($order->info['subtotal']-$order->info['tax']+$order->info['shipping_cost'], true, $order->info['currency'], $order->info['currency_value']),
'value' => $order->info['subtotal']+$order->info['shipping_cost']);
}
else
{
// Changed to added shipping cost to the subtotal - added +$order->info['shipping_cost'] into both lines below
$this->output[] = array('title' => $this->title . ':',
'text' => $currencies->format($order->info['subtotal']+$order->info['shipping_cost'], true, $order->info['currency'], $order->info['currency_value']),
'value' => $order->info['subtotal']+$order->info['shipping_cost']);
}

Basically you are adding +$order->info['shipping_cost'] to anywhere there is $order->info['subtotal']

This may or may not be the correct way of doing it, but it did work for me.

Does not include the full package. Do not copy over your file, just insert code above

More...

[aquapet]

I have used this mod with customer groups and pdf invoice. The problem is that some customer groups are trade and ex-Tax, some are retail and inc-Tax. To get the correct total depending on customer group change the following in ot_subtotal_ex.php;

from:
if (DISPLAY_PRICE_WITH_TAX == 'true')

to:
if (CUSTOMERS_GROUP_SHOW_TAX == 'true')

To show UK vat correctly for trade invoices though it needs separate 0% and 17.5% totals - luckily all my items are 17.5%

[aquapet]

Just discovered that ot_subtotal_ex.php causes paypal not to work - all that is passed to paypal is the delivery charge. Even with the module installed but turned off there is a problem. Only by removing it and installing the original does paypal work! File comparison shows that the original has an extra piece of code after:

function process() {
global $order, $currencies;

which is this:

// BOF: LINES ADDED
$od_amount = $_SESSION['od_amount'];
$subtotal = $order->info['subtotal'] - $od_amount;
$order->info['subtotal'] = $order->info['subtotal'] - $od_amount;
// EOF: LINES ADDED

the next lines are the if statement to check for tax included or not in the ot_subtotal_ex.php whereas the ot_subtotal.php has the same without the if / else code.