Kryptronic Software Support Forum
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.
#1 02-16-2011 14:37:01
- Design_Wholesale
- Member
- From: England!
- Registered: 11-21-2008
- Posts: 1104
- Website
Quick + Easy Price Amendments With A Single MySQL Statement...
Code:
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