Hello, i have a little problem on a website created on Joomla [url removed, login to view] and Virtuemart [url removed, login to view], the shop was started with a Tax 21% and all the product and shipping method had this Tax. Then i have deleted all the category and all products, leaving the shipping methods because are over 100 different.
Now the Tax is changed from 21% to 22% and i have created in Tax & Calculation Rule a new Tax with 22% (disabling 21%), thinking that all the shipping methods change the tax.
I entered in Shipping methods and take one to check the change, i have seen that the Tax is the old 21% (because i have not selected Apply default rules)
The request of solution:
How to change massive shipping Tax from 21% to 22% using a SQL query ?
How to change massive shipping Tax from 21% to Apply default rules using a SQL query ?
I not know SQL code programming and not know how to resolve this problem, I hope someone can help me. thank you.
Hi i have more then 6 year experience in this fields.. i have already done Joomla and virtumart related work many time.. so i am ready to start this work Thanks