Hi,
a shop that was managed by an a non-profit association was using VAT rules.
5,5% and 20% depending of the products.
This association is not anymore allowed to use VAT in its sellings.
They choose to keep the old price with VAT (=old final price) as the new base price
(so only pro customer will see the price difference)
As there are 1000 products in the store, I think that it would be better to use SQL query.
But I'd need your help...
1°
I think to do a request on that table:
_virtuemart_product_prices
that would multiply the « product_price » value by 1,055 or 1,2 depending of the value of the column « product_tax_id »
2°
Then I'd delete the 2 amounts of VAT in Virtuemart backend at PRODUCTS/Tax & Calculation Rule
Is that correct?
There is not some more VAT to modify in backend configuration or in some other tables?
Thanks for your help and your advises!
;-)
PAul
there is only 1 stored price in VM #__virtuemart_product_prices product_price so as u suggest u could just raise this by query the vat amount
another option is just keep the vat tax and hide it everywhere in the displays and cart
Mister paul,
You can batch change price using VM Be Pro see https://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm
You need to search/filter and select all products to batch process and open the accordion "Product Pricing".
You have to set Cost Price x1.2 to add 20% or Cost Price x1.055 to add 5,5% to the product base price and click the "process" button.