I could do this, but this is what I was trying to avoid in hopes of a more direct/simple solution. That’s why I reached out to the Shopify community, I was hoping that this would be a common enough situation that someone would have a simpler solution for, instead of going through every FulfillmentOrder and counting them myself.
For example, when I want to find out how many orders were shipped domestic/international over a time period, I run this ShopifyQL query:
FROM orders
SHOW sum(orders) AS “orders”
GROUP BY shipping_country
SINCE 2023-12-01T00:00:00 UNTIL today
limit 1000
Instead of running that query, I could use GraphQL or REST to look at the shipping country of every order within a time period and add them all up myself, but that would be silly because there’s a much simpler/easier way to do that.
I was hoping there would be a similarly simple way to get the number of fulfilled orders within a time period without having to count and add them all myself, but so far it’s looking like this isn’t the case.