Zen Cart Logo
Forums / Bug Reports / [Done 155b] Shipping tax not added in order confirmation - possible bug??

[Done 155b] Shipping tax not added in order confirmation - possible bug??

Views: 53,229

Results 1 to 20 of 103
26 May 2016, 8:11 AM
#1
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

[Done 155b] Shipping tax not added in order confirmation - possible bug??

Just discovered a weird isue on a store upgraded from 1.5.4 to 1.5.5a with the shipping tax being correctly added in the front end (checkout pages) but the shipping tax is not added to the shipping charge in the order and the invoice.

Never noticed this until now since all other orders were over the free shipping limit of $150 hence no shipping is charged.

During the checkout process the shipping shows correctly at say $8.00 but the customer order confirmation shows $7.27 (tax is 10%, $7.27 excl + 10% tax = $8.00).

When I did the upgrade I uninstalled then re-installed the relevant Zones module and entered all values as they were in 1.5.4 - had no issues with the old ZC version. No other changes in the general tax setup has been made, same stuff now as it was in 1.5.4

No coupons, no nothing else involved........

So I double-checked the code for the zones module and it is exactly the same as in the install file set (bar the fact that it is a clone (always has been for years), all renamed from zones to zones4 in the clone). Also compared again various functions (general, prices, taxes) in the includes/functions folder to eliminate any merging errors. Order.php class is ok as well. No upgrading/merging mistakes made..... all looks as it should.

Bottom line is that I am stumped.

Could this be a bug??

Or am I missing something??

Thanks / Frank

26 May 2016, 8:56 AM
#2
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

I was going to place a bug report myself, but you beat me to it.
I was called by a customer yesterday, which i recently upgraded from Zen Cart 1.5.4 to Zen Cart 1.5.5a that in his shop the shipping tax is not calculated on the order confirmation page. The shipping module used, is the table module. In Zen Cart 1.5.4 this problem did not exist.
This is shown on the order_confirmation page
Attachment 16356
and this on the checkout_success
Attachment 16357
As you can see the shipping tax is missing.

The weird thing is when I use the zones module all goes well.
This is a store with almost no modifications, except for IH4, and mobizencart (mobile theme), but those have no effect on the check out process.

Tax settings are:
Attachment 16358

Serverinfo:
HTTP Server: Apache
PHP versie: 5.3.28 (Zend: 2.3.0)
Database: MySQL 5.5.44-0ubuntu0.12.04.1

I also tested on a vanilla install, and that gives the same result

26 May 2016, 9:24 AM
#3
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

Design75:

I was going to place a bug report myself, but you beat me to it.
I was called by a customer yesterday, which i recently upgraded from Zen Cart 1.5.4 to Zen Cart 1.5.5a that in his shop the shipping tax is not calculated on the order confirmation page. The shipping module used, is the table module. In Zen Cart 1.5.4 this problem did not exist.
This is shown on the order_confirmation page....

Now that is interesting.... only diff is that I am using a Zones module.

It displays correctly on the order_confirmation page but is wrong in the order email and invoice, customer is also not charged any tax with whatever payment module they are using (PayPal, eWay, Direct Bank Deposit ... same issue).

My (local) server setup is

   **Server Host:** arcturus (127.0.1.1)
   **Server OS:** Linux 3.19.0-32-generic 
   **Server Date:** 26/05/2016 19:15:04  
   **Server Up Time:** Disabled/Unavailable
   **HTTP Server:** Apache/2.4.7 (Ubuntu)
   **PHP Version:** 5.5.9-1ubuntu4.17 (Zend: 2.5.0)
   **PHP File Uploads:** On
   **Upload Max Size:** 64M
   **PHP Memory Limit:** 256M
  **POST Max Size:** 64M
   **Database:** MySQL 5.5.49-0ubuntu0.14.04.1
   **Database Host:** localhost (127.0.0.1)
   **Database Date:** 26/05/2016 19:15:04
   **Database Data Size:** 33,769 kB
   **Database Index Size:** 5,632 kB
   **MySQL Slow Query Log Status:** On
   **MySQL Slow Query Log File:** /var/lib/mysql/arcturus-slow.log

Slightly better on the live store (eg PHP 5.6 etc etc) other than that it is the same.

My tax setup is exactly the same as yours (and has been for yonkers without probs)

Store history is:
Zen Cart 1.5.5a

 **Database Patch Level:  1.5.5**

