jahyax Posted February 4, 2014 Share Posted February 4, 2014 I would like to know what is the equivalent database field for the status of product (active:0/1) from product lis Product List Back Office = PhpMyAdmin Status = (active:0/1) = ???????(what is the data table and fields) Thanks, JahyaX Link to comment Share on other sites More sharing options...
vekia Posted February 4, 2014 Share Posted February 4, 2014 ps_product_shop table there is an field ACTIVE with values: 1 - product active 0 - product disabled 1 Link to comment Share on other sites More sharing options...
jahyax Posted February 4, 2014 Author Share Posted February 4, 2014 Thanks Vekia, with your answer I managed to create a proper query for the product list that i need to get from the database, again Thank you Link to comment Share on other sites More sharing options...
vekia Posted February 4, 2014 Share Posted February 4, 2014 you're welcome glad to hear that i could help you a little i marked whole topic as solved. with regards, Milos Link to comment Share on other sites More sharing options...
Prestashop Guru Posted October 1, 2015 Share Posted October 1, 2015 Hi, i've a problem with my ps 1.6.1 if i set from bo the state= false i see the value change on db but if i change the active value i don't see any different on bo and fo Why? How can i solve? Link to comment Share on other sites More sharing options...
xavibj Posted October 27, 2015 Share Posted October 27, 2015 Hi, I have the same problem. Maybe a cache ussue. Any thoughts? Xavi. Link to comment Share on other sites More sharing options...
Prestashop Guru Posted October 27, 2015 Share Posted October 27, 2015 try to set "active" from ps_product 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