Currently, the ShopifyQL FROM sales dataset does not expose a line_item_fulfillment_status field for filtering. The available order_fulfillment_status filter only works at the order level, which creates a problem for partially fulfilled orders.
When filtering by order_fulfillment_status = 'unfulfilled' or 'partial', the report returns all line items from those orders — including items that have already been fulfilled. This makes it impossible to get an accurate view of what still needs to be shipped directly from the reports interface.
Suggested improvement: expose a line-item level fulfillment status field (e.g. line_item_fulfillment_status) in ShopifyQL so merchants can filter reports to show only unfulfilled line items, regardless of the overall order status. This would be especially useful for operations teams managing partially fulfilled orders and needing precise, actionable pick/pack reports.
Hit this exact gap last year on a 3PL handoff. ShopifyQL isn’t going to expose line-item-level fulfillment in the near term as far as I can tell.
Workaround that’s been holding: GraphQL Admin API fulfillmentOrders query - returns lineItems with remainingQuantity per line, plus the assignedLocation. Run it against orders with fulfillment_status:partial OR fulfillment_status:unfulfilled, then pivot in Sheets or a small custom report endpoint. Not as clean as native ShopifyQL but it’s the accurate dataset.
For higher volume, Shopify Flow + a webhook into your warehouse system gives near-real-time line-item status. Reports UI side I’d still vote up the feature request - line_item_fulfillment_status as a ShopifyQL dim would simplify a lot of ops dashboards.
This is a genuine gap in ShopifyQL, the FROM sales dataset simply doesn’t expose Line item fulfillment status, so there’s no clean way to filter down to only unfulfilled line items within a partially fulfilled order. You end up getting the whole order’s line items regardless, which makes the report misleading for partial fulfillment workflows.
The reason this is hard to fix in native Shopify reports is that ShopifyQL is built on their analytics dataset, which doesn’t always reflect every field available in the core Orders API. Report Pundit syncs directly from the Shopify API, so fields like Line item fulfillment status that exist in the API but aren’t exposed in ShopifyQL are available as report columns and filters.
Practically, this means you can build a report that:
Filters to only line items where fulfillment status is unfulfilled regardless of the parent order’s status
Correctly excludes already-fulfilled line items from partially fulfilled orders
Includes any other API-level fields you need alongside it (SKU, quantity, vendor, etc.)
You can also automate it schedule the report to run and deliver to your inbox or a Google Sheet so your fulfillment team always has a current view of what still needs to ship.
I completely understand the challenge you’re facing. Unfortunately, ShopifyQL currently doesn’t expose line item fulfillment status, which makes reporting on partially fulfilled orders difficult.
Out of curiosity, are you looking for a workaround that can provide accurate unfulfilled line item reporting today, or are you mainly suggesting a future improvement for Shopify?
I’ve worked with Shopify stores on reporting and operational workflows, and there may be a custom approach that could help depending on your setup.