Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2013
    Location
    Portishead, North Somerset, United Kingdom
    Posts
    34
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Jul 2012
    Posts
    16,719
    Plugin Contributions
    17

    Default Re: Subtotal showing with Tax, need it without.

    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,403
    Plugin Contributions
    87

    Default Re: Subtotal showing with Tax, need it without.

    Quote Originally Posted by mc12345678 View Post
    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.

  4. #4
    Join Date
    Jul 2012
    Posts
    16,719
    Plugin Contributions
    17

    Default Re: Subtotal showing with Tax, need it without.

    Quote Originally Posted by lat9 View Post
    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.

    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #5
    Join Date
    Oct 2013
    Location
    Portishead, North Somerset, United Kingdom
    Posts
    34
    Plugin Contributions
    0

    Default Re: Subtotal showing with Tax, need it without.

    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/

  6. #6
    Join Date
    Feb 2012
    Location
    mostly harmless
    Posts
    1,809
    Plugin Contributions
    8

    Default Re: Subtotal showing with Tax, need it without.

    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...
    Last edited by lhungil; 23 Mar 2015 at 08:18 PM.
    The glass is not half full. The glass is not half empty. The glass is simply too big!
    Where are the Zen Cart Debug Logs? Where are the HTTP 500 / Server Error Logs?
    Zen Cart related projects maintained by lhûngîl : Plugin / Module Tracker

  7. #7
    Join Date
    Mar 2015
    Location
    Stockholm, Sweden, Sweden
    Posts
    1
    Plugin Contributions
    0

    Default Re: Subtotal showing with Tax, need it without.

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

  8. #8
    Join Date
    Jul 2012
    Posts
    16,719
    Plugin Contributions
    17

    Default Re: Subtotal showing with Tax, need it without.

    Quote Originally Posted by saidkouki View Post
    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

 

 

Similar Threads

  1. Custom OT Module, Subtotal without tax
    By teva in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 9
    Last Post: 28 Feb 2012, 09:57 PM
  2. Showing price with and without tax
    By raymasa in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 19
    Last Post: 25 Jan 2011, 07:22 AM
  3. Replies: 0
    Last Post: 1 Dec 2010, 09:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR