News:

Looking for documentation? Take a look on our wiki

Main Menu

Clean up orphaned products?

Started by EvanGR, October 01, 2019, 13:53:33 PM

Previous topic - Next topic

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Studio 42

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