brad-w Posted August 10, 2010 Share Posted August 10, 2010 Hi, Just out of curiosity, is there any way to change the prices of all products at once? For example, increasing all product pricing by 20%?Thanks,Brad Link to comment Share on other sites More sharing options...
phrasespot Posted August 11, 2010 Share Posted August 11, 2010 Connect to your DB with MySQLAdmin or similar, issue the following command: UPDATE `ps_product` SET `price`=`price`* 1.2 Adjust parameter 1.2 as required. Link to comment Share on other sites More sharing options...
brad-w Posted August 11, 2010 Author Share Posted August 11, 2010 Your an all-star. Thanks a lot man, worked perfectly.Cheers! Link to comment Share on other sites More sharing options...
phrasespot Posted August 11, 2010 Share Posted August 11, 2010 Your an all-star. Not quite, glad it worked, not sure if your customers will be though Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now