How to exclude tax on Order Confirmation

[kanine]

After searching the forum I was unable to find a solution to this issue.

I would like to display Tax Inclusive site to shoppers but when the Order Confirmaton email gets generated I would like this to exclude the amount.

For example, with the current configuration the following lines appear:

1 x A4 Plastic Spiral 6mm & 4:1 Lengths (Box 100) 22mm (SP017)
Colour Black $44.00
---------
Sub-Total: $44.00
GST: $4.00
Total: $44.00

I would like this to show:

1 x A4 Plastic Spiral 6mm & 4:1 Lengths (Box 100) 22mm (SP017)
Colour Black $40.00
---------
Sub-Total: $40.00
GST: $4.00
Total: $44.00

Any help would be greatly appreciated. I am already aware of the Setting "Display Prices with Tax in Admin", which shows the correct pricing when I select "Invoice" from the "Orders" menu. But I need to exclude the tax amount from the order confirmation to avoid confusion.

[fairestcape]

I would like this to show:

1 x A4 Plastic Spiral 6mm & 4:1 Lengths (Box 100) 22mm (SP017)
Colour Black $40.00
---------
Sub-Total: $40.00
GST: $4.00
Total: $44.00

Surely you mean:

Price shown in the shop:-
1 x A4 Plastic Spiral 6mm & 4:1 Lengths (Box 100) 22mm (SP017)
Colour Black $44.00

---------

Order Total at Checkout
Sub-Total: $40.00
GST: $4.00
Total: $44.00

[fairestcape]

Not sure if I'm absolutely right here, but I seem to remember something like this being discussed before, and the challenge is that the TAX amount is not stored in the database. It's calculated on-the-fly, so it can't be pulled from a table.

I also recall seeing something that will allow you to display the NETT PRICE and the GROSS PRICE in your product screens (so it shows the price EX GST and the price INC GST). Maybe called "dual pricing".

Do a search for this... it may be your only viable option.

[kanine]

Surely you mean:

Price shown in the shop:-
1 x A4 Plastic Spiral 6mm & 4:1 Lengths (Box 100) 22mm (SP017)
Colour Black $44.00

---------

Order Total at Checkout
Sub-Total: $40.00
GST: $4.00
Total: $44.00

No I meant it should show $40. That's because the order confirmation will be entered into another invoicing system and we want to avoid entering a tax inclusive amount. Therefore it's important to show the price excluding GST in the order confirmation.

[fairestcape]

Then it's quite straight forward:-

ADMIN>>>CONFIGURATION>>>MY STORE>>>Display Prices with Tax (set to FALSE).

Now, you have to make sure you have tax classes set up and configured to apply to relevant zones.

Then, when your zones and taxes are properly configured, you input your product data, making sure to select the relevant tax class, and apply the nett price:-



If you get all these settings right, your STORE will display prices excluding GST, but at checkout, they will see the TAX amount reflected before the total.

[fairestcape]

Not sure what country you are based in, but here in the UK it's illegal to display products prices EXCL tax if you sell to the public. This is true EVEN IF you make the statement that prices exclude tax! In the UK, the displayed price is understood to be INCLUSIVE of sales tax.

In UK, if you sell wholesale (to trade customers only) then you can display prices ex vat.

[kanine]

Thanks, but I already knew this. Making these changes does not have the desired effect on the 'Order Confirmation' email as I posted. I tried this several times today and the Order confirmation note sent to the administrator always includes the Tax on the lines. If you look at the Invoice it's OK but I specifically want the non-tax amount in the order confirmation as it is this document that is used as the handshake between online ordering and the dispatch and invoice process run within the firms standard Order system.

[fairestcape]

Here's a screenshot of an order confirmation e-mail that one of our webshop sends out.

I believe it is showing the data as you want it - or am I wrong?

[kanine]

What I was trying to get is the GST excl amount on the order confirmation email lines. Having the tax included is the standard behaviour which is OK in general as you say its normal to show the tax inclusive price when dealing with the public. But I need this email to be entered into a system which by and large deals with trade accounts. The system operates predominantly in non-GST mode for that reason. It can be switched to an 'inclusive pricing mode' but in order to avoid confusion with accounts I wanted to provide them with a consistent pricing method.

Perhaps I need to look at another method, I found in order.php I can easily remove the tax from the lines, but still working on how the subtotal could be changed to be exclusive.

But I think what I really need is two emails, one for the customer who may or may not be a trade business so can show GST incl, and one for accounts with the GST removed.