Hi Guys,

I am currently working on a webshop with a lot of variants per product. I got a page with 35 master products, and each of that master product has 192 variants. So a total of 6720 products.

As you can understand, the overview page is really slow.

To get my productslist i am using the following:

 var queryResult = merchelloHelper.ProductContentQuery()
                  .Page(pageNr) // defaults to 1
                  .ItemsPerPage(ItemsPerPage) // defaults to 10                           
                  .ConstrainByCollectionKey(key)
                  .Execute();

It's pretty straight forward (i think).

But for my overview page, I just need the master products with an array of the optionchoices names.

Just to show:

Available colors: red, green, blue - Available sizes: S M L XL

Is there a way to only get my master products, and leave all the variants at this point? The first time I load this page, it takes around 1.5 minutes...

Thanks! Puck