VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: EvanGR on October 01, 2019, 13:53:33 PM

Title: Clean up orphaned products?
Post by: EvanGR on October 01, 2019, 13:53:33 PM
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
Title: Re: Clean up orphaned products?
Post by: Jörgen on October 01, 2019, 15:00:04 PM
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
Title: Re: Clean up orphaned products?
Post by: Studio 42 on October 01, 2019, 15:07:09 PM
Quote from: Jörgen on October 01, 2019, 15:00:04 PM
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