Author Topic: How to: No more VAT for a store  (Read 545 times)

Mister Paul

  • Jr. Member
  • **
  • Posts: 222
  • Joomla! 3.9.6 - VirtueMart 3.4.2
How to: No more VAT for a store
« on: January 15, 2019, 00:03:19 am »

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:
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!


GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9654
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: How to: No more VAT for a store
« Reply #1 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
GJC Web Design
VirtueMart and Joomla Developers - php developers
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
Contact for any VirtueMart or Joomla development & customisation

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4331
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: How to: No more VAT for a store
« Reply #2 on: January 16, 2019, 00:58:21 am »
Mister paul,
You can batch change price using VM Be Pro see
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.