[ SOLVED ] Add Discount override to all products via SQL

[bunglehaze]

Hi Guys, I have just added a discount to multiple categories and have found that a load of products do not have the default override option in place, I have looked through the DB and cannot which setting I need to change via phpmyadmin to enable it on all products - can one of you guru's give me a pointer please.

thanks

[chetanmadaan]

Hey... there are two options with the override...

Overwrite final and Overwrite price to be taxed

which one are we looking at?

BACKUP BEFORE YOU RUN THIS QUERY
Anyways... you can run this query.

Code Select Expand

UPDATE `#__virtuemart_product_prices` SET  `override` =  '1', product_override_price = 10 WHERE  `#__virtuemart_product_prices`.`product_override_price` = '0.000'
remmember to replace #__ with your table prefix.
The default override price is 0.000

[bunglehaze]

Hi there, thanks. I should have updated the thread to say I figured it out eventually.