delroyp Posted May 17, 2013 Share Posted May 17, 2013 How to remove "not active" products in prestashop in bulk? HELP! Link to comment Share on other sites More sharing options...
vekia Posted May 17, 2013 Share Posted May 17, 2013 you want to delete all products which aren't active, am I right? Link to comment Share on other sites More sharing options...
delroyp Posted May 17, 2013 Author Share Posted May 17, 2013 you are correct Link to comment Share on other sites More sharing options...
delroyp Posted May 17, 2013 Author Share Posted May 17, 2013 can you help? Link to comment Share on other sites More sharing options...
vekia Posted May 17, 2013 Share Posted May 17, 2013 Sure, it's easy to achieve, but i must know what prestashop version you use. let me know and I will help you Link to comment Share on other sites More sharing options...
delroyp Posted May 20, 2013 Author Share Posted May 20, 2013 PrestaShop™ 1.4.9.0..... I would like to upgade to 1.5.4.1 stable ! but Thats another story.. Link to comment Share on other sites More sharing options...
vekia Posted May 20, 2013 Share Posted May 20, 2013 use this sql query: DELETE FROM ps_product WHERE active = 0 remember to make backup of your database before you run this query Link to comment Share on other sites More sharing options...
delroyp Posted May 23, 2013 Author Share Posted May 23, 2013 (edited) That worked Thank you very MUCH!!! Edited May 23, 2013 by delroyp (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted May 23, 2013 Share Posted May 23, 2013 you're welcome i marked this thread as solved if you've got any other questions related to this case - feel free to continue discussion here regards Link to comment Share on other sites More sharing options...
delroyp Posted May 24, 2013 Author Share Posted May 24, 2013 hi... can you tell me why my "No Image Available" graphic is not showing? http://www.directpv.com/en/2700659-prosolar-gt-drill-base.html Link to comment Share on other sites More sharing options...
zelakioui Posted July 6, 2015 Share Posted July 6, 2015 (edited) I have the same problem with prestashop 1.6.0.14, please i need help ! Edited July 6, 2015 by zelakioui (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts