Shopify Overdue Payment Reminder - Loop help

Technical Q&A
, , , , , , , ,

Topic summary

Goal: Set up a daily looping reminder in Shopify Flow to email customers whose fulfilled orders are now overdue, limited to customers tagged “Wholesale.”

Current issue: The Flow errors at the final step. The suspected cause is the “Get order data” filters. The user currently uses: “fulfillment_status:fulfilled AND PaymentTerms:overdue” and seeks the correct parameters to target fulfilled, overdue orders only, plus the Wholesale tag.

Context: Shopify Flow is the store’s automation tool; the user wants it to run daily and re-check overdue orders.

Responses: One reply recommends a paid alternative—Kindly - Payment Reminder—highlighting automated reminders, a dashboard of unpaid orders in recovery, recovery metrics, and responsive support. It claims the first recovered order typically covers the app cost.

Attachments: Screenshots of the Flow configuration and the third-party app dashboard are included.

Status: No verified fix for the Flow query was provided; no resolution yet. The key open question is the correct filter syntax/parameters for “Get order data” to target fulfilled, overdue, Wholesale-tagged orders.

Summarized with AI on January 4. AI used: gpt-5.
1

Hi folks! I hope everyone is well.

I’m attempting to create a looping payment reminder schedule through Shopify Flow which loops daily to remind our customers to pay us when their orders become overdue.

I’ve created what I believe to be the correct flow, however I’m getting an error at the final stage and I believe it may be because my ‘get order data’ parameters may be incorrect.

Just to explain, I only want orders that are overdue AND fulfilled (as in, they’ve received the goods but not paid for them, and their payment is now due).

The code I have inputted into the get order data field is:

“fulfillment_status:fulfilled AND PaymentTerms:overdue”

One final check is that the customer is tagged “Wholesale” (just so this doesn’t go to the wrong demographic of customer).

Can someone identify the issue and help out please? Screenshot attached for flow. Thanks in advance!

Screenshot 2023-12-08 at 11.12.17.png
Screenshot 2023-12-08 at 11.12.17.png2280×2380 494 KB

2

Anyone?

3

Hey @UK_Aspire_Vendo ,

Ah yes, now I understand your use-case. Just saw your other post. :wink: I would still suggest our app Kindly - Payment Reminder if I may. Of course it’s not free but the first recovered order normally already covers the cost and after that it’s money in your pocket without worrying about your flows! And on top of that you have plenty more options, a great dashboard which shows you all unpaid orders in recovery, your successful recoveries and more helpful data. This way you can keep a clear overview of your outstanding invoices which you can’t with flows. Aaand according to our customers we offer a super helpful and fast support if you ever need one. We are a small team which makes it easy for us to implement new features if you ever like to suggest any.

Dashboard.png
Dashboard.png1600×900 130 KB