Igor_MM Posted May 27, 2023 Share Posted May 27, 2023 Hi, Can you help me, i need sql command to change status of my products, from active 0 to active 1 so my products are all active (i have curently 30.000+ on inacitve status) thx Link to comment Share on other sites More sharing options...
juanrojas Posted May 27, 2023 Share Posted May 27, 2023 try the following UPDATE `ps_product` SET `active` = 1; UPDATE `ps_product_shop` SET `active` = 1; 1 Link to comment Share on other sites More sharing options...
Igor_MM Posted May 27, 2023 Author Share Posted May 27, 2023 worked like a charm 😁 big thx 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