goanta Posted July 19, 2013 Share Posted July 19, 2013 Hi, I would like to change the status of all the products in the shop to "unavailable for order" and im trying to avoid doing so for every product individually. On my localhost version of the store i went ahead and did a sql query for the database to help me change the values in ps_products in column "available for order" to 0. Please keep in mind that I am a novice when it comes to this stuff, but what i did charged nothing in the store. In back office all products still show as available for order. What am I missing, is there another step that i need to take? Any feedback would be greatly appreciated Link to comment Share on other sites More sharing options...
vekia Posted July 19, 2013 Share Posted July 19, 2013 if you're familiar with sql queries you can create the sql query to change this value for all products Link to comment Share on other sites More sharing options...
goanta Posted July 19, 2013 Author Share Posted July 19, 2013 Yes I did so im phpMyadmin. the database shows "product available to order" to be 0, but front office and bo products still show available for order. Link to comment Share on other sites More sharing options...
vekia Posted July 19, 2013 Share Posted July 19, 2013 what table you changed? Link to comment Share on other sites More sharing options...
goanta Posted July 19, 2013 Author Share Posted July 19, 2013 in ps_product, colum "available_for_order" Link to comment Share on other sites More sharing options...
vekia Posted July 19, 2013 Share Posted July 19, 2013 okay, now is everything clear you have to change also the value of this field in the ps_product_shop tab it's necessary regards Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 19, 2013 Share Posted July 19, 2013 you could also investigate using csv import if you go either way (mysql or csv) make sure to back up your database first... back up back up back up, enough said Link to comment Share on other sites More sharing options...
goanta Posted July 21, 2013 Author Share Posted July 21, 2013 Thank you Vekia, that worked like a charm also Thanks for the advice El Patron Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 21, 2013 Share Posted July 21, 2013 Vekia is a superstar.... 1 Link to comment Share on other sites More sharing options...
vekia Posted July 21, 2013 Share Posted July 21, 2013 Exactly the same as El Patron thread marked as [solved] 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