ccw0103 Posted April 10, 2015 Share Posted April 10, 2015 Hello, I used to disable stock management and so some of the stock level is now negative, right now I would like to enable this feature but now can I reset the stock level to 0/100 etc? I have over 1000+products so setting them manually is a pain in the butt..... Cheers Link to comment Share on other sites More sharing options...
NemoPS Posted April 10, 2015 Share Posted April 10, 2015 Do you want to set each of them to a specific number? If you don't care about stock movements right now, and you want to set all of them to the same amount, say 100, I would go for a SQL query Link to comment Share on other sites More sharing options...
ccw0103 Posted April 10, 2015 Author Share Posted April 10, 2015 Hi Nemo, Setting them all to 100 would be perfect for me, how can I do this? Is it safe? I am no programming expert so this is a little bit scary for me Link to comment Share on other sites More sharing options...
NemoPS Posted April 10, 2015 Share Posted April 10, 2015 Ok, then make a backup copy of the database first. Then login to phpmyAdmin, select your server and click on the SQL tab. Try running thisUPDATE ps_stock_available SET quantity = 100 WHERE quantity <= 0 This will set to 100 the stock level of all products that have it below or equal to 0 Link to comment Share on other sites More sharing options...
ccw0103 Posted April 10, 2015 Author Share Posted April 10, 2015 Thanks, it works brilliantly Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
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