How can I find edited and unfulfilled orders using Graph QL?

HelpDigital
Shopify Partner
8 0 1

Hi 

 

I have a one-time need to search my store for any unfulfilled orders that have been edited and line items removed/replaced.

 

As this filter / search isn't available in the UI, I wondered if I could run a Graph QL query in GraphiQL editor to find a list of orders. I can then manually check them.


I believe the fulfillable_quantity value is '0'  if a line item has been removed (prior to fulfillment). So I was hoping the query would be a simple as looking for all line items in unfulfilled orders with fulfillable_quantity=0 

 

Or is there a better field that indicates an order's line items have been edited?

 

I'm not too familiar with writing graph QL - would anyone be able to give me a starter for this query script?

I only require a list of order numbers that are potentially affected so that I can manually check them. 

 

Many thanks,

Leo

Replies 2 (2)

gr_trading
Shopify Partner
1671 141 173

Hi @HelpDigital ,

 

I worry about any query available, which can fulfill your request. But you can build a utility using shopify webhooks and add a tag to order whenever any edit happens to order.

 

Ping me if you need more clarity for flow.

For any custom development WhatsApp or connect at Email ID: gr.trading15@gmail.com for quick consultation. | Shopify Free codes
To support Buy Me a Coffee
HelpDigital
Shopify Partner
8 0 1

Thanks - but this is a once-only requirement to deal with orders already edited due to the failure of a 3rd party system / webhook.


I will add tags to edited orders in future to make this process easier.

 

Thanks,

Leo