Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / Coupon and Shipping with VAT issues 1.3.9h

Coupon and Shipping with VAT issues 1.3.9h

Views: 1,746

Results 1 to 8 of 8
5 May 2011, 11:53 AM
#1
calljj avatar

calljj

Zen Follower

Join Date:
Mar 2007
Posts:
253
Plugin Contributions:
2

Coupon and Shipping with VAT issues 1.3.9h

Hi, been searching through the posts but still not found the solution, although have found my files contain the bugfixes that have been posted previously.
using 1.3.9h.

Setup is:
shipping price includes vat
all prices displayed with vat
10% discount coupon
coupon admin setup:
include shipping, false;
include VAT, false;
recalc, standard;
tax class, VAT (20%)

Go to checkout:

Sub-Total: £349.30

        Royal Mail **special**delivery next day (Great Britain & Northern Ireland only):£22.08 
       Discount Coupon:-£34.56 

Total:£336.82

Very strange as the discount should be just a straight 34.93 , so we are 37p short.....not such a prob for me, but you jnow what customers are like!

It must be related to the shipping somehow, as if i go for free shipping option during checkout it works fine!

Sub-Total: £349.30

        Discount Coupon:-£34.93  

Total:£314.37

Which means that when shipping is enabled the calc is doing some very funny things as explained below where I beleive the 37p is derived from:

10% of the shipping cost is 2.208
vat content = 2.208 - (2.208/1.2)
The vat content of 2.208 is 37p (if rounding up to 2.21)

So the calculation is taking 10% of the value of the shipping cost, then calculating the vat content of that value, then deducting it from the value of the coupon!

Any ideas?????

9 May 2011, 12:32 PM
#2
minotaurus avatar

minotaurus

New Zenner

Join Date:
Oct 2010
Posts:
7
Plugin Contributions:
0

Re: Coupon and Shipping with VAT issues 1.3.9h

Hi there
Im having same problem.

But the thing is we are losing ,60 to ,90 € each order.

My boss is REALLY :censored: off and its expected that I have to pay that calculation mistakes... :no:

if I switch include shipping to TRUE, the coupon calculates perfectly

or If i change the cost of the shipping method ( in shipping methods panel ) to ZERO everything goes ok too

Also, normal customers that match more than 80€ in their orders, they get freeshipping and in those cases calculation of coupon is going ok too

so it seams shipment fee is doing something strange

please I need help URGENTLY

my version is
Zen Cart 1.3.8a

11 May 2011, 1:36 PM
#3
hairydog avatar

hairydog

Zen Follower

Join Date:
Sep 2006
Posts:
165
Plugin Contributions:
0

Re: Coupon and Shipping with VAT issues 1.3.9h

I wonder if the people with this problem also have Price Sensitive Discount (Order Total Discount) installed?

The discount codes seem to calculate correctly as long as Price Sensitive Discount is set to a higher figure than the order total, or not installed. Switching it off does not seem to work.

Iain

11 May 2011, 4:09 PM
#4
calljj avatar

calljj

Zen Follower

Join Date:
Mar 2007
Posts:
253
Plugin Contributions:
2

Re: Coupon and Shipping with VAT issues 1.3.9h

hairydog:

I wonder if the people with this problem also have Price Sensitive Discount (Order Total Discount) installed?

Iain

Nope, not installed.

13 May 2011, 4:38 AM
#5
minotaurus avatar

minotaurus

New Zenner

Join Date:
Oct 2010
Posts:
7
Plugin Contributions:
0

Re: Coupon and Shipping with VAT issues 1.3.9h

ok everybody

I found the solution :clap::clap::clap:

visit this link and do everything they say.

http://www.zen-cart.com/forum/showthread.php?t=150689

yo have to edit 3 files

16 May 2011, 8:17 AM
#6
calljj avatar

calljj

Zen Follower

Join Date:
Mar 2007
Posts:
253
Plugin Contributions:
2

Re: Coupon and Shipping with VAT issues 1.3.9h

Hi,

that link you posted to for the 3 mods have already been included in the 1.3.9.h files, and do not resolve the problem...

J

27 May 2011, 12:41 PM
#7
calljj avatar

calljj

Zen Follower

Join Date:
Mar 2007
Posts:
253
Plugin Contributions:
2

Re: Coupon and Shipping with VAT issues 1.3.9h

any one have any idea, really need the discount coupons to work

27 May 2011, 2:31 PM
#8
calljj avatar

calljj

Zen Follower

Join Date:
Mar 2007
Posts:
253
Plugin Contributions:
2

Re: Coupon and Shipping with VAT issues 1.3.9h

found out that by commenting out the following line in the file
includes/modules/order_total/ot_coupon.php

if ($this->include_shipping != 'true') $order_total_tax -= $order->info['shipping_tax'];

makes it work.