VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: jarlu on October 04, 2022, 11:48:20 AM

Title: child products were shown after the update
Post by: jarlu on October 04, 2022, 11:48:20 AM
Hello!
After update VM to the latest version I have a issue with the default virtemart page. Before I shown only futured parents products on this page  but after update I see only futured children products. Issue is the same for all templates.
I am sending a photo before and after update in the attachment. After update you can see two identical products with selected variant. But I need to show only parent products.  everything is OK on other pages.
can you help me?
Title: Re: child products were shown after the update
Post by: jenkinhill on October 04, 2022, 15:56:00 PM
What version have you updated to?

Latest test/beta version is here:  http://dev.virtuemart.net/attachments/download/1332/com_virtuemart.4.0.7.10714_package_or_extract.zip
Title: Re: child products were shown after the update
Post by: jarlu on October 04, 2022, 16:18:26 PM
Yes, my VM version is 4.0.7 10714
Title: Re: child products were shown after the update
Post by: Milbo on October 04, 2022, 20:43:35 PM
Which variants do you use? Do your children have a category set? The common setup is without category, so it should not be shown in the list.
Title: Re: child products were shown after the update
Post by: jarlu on October 05, 2022, 08:59:52 AM
My products have category set only on parent products. Children variants are without category. This Issue is only on frontpage
Title: Re: child products were shown after the update
Post by: Milbo on October 05, 2022, 10:50:22 AM
Please check your options in the vm config of listing children.
Title: Re: child products were shown after the update
Post by: jarlu on October 05, 2022, 15:45:37 PM
QuotePlease check your options in the vm config of listing children.
Sorry but which option should I check?
Title: Re: child products were shown after the update
Post by: jenkinhill on October 05, 2022, 16:44:40 PM
I suspect Milbo means on the Virtuemart subordinated category settings tab of the home page menu item in Joomla.
Title: Re: child products were shown after the update
Post by: Milbo on October 05, 2022, 22:48:17 PM
Maybe there also, but the main setting is in the standard vm config, tab "shop front".
Title: Re: child products were shown after the update
Post by: jarlu on October 06, 2022, 10:50:38 AM
Hello, I am sending a print screen of my settings on the "shopfront" tab
Title: Re: child products were shown after the update
Post by: Milbo on October 08, 2022, 22:36:49 PM
Maybe disable "Show also products, which are not in at least one published category". I am just curious.
Title: Re: child products were shown after the update
Post by: jarlu on October 10, 2022, 19:36:23 PM
Hi Milbo, thank you, it's OK now. This issue has been resolved with this setting.
Title: Re: child products were shown after the update
Post by: Milbo on October 10, 2022, 21:50:46 PM
even more strange. Please enable the vmdebug for admins only and activate the sql debug. and then post the debug of the sql for the products. One time with and one time without the setting. I wonder what is going on there. As I said, I was just curious. I did not think it would make a difference
Title: Re: child products were shown after the update
Post by: jarlu on October 21, 2022, 14:44:38 PM
Hello, sorry for delay. Outputs are in attachments. With and without setting.

Title: Re: child products were shown after the update
Post by: Milbo on October 21, 2022, 16:29:40 PM
Thank you, great. I see you have the option enabled, that products without stock should be not seen. But parents with children having stock, right?
Title: Re: child products were shown after the update
Post by: jarlu on October 22, 2022, 13:04:05 PM
Hello, children yes, they have stock, but parents are without stock
Title: Re: child products were shown after the update
Post by: Milbo on October 22, 2022, 19:55:51 PM
So you want to see the parents without stock, whith children who have stock, but not children.
Title: Re: child products were shown after the update
Post by: Milbo on October 23, 2022, 21:44:58 PM
I restested your case, it works for me as it should. I see only the parents. I see the parent if out of stock, when I click on the parent I see only one choice, the product, which has stock, and so on. Everything is fine for me (on j3, but I wonder how there could be a difference, it is just sql).
Title: Re: child products were shown after the update
Post by: jarlu on October 25, 2022, 14:51:44 PM
QuoteSo you want to see the parents without stock, whith children who have stock, but not children.
yes

This work me fine too, but only to VM version  3.8.2 10325.

If product has children, parent product is without stock