helikoptermannen Posted March 13, 2015 Share Posted March 13, 2015 (edited) I want to set the "displayed text when back-ordering is allowed" to many products. Instead of doing this one by one I would like to set it in DB. But where in the DB do I find this? Edited March 13, 2015 by helikoptermannen (see edit history) Link to comment Share on other sites More sharing options...
rocky Posted March 14, 2015 Share Posted March 14, 2015 It's the available_later column in the ps_product_lang table. You can use an SQL query like the following to update them all at once: UPDATE `ps_product_lang` SET `available_later` = 'In stock' WHERE `id_lang` = 1 Change ps_ to your database prefix, 'In stock' to your new translation and 1 to the appropriate language ID for your translation. Link to comment Share on other sites More sharing options...
helikoptermannen Posted March 14, 2015 Author Share Posted March 14, 2015 Thanks a lot! In my case I will update a few hudred products (have 5500 total) so I guess it will be like: (...) WHERE id_lang = 1 AND id_product = (SQL statement that gets the Product id´s i want) Link to comment Share on other sites More sharing options...
rocky Posted March 14, 2015 Share Posted March 14, 2015 Try: WHERE id_lang = 1 AND id_product IN (1, 2, 3) 2 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