Author Topic: Clean up orphaned products?  (Read 245 times)

EvanGR

  • Jr. Member
  • **
  • Posts: 282
Clean up orphaned products?
« 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

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 2464
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Clean up orphaned products?
« Reply #1 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
Joomla 3.9.8
Virtuemart 3.4.x
Olympiantheme Hera (customized)

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4067
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: Clean up orphaned products?
« Reply #2 on: October 01, 2019, 15:07:09 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