How to prevent unpaid items from being fulfilled in Flow app?

[Z_Jonah]

Hello,

In the Flow app I have the following Workflow that pulls orders' data from Shopify to a Google Sheet.

I use a post-purchase app and sometimes an item is added to the order but is not paid.

The flow still sends the lineitem's data to the sheet and this causes to sometimes fulfill items that haven't been paid for.

Any solution? Like a quantity parameter that only shows paid and therefore fulfillable items?

{{order.createdAt}},{{order.name}},{{lineItemsForeachitem.sku}}, {{lineItemsForeachitem.quantity}},{{lineItemsForeachitem.unfulfilledQuantity}},{{order.shippingAddress.name | replace: ",", " " }},{{order.shippingAddress.address1 | replace: ",", " " }},{{order.shippingAddress.address2 | replace: ",", " " }},{{order.shippingAddress.city | replace: ",", " " }},{{order.shippingAddress.province | replace: ",", " " }},{{order.shippingAddress.zip | replace: ",", " " }},{{order.shippingAddress.countryCodeV2}},{{order.shippingAddress.phone}},{{order.customer.email}}

[lilyliward]

Hello, 

I think you could add a condition to check if the lineitem.nonFulfillableQuantity == lineitem.quantity. 

Lily

[paul_n]

I'm not aware of any field that tells you if a line item has been paid for or not. You could check to see if order / lineItems / nonFulfillableQuantity returns true in that scenario.