Print Page - [ SOLVED ] Add Discount override to all products via SQL

Title: [ SOLVED ] Add Discount override to all products via SQL
Post by: bunglehaze on November 21, 2012, 21:11:48 PM

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

Title: Re: Add Discount override to all products via SQL
Post by: chetanmadaan on November 22, 2012, 19:39:34 PM

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

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

Title: Re: Add Discount override to all products via SQL
Post by: bunglehaze on November 22, 2012, 22:28:44 PM

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

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: bunglehaze on November 21, 2012, 21:11:48 PM