Hossalem Posted August 19, 2019 Share Posted August 19, 2019 Hello everyone, We are in need of having a table of products showing the current setting of the 'When out of stock' option. We have tried ps_product but the entries in the field 'out_of_stock' do not reflect the current setting. also we tried ps_stock_available but it does not cover all our catalogue and some products are missing. Can anyone help how we can have a table showing the currently set option for the 'when out of stock' field in the product configuration? We need this to review our current settings and make corrections where necessary. Thank you, Hossein Link to comment Share on other sites More sharing options...
NemoPS Posted August 19, 2019 Share Posted August 19, 2019 It's in ps_product_shop as well, quite deceiving indeed. Got me too. Link to comment Share on other sites More sharing options...
Hossalem Posted October 11, 2019 Author Share Posted October 11, 2019 Thank you! Link to comment Share on other sites More sharing options...
kam0200 Posted April 8, 2020 Share Posted April 8, 2020 Hello, I was trying determine the same and found setting per product in ps16_stock_available table SELECT * FROM ps16_stock_available where out_of_stock=1 , gives me products when could be ordered even without stock Thanks, Kamil 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