Subtotal showing with Tax, need it without.

Hi Guys,

Can anyone help me on this one?

First off, I'm in the UK and charging clients 20% VAT. This is setup in zones/taxes in the store. On the front-end clients see prices including TAX (display prices including tax conferred in admin).

When clients go to the checkout and also on the invoices, the sub-total seems to include the 20% VAT.

Example:

Product price is £28 ex VAT.
Subtotal shows £33.60
Shipping shows £0.00
UK VAT shows £5.60
Total shows £33.60

I would really need:
Product is £28 ex VAT.
Subtotal shows £28.00
Shipping shows £0.00
UK VAT shows £5.60
Total shows £33.60

Any help would be appreciated.

Regards

Matt

There is at least one or two mods out there that somewhat address this, but I'm wondering about the sequencing of the payment modules and if that would/could affect the result(s) observed.

Perhaps post the payment modules that are active/inactive and the sort order.

mc12345678:

There is at least one or two mods out there that somewhat address this, but I'm wondering about the sequencing of the **payment **modules and if that would/could affect the result(s) observed.

Perhaps post the **payment **modules that are active/inactive and the sort order.
I believe that you meant the sort-orders of the order-total modules.

lat9:

I believe that you meant the sort-orders of the order-total modules.

You are correct (more than obviously)... That's what I get for answering a question when waking up from a nap. :P

Explanation: the order-total modules process the information in sort order. So, if the sub-total is not supposed to contain something, it should be placed before that something. If the value is to be considered (assuming it modifies a value processed by the sub-total) then it should be positioned by sort order before the sub-total. The caveat about if it modifies a value processed by the sub-total is that it is possible for an order-total module to provide order information that has no bearing on the values processed by the sub-total.

Generally speaking the above applies to any order-total module including the sequence of order-totals and not just to the sub-total.

Hi Guys, this is the current order of the modules.

Modules Sort Order Action
Discount Coupon ot_coupon 280
Group Discount ot_group_pricing 290
Gift Certificates ot_gv 840
Low Order Fee ot_loworderfee 400
Shipping ot_shipping 200
Sub-Total ot_subtotal 100
Tax ot_tax 300
Total ot_total 999
Module Directory: /home/sites/domain.com/public_html/includes/modules/order_total/

It has been awhile since I've looked at the code, but if I remember the subtotal is just a running total of the final_price for all products in the shopping cart (unless another order total module directly modifies the running subtotal)...

When you have DISPLAY_PRICE_WITH_TAX ("admin" -> "Configuration" -> "My Store" -> "Display Prices with Tax") enabled for products, internally the product's final_price will include applicable taxes... So the subtotal shown will include taxes because they were included with the product.

The Order Total module "ot_subtotal" is used to display the subtotal (and is stored separately in the database). Basically, "ot_subtotal" simply accesses the running subtotal for the order. One could alter ot_subtotal to show the subtotal minus the applied tax (when DISPLAY_PRICE_WITH_TAX == 'true')...

The side effect of making the above change is: the value for ot_subtotal will be stored in the database table "orders_total" without applied taxes (while the subtotal for the order is still stored with applied taxes in the "orders" database table... Not a big deal most of the time... But storing two different subtotal values in the database for a single order may have a negative impact on the operation of third party plugins reading or manipulating orders...

i have the same problem , who can help me ?? please

saidkouki:

i have the same problem , who can help me ?? please

Glad to see that you've reached out for assistance!!!

Need more information. Preferably a good place to start is with the answers to the questions asked in the posting tips... Next is answering the same questions already asked or presenting the same level of detail.