7
votes

I’ve implemented a Table Rate Shipping system on my shop, based on a “Price vs Destination” condition. However, I’ve noticed that the shipping is calculated on the sub total of the basket (exc. VAT/Tax) instead of the Grand total (inc. VAT/Tax). How do I get Magento to base the shipping on the grand total, rather than the subtotal?

UPDATE: The version of Magento I'm using is Version 1.5.0.1.

3
I don't think this is possible. I've solved this by modifying the tablerates.csv . e.g. if you have free shipping above 55€ you write in your tablerates 45 (in my country we have 22% tax so 45*1,22 = 55)karantan

3 Answers

3
votes

Just on the back of the comments to huzefam's answer - you have mentioned VAT and are in the UK so I'm thinking maybe the GB language pack has been installed, in which case your path will be System -> Configuration -> Sales -> VAT submenu header -> Tax Classes and then you change the VAT Class for Delivery option.

See image below;

enter image description here

2
votes

Go to : System -> Configuration -> Sales -> VAT Check Calculation settings and try the following 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"

source : My Free Shipping is being calculated after tax is added

for more informations see :

1
votes

You can enable tax for your shipping from admin in System>Configuration>Tax>Tax Classes>Tax Class for shipping

Hope this solves your problem :)