Do not list child products - only parent?

Green Jelly
Inactive member
Topic Author
New Member

10 years 6 months ago #40787 by Green Jelly

Do not list child products - only parent? was created by Green Jelly

Hi,

I'd like to disable the scroller from showing child products - my client has multiple sizes of one item, for example, and we don't want all of the sizes showing as individual items in the scroller - just the parent item.

Have set the module to display up to six items, not featured only, just newest added.

Joomla Version 2.5.17 VM version 2.6.6

testsite.pinkcola.co.uk

Many thanks!

Please Log in to join the conversation.

ivan.milic
Support Staff
Moderator

10 years 6 months ago #40792 by ivan.milic

Replied by ivan.milic on topic Do not list child products - only parent?

Open modules\mod_vmscroller\helper.php

locate this code:

Code:

                               $q = "SELECT DISTINCT P.virtuemart_product_id FROM 
                                       #__virtuemart_products as P 
                                       LEFT JOIN 
                                       #__virtuemart_product_categories as PC on PC.virtuemart_product_id = P.virtuemart_product_id 	  
                                       WHERE 
                                       P.published = 1  
                                       AND PC.virtuemart_category_id = ".$this->category_id;  

replace it with this code:

Code:

                               $q = "SELECT DISTINCT P.virtuemart_product_id FROM 
                                       #__virtuemart_products as P 
                                       LEFT JOIN 
                                       #__virtuemart_product_categories as PC on PC.virtuemart_product_id = P.virtuemart_product_id 	  
                                       WHERE 
                                       P.published = 1 AND coalesce(P.product_parent_id,0) = 0  
                                       AND PC.virtuemart_category_id = ".$this->category_id;  

The following user(s) said Thank You: Green Jelly

Please Log in to join the conversation.

Green Jelly
Inactive member
Topic Author
New Member

10 years 6 months ago #41198 by Green Jelly

Replied by Green Jelly on topic Do not list child products - only parent?

Thanks for this, seems to have done the trick!

Please Log in to join the conversation.

Time to create page: 0.168 seconds