protechtrader Posted April 27, 2016 Share Posted April 27, 2016 Hello, I was working with my database on a test server clearing out old stats and analytics from a big prestashop database and I found the next largest database table after the stats was ps_stock_available and since this store did not need stock, and has stock management disabled I was wondering if I could truncate it, Tried it on my test server and found I could not purchase my products with combinations. The second attribute's values were empty on the front end, like they were unavailable. So I just restored the test server 15 minutes and no problem, but I wanted to see if I needed my ps_stock_available table, and I see I must need some of it by my little experiment , so I just wanted to ask if there is any fat i can prune there in a for a store not using stock management? Thanks Link to comment Share on other sites More sharing options...
musicmaster Posted April 28, 2016 Share Posted April 28, 2016 Did you do in Preferences->Products and disable the "enable stock management" option? Did you also enable the "Allow ordering out-of-stock products" option? 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