Products with children to show price from...

[OliviaH]

I am trying to make it so that on both the category view and product page, any product that has a price of 0 and child products, the price should show the lowest child price.

The problems I am having are how to see if the product has children, then how to get the prices of the child products.
I gather that they are database queries. I have tried changing db queries that were currently in use, but I haven't got the slightest idea how they work, so nothing has worked.


Joomla 3.0.12
Virtuemart 3.4.8
PHP 5.6.20

[lindapowers]

https://forum.virtuemart.net/index.php?topic=133239.0

[OliviaH]

Thanks lindapowers, that that thread didn't really solve my problem, as many of my parent products have a price already, but it isn't the lowest of it's children, just the most common.