Flow for custom cart alerts

[Tyson_Nicoll]

Hello friends,

Our WMS platform has difficulty with manually creared shopify orders that don’t use eal products but instead use custom products; they don’t push into our WMS due to lack of product links so they get lost in the void.

I’m trying to create a flow that will send an email to alert us when a draft order is either paid, or completed and generates an order. Thus far everything i’ve tried fails and I’m hoping someone much smarter than me has a fix!

The most recent attempt is:

-Order created

-Condition = Draft order status is equal to COMPLETED

-Send internal email.

However they all fail as the status always says empty, rather than any of the selectable options.

order / payment terms / draft order / status

is equal to

COMPLETED

order / payment terms / draft order / status =

<empty>

Any help would be appreciated

Kind regards,

Tyson

[tim_tairli]

I am not aware of a link from order to draft order.

There is one from draft order to order though, so
I’ve used the following approach:

With the following query for “Get Draft Orders”:

updated_at:>{{ order.createdAt | date_minus: "1 hour" }} AND
updated_at:<={{ order.createdAt }} 

[Tyson_Nicoll]

Hello Tim,

Thanks so much for your help so far! I’m hoping you might be able to help me get it finished off. I can’t quite see what you have for log output. As I couldn’t finish that step in its place I placed ‘send internal email’ with false condition to test and it does trigger emails (multiple emails) when draft order creates a new order

Thanks!

Tyson

[paul_n]

If the goal is to check if an order was created from a Draft Order, then you can check the order / app / id field and use Draft Orders.

When a Draft order is paid or completed, it does become an order, so I think that handles your need.