We're working on 2.4 with shipping costs. We have free shipping at all orders £40 and over. This is set in Matrix Rates tablerates.csv. The problem is that is it excluding tax in the rule. So an order that is £40 and above should bring up the free postage option but it doesn't until you reach approx £47 (£7) tax. We need the tax to be included in the overall order value to calculate shipping correctly. How do we go about doing this? Matrix Rates support informed me that this is something that needs to be done in Magento and can not be done via tablerates.csv.
Solved! Go to Solution.
Are you displaying tax inclusive prices in your catalog/shipping? Stores > Configuration > Sales > Tax
I personally think this is a bug introduced since 2.3.5 that has not been addressed as yet by the devs. Magento seems to use the tax exclusive price to calculate whether discounts apply despite whatever settings you have chosen in configuration.
As described here, commenting out lines 599-600 in file
addressed this issue for me. But it is only a short-term solution, your mileage may vary.
Tax is just one of those things that proves very difficult for programmers as its application varies widely dependent on user country.
From what I know, the new Matrix Rates' update includes the tax in the price. If you didn't make it or it doesn't work for you, you have to change it. You could ask an advisor to help you develop software to calculate it or find new apps that do. At the moment, most of my international deliveries are from a Chinese delivery company. I like it because it includes the final price taxes and has speedpak tracking. Taxes are essential and should be calculated correctly. However, this is not something the customer has to do.