v1.5.5 [2016-05-01 18:29:21] (Version Update 1.5.4->1.5.5)
v1.5.4 [2015-01-11 04:53:20] (Version Update 1.5.3->1.5.4)
v1.5.4 [2015-01-11 04:52:18] (Version Update 1.5.3->1.5.4)
v1.5.3 [2014-08-11 10:16:37] (Version Update 1.5.2->1.5.3)
v1.5.2 [2014-08-11 10:16:37] (Version Update 1.5.1->1.5.2)
v1.5.1 [2013-12-29 11:23:19] (Version Update 1.5.0->1.5.1)
v1.5.0 [2013-12-29 11:23:19] (Version Update 1.3.9->1.5.0)
v1.3.9c [2010-06-11 23:19:47] (Version Update 1.3.8->1.3.9c)
v1.3.9c [2010-06-11 23:12:13] (Version Update 1.3.8->1.3.9c)
v1.3.8 [2010-06-11 23:12:12] (Version Update 1.3.7->1.3.8)
v1.3.7.1 [2007-10-24 21:50:38] (Fresh Installation)
v1.3.7.1 [2007-10-24 21:50:38] (Fresh Installation)

Cheers / Frank

26 May 2016, 12:49 PM
#4
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

frank18:

..... customer is also not charged any tax with whatever payment module they are using (PayPal, eWay, Direct Bank Deposit ... same issue)....

Need to clarify that the customer is not charged tax on shipping - products are being charged ok.

26 May 2016, 1:03 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

Doesn't seem to happen with US addresses...or is it maybe specific to tax-included pricing?

26 May 2016, 1:11 PM
#6
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

DrByte:

......or is it maybe specific to tax-included pricing?

Sorry Doc, not sure what you mean with that?

26 May 2016, 1:12 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

I rarely use the store in "display prices with tax included " enabled. But I'm guessing that's the only way you use it. Is this isolated to that scenario?

26 May 2016, 1:14 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

What are your settings on the specific Shipping Module?

What are the settings on the Zone Definition and Details used for your Tax Class for shipping?

26 May 2016, 1:24 PM
#9
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

DrByte:

I rarely use the store in "display prices with tax included " enabled. But I'm guessing that's the only way you use it. Is this isolated to that scenario?

That's the law in the country of Oz, tax must me included in the prices shown. It worked perfectly since 2007 up to ZC 1.5.4 , so I don't know what happened after upgrading.

26 May 2016, 1:33 PM
#10
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

Ajeh:

What are your settings on the specific Shipping Module?

What are the settings on the Zone Definition and Details used for your Tax Class for shipping?

Thanks Ajeh,

In the Zone defintions only the country is selected. No change since 2007 ....

Shipping is classed as Taxable Goods

26 May 2016, 1:37 PM
#11
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

Just for giggles and grins ... peek at the Zone Details, do you have each of the Zones selected or does it read Please Select?

If it reads Please Select, what happens if you add each of the Zones listed?

26 May 2016, 1:46 PM
#12
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

Ajeh:

Just for giggles and grins ... peek at the Zone Details, do you have each of the Zones selected or does it read Please Select?

If it reads Please Select, what happens if you add each of the Zones listed?

Will do that immediately after I filled my face with some (home made ) pizza :smile: - please bear with me....

26 May 2016, 2:16 PM
#13
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

frank18:

That's the law in the country of Oz, tax must me included in the prices shown. It worked perfectly since 2007 up to ZC 1.5.4 , so I don't know what happened after upgrading.

It is the law in most European countries.

26 May 2016, 2:20 PM
#14
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

Ajeh:

Just for giggles and grins ... peek at the Zone Details, do you have each of the Zones selected or does it read Please Select?

If it reads Please Select, what happens if you add each of the Zones listed?

This is what I have:
Attachment 16359

And I have no zones for the Netherlands. Never had, because there is no need for. We do not use them for taxes or shipping.

26 May 2016, 2:50 PM
#15
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

Ajeh:

Just for giggles and grins ... peek at the Zone Details, do you have each of the Zones selected or does it read Please Select?

It reads 'Please Select' but never had to do that in previous ZC versions - always worked for all sub zones with only Australia selected as a zone in relevant local shipping modules.

26 May 2016, 2:51 PM
#16
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

Does this mean that it is working now? :lookaroun

26 May 2016, 2:53 PM
#17
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

Ajeh:

Does this mean that it is working now? :lookaroun

Nope, same in another test order, shipping cost shows excluding tax (as above)

26 May 2016, 2:55 PM
#18
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

What Country are you testing for?

26 May 2016, 2:56 PM
#19
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

Ajeh:

What Country are you testing for?

Just Australia - that's where the issue appeared since upgrading to 1.5.5a

26 May 2016, 3:06 PM
#20
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: [Done 155b] Shipping tax not added in order confirmation - possible bug??

And you have each Zone for Australia added individually in the Zone Details, correct?