You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
UPDATE `gbu0_prod` SET regprice = ROUND(regprice * 1.05,2) WHERE clearance = '1';
This updates a price by 5% and rounds it off to 2 decimal places. - Just use it in the store backend as you would any other MySQL raw statement.
Offline