VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: Mister Paul on January 15, 2019, 00:03:19 AM

Title: How to: No more VAT for a store
Post by: Mister Paul on January 15, 2019, 00:03:19 AM
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...


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 »


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
Title: Re: How to: No more VAT for a store
Post by: GJC Web Design on January 15, 2019, 15:30:31 PM
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
Title: Re: How to: No more VAT for a store
Post by: Studio 42 on January 16, 2019, 00:58:21 AM
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.