Use Shopify Flow to Tag orders with Backordered Items

[Kronos9326]

Hi there. We have several products that we allow to go to backorder/preorder status within shopify and allow customers to place orders for those items.

Our fulfillment backend however makes finding these orders tedious when it comes to fulfillment. (We are using Cin7 Core). We would like to know if it's possible to tag an order that contains an item with a managed stock level of less than 0 with a) the SKU of the backordered item, or b) BACKORDERED as a tag.

This will allows us to find these orders quickly in the fulfillment system for processing and shipping. I'd prefer to stay with flow if possible and not use a 3rd party app.

[Steve_L]

Would something like this work? 

This option checks if the product associated with any line item on the order has a totalInventory less than or equal to 0, and if so, it adds a `BACKORDERED` tag to the order.

Another approach is to loop over the line items and check a similar condition. This way we can include the sku on the tag, like `BACKORDERED: {sku}`.

[Kronos9326]

Since the flow is run AFTER the order is placed, an order can accidentally be tagged with 'backorder' if the order got the last item in stock, since the logic of 'total inventory' being 0 or less is true.

Would using 'current QTY'  ( lineItemsForeachitem.currentQuantity -- The line item's quantity, minus the removed quantity.) be a better fit in this scenario?

Otherwise, this does work, with the exception of the aforementioned 'last item' order.

[paul_n]

Quantity is the quantity ordered and not the in-stock quantity. I would just change the operator to less than 0, although this assumes that you allow the number to go negative.