Clean up orphaned products?

[EvanGR]

Hello,

I have manually removed products from database, based on canonical category id (i.e. I wanted to remove all products from a specific category so that I will reimport them).
However, this has left me with orphaned product entries in the products_el_gr table (which I cannot selectively delete because there is no canonical category id column).

How do I clean up these orphaned products?

And, even better, how do I cleanly remove all products from a category? (assume thousands of them)

Thanks

[Jörgen]

Patrick in Studio42 has a BE component that can help You with this. I use it myself from time to time.

Jörgen @ Kreativ Fotografi

[Studio 42]

Patrick in Studio42 has a BE component that can help You with this. I use it myself from time to time.

Jörgen @ Kreativ Fotografi

Yes, you can remove 1000 products in one time using Vm Be Pro and filtered by category.
If you have childrens, you can use the specific child tree options, so the childrens are display with parent as a tree(parent can be in a category)
See https://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm