Post by skip » Sat Nov 12, 2016 7:24 pm

I must delete all products except products in one category (there is 3000 products in 50 categories at all). Is there any idea how to delete all products from all categories except one. ? Directly in php my admin or another way. Thanks

Active Member


Mon May 09, 2011 9:57 pm

Post by rjcalifornia » Sun Nov 13, 2016 11:08 am

You have to do it through the Admin interface. You could set the status of the products that you don't want to delete to "disabled", filter the "enabled" products and delete them.

Alternatively, you can use PHPMyAdmin, but you have to make sure you know what you are doing or you will destroy the database.


Active Member


Fri Sep 02, 2011 1:19 pm
Location - Worldwide

Post by thekrotek » Sun Nov 13, 2016 6:18 pm

The best way to do this is directly in database editor like PHPMYAdmin. The query is a bit complext though.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by

User avatar
Expert Member


Sun Jul 03, 2016 12:24 am

Who is online

Users browsing this forum: No registered users and 29 guests