We have a (eventually public) app which needs information about which products/variants are most popular, preferably with total numbers sold or at least a ranking of the top N products or variants. It seems to be surprisingly hard to get this information through the API. Here are the options I see:
Orders are "protected data", which sounds like a pain, and we shouldn't really need access to any data about individual orders.
It would be a lot of data to fetch just to compile a short list of numbers. The data we need appears to already exist, so recreating it in this way feels really inefficient.
Possibly something with ShopifyQL, but that appears to be only in the "unstable" version of the API, and it is indeed unstable (I got an "Internal error" error on the example query). Also it's not clear to me whether it will be available on all stores, or only Shopify Plus. It seems to require the "read_reports" scope, and it seems like reports are normally only for Plus and/or Advanced.