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).
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