Wix Stores/Products - Query Limit

Ask the community
, ,
1

So, I’m aware there is a query limit on the wix products collection as per the below

"Important:
You can query up to 100 items from the Products collection. Trying to query more than 100 items by raising the wix-data limit will result in an error." ( https://support.wix.com/en/article/corvid-wix-stores-products-collection-fields )

My query is, in the absence of any change to this, or the ability to apply collections to product galleries (see https://www.wix.com/corvid/forum/community-discussion/set-collection-of-grid-product-gallery-by-code ), has anyone found a good workaround that will allow something which resembles a query to the products database for over 100 items which can then be applied to a repeater or image gallery on a dynamic page?

I’m a little stumped and currently considering an solution that works out the total number of items in a collection, and then creates multiple datasets and sufficient repeaters to display blocks of 100 items (which seems more than a little flawed).

2

Hi Jacob,

You could create your own custom product collection instead of using the Wix Stores one. You would have a max query limit of 1000 in a custom collection.

Hope this helps!

Dara | Corvid Team