IOS eShop 2 + VAT

[rentasite]

Hi,

How can someone (massive) change the VAT for all the products, in IOS eShop 2 ?

[webgift]

To update price, VAT and discount for a product you have to edit the product.
If you have too many products go to phpmyadmin and just execute an SQL query like the one bellow.

UPDATE elx_eshop_prices SET tax='21.00' WHERE tax= '19.00'; (for IOS Eshop v2.x)

UPDATE elx_eshop_products SET tax='21.00' WHERE tax= '19.00'; (for IOS Eshop v1.x)


Original post by datahell : https://forum.elxis.org/index.php?topic=4111.msg28743#msg28743

[rentasite]

Beyond phpmyadmin plz, if there is any other way.

[webgift]

do You mean under administration area or to edit code of somewhere ?

[rentasite]

Administration area of course. I can't tell the client to edit the code