How can I retrieve the 'payment_schedule_id' for order reminders?

Topic summary

Goal: automate reminders for orders using a third‑party payment method that remain in “pending payment,” and cancel after 48 hours if unpaid. The author needs access to the payment_schedule_id to send a payment reminder via Flow.

Suggestion shared: use the “Payment schedule is due” trigger in Shopify Flow; templates are available (a screenshot was provided). This trigger fires when a scheduled payment becomes due.

Concern: this trigger activates only at due time, not before. The author states pending payment has a fixed 30‑day payment window that can’t be changed, while they need reminders and auto‑cancellation at 48 hours—making the suggested trigger insufficient for their use case.

Status: unresolved. Open questions include how to retrieve payment_schedule_id within Flow and how to trigger reminders/cancellation before the due date (e.g., time‑based or alternative event/field access).

Summarized with AI on January 15. AI used: gpt-5.

Hello,

Here’s the situation, I want to create a flow for new orders that use a third party payment which uses the steps pending payment.

User orders. If he does not pay, then send a reminder to pay the order. So I have a flow starting at every order creation filtering out the payment method however I cannot make my hands on the “payment_schedule_id” and therefore I cannot send the payment reminder.

Any idea how I could do this?

Regards,

I think you should use the Payment schedule is due trigger. There are a couple of workflow templates on how to use it. For example.

Hello @lilyliward ,

Thanks for your answer. I have seen this flow, however it can only be activated once the payment is due not before.

Unless I am wrong pending payment has a 30 days limit to be paid and can’t be changed. We don’t want to give this freedom. We plan to sent to reminder and cancel the order after 48 hours. Therefore, from my understanding, this flow is not useful to us.

Please correct me if I am wrong somehow,

Cheers