Thanks for getting back to me @Liam-Shopify If there is any question about the priority of this bug, I would advocate for high priority as this bug can have a very negative impact on merchants, to the point where they are so upset that they not only uninstall apps but may leave 1 star reviews
@Alan_G I appreciate the idea but that does not work because the query now has nested edges which results in an extremely high query cost. On top of that we should not assume that a product can only have 100 variants, soon that will not be true.
Also, that query does not give the same results in many cases and using it will lead to other bugs. Here is a concrete example:
- Merchant has products that have multiple variants. Let’s say a product has 3 variants priced at $5, $12, and $20 for different sizes.
- Merchant creates an automated collection which includes all product variants under $10
- Merchant uses an app to perform some action on all items in that collection
- Using the suggested queries all 3 variants are included in the results, which is certainly not correct
I appreciate the help on this, but want to make it clear that there is no workaround here for app developers.