Dirty Butter Posted May 1, 2013 Share Posted May 1, 2013 I need to multiply the values in the price column of the _inventory table by .90 to lower the price of all items with a price over $10.00 by 10%. Then I'll need to do something similar to lower by 10% the quantity break prices for those that have quantity discounts. I would also like to TRUNCATE both these resulting values to the nearest whole number. Could someone tell me what the queries should be in phpmyadmin? Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 2, 2013 Author Share Posted May 2, 2013 http://www.cubecartforums.org/index.php?showtopic=17869&st=0&gopid=72911&#entry72911 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.