My Free Shipping is being calculated after tax is added

Question

I’m trying to setup $50 free shipping but when I add products that add up to $47.00 the tax kicks it over and allows free shipping. I can’t believe this is standard so I must have something set up wrong. I have the Free Shipping set up under the carriers, FedEx and USPS.

I have “Apply Discount On Prices = Excluding Tax” set in Config/Sales/Tax which seems to be what I’m after. I've also tried the Free Shipping method in Shipping Methods.

Answer 1

3 steps: 1. Edit Freeshipping.php app/code/core/Mage/Shipping/Model/Carrier/Freeshipping.php Look for getBaseSubtotalInclTax and change to getBaseSubtotal

2. Setup Shopping Cart Pricing Rules. Go to Promotion > Shopping Cart Pricing Rules > Setup "Subtotal equals or greater than 50".

3. Enable Freeshipping Module System > Configuration > Shipping Methods > Setup "Minimum Order Amount" = 50.

Boom! Your freeshipping calculation will exclude taxes.

If you don't want to modify core files. Copy the Freeshipping.php to app/code/local/Mage/Shipping/Model/Carrier/Freeshipping.php

Answer 2

I have this configuration on my rates, and it works as you want:

Type of tax Type of tax: shipping

Calculation settings:

Tax Calculation Method Based On "total price"

Tax Calculation Based On "shipping addres"

Catalog Prices "including tax"

Shipping Prices "including tax"

Apply Customer Tax "before discount"

Apply Discount On Prices "excluding tax"

Apply Tax On "personalized price if available"

Price display settings

Display Product Prices In Catalog "including tax"

Show shipping price "including tax"

Shopping cart display settings

"including tax"

"excluding tax"

"excluding tax"

"No"

"No"

"No"

Orders, invoices, credit memos display settings

"including tax"

"excluding tax"

"excluding tax"

"No"

"No"

"No"

Fixed product taxes

"No"

"Including FPT only"

"Including FPT only"

"Including FPT only"

"Including FPT only"

"No"

"No"

"No"

This configuration works fine for me... Hope this helps!