News:

Support the VirtueMart project and become a member

Main Menu

How to: No more VAT for a store

Started by Mister Paul, January 15, 2019, 00:03:19 AM

Previous topic - Next topic

Mister Paul

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

GJC Web Design

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 [url="https://www.gjcwebdesign.com"]https://www.gjcwebdesign.com[/url]
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
[url="https://extensions.joomla.org/profile/profile/details/67210"]https://extensions.joomla.org/profile/profile/details/67210[/url]
Contact for any VirtueMart or Joomla development & customisation

Studio 42

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.
Free XML sitemap generator [url="http://shop.st42.fr/en/catalog/products/virtuemart-2-sitemap.htm"]http://shop.st42.fr/en/catalog/products/virtuemart-2-sitemap.htm[/url]  , Free Unused Image cleaner [url="http://shop.st42.fr/en/products/virtuemart-media-folder-clear.htm"]http://shop.st42.fr/en/products/virtuemart-media-folder-clear.htm[/url]
Language Switch in product & category [url="http://shop.st42.fr/en/categories-tools/multi-language-for-virtuemart.htm"]http://shop.st42.fr/en/categories-tools/multi-language-for-virtuemart.htm[/url]
More extentions [url="http://shop.st42.fr/en/"]http://shop.st42.fr/en/[/url]