Fix 4 of 60 · Checkout & orders

How do I find orders stuck unfulfilled for more than 48 hours?

Orders that sit unfulfilled for days turn into angry emails. Here are two free Shopify ways to find them: a saved view in your Orders list and a daily Shopify Flow email.

Published Updated By Kishore, Axioprax5 min read
A Shopify order list where two orders placed more than two days ago are flagged as stuck unfulfilled and one recent order is on track.

What counts as a stuck order, and why does 48 hours matter?

A stuck order is one that is paid and waiting, with nothing shipped. If you promise dispatch within a day or two, an order still unfulfilled after 48 hours has usually fallen through a gap: a missing item, an address problem, a payment you meant to check, or a note nobody read.

The cost shows up later. The customer emails asking where their order is, then asks again, then opens a dispute. Finding these orders on day two is cheap. Finding them on day nine is not.

How do I know I have orders stuck right now?

Open Orders and click the Unfulfilled view. Shopify says it shows "orders that still need fulfillment work" and leaves out canceled or fully refunded orders. If you scroll down and see order dates from last week, you have stuck orders. Common signs:

  • Orders with a hold or a note you meant to come back to.
  • Partially fulfilled orders where one item is still waiting.
  • Orders for a product that ran out after the order was placed.
  • Customer emails quoting an order number you do not recognise.

The trouble is that this view mixes today's orders with old ones. The steps below give you a list of the old ones only, in two places: a saved view you check, and an email that comes to you.

How do I fix it? (step by step)

Work through it with your Shopify admin open, and tick each step as you go.

0 of 7 done

  1. Open the Unfulfilled view.

    Go to Orders in your Shopify admin, click All to open the view menu and pick Unfulfilled. Shopify builds this view from two filters, Status: Open and Fulfillment status: Unfulfilled and Partially fulfilled, so archived orders are already left out.

  2. Sort oldest first.

    Change the sort order so the oldest orders sit at the top. Those are the ones most likely to be stuck.

  3. Save it as your stuck orders view.

    Click Save and give the view a name such as "Stuck 48h". Open it every morning: anything at the top placed more than two days ago needs a look.

  4. Install Shopify Flow and pick the summary template.

    Install the free Shopify Flow app, then go to Apps > Flow, click Create workflow, click Browse templates and choose "Send email summary with all unfulfilled orders older than 2 days". Click Install. Staff accounts, unlike the store owner, also need Shopify's Flow automations permission, set in Settings > Users > Roles.

  5. Check the schedule and the query.

    Set the Scheduled time trigger to run once a day at a time you are at your desk. In the Get order data step, check the query covers open, unfulfilled orders created more than 2 days before the run, for example: fulfillment_status:unfulfilled AND status:open AND created_at:<'{{ scheduledAt | date_minus: "2 days" }}'.

  6. Point the email at the right person.

    In the Send internal email step, replace the placeholder address with the person who handles fulfilment. Add more than one address with a comma.

  7. Turn the workflow on.

    Click Turn on workflow. Check the count in the first email against your saved view, so you know both agree.

Shopify Flow runs on a daily schedule, Get order data pulls open unfulfilled orders older than two days, and a Send internal email action delivers the list to the fulfilment owner.
Once a day, Flow finds the old unfulfilled orders and emails you how many there are and their value.

What should I do with each stuck order?

Open it and find the reason before you do anything else. If an item is out of stock, tell the customer the new date or offer a refund for that line. If the address looks wrong, contact the customer before shipping. If it is simply forgotten, ship it today and add a short apology. We suggest tagging each one with the reason, so after a month you can see which gap keeps causing delays.

When is this not the right fix?

If you sell made-to-order or pre-order products with a long lead time, a 48-hour rule will flag every order and you will start ignoring the email. Change "2 days" in the query to your real promise, or leave those products out with a tag. And the email gives you the count and value, not the reasons. Open the saved view to see each order, and someone still has to look at each one.

What does it cost?

Nothing extra. Saved views are part of the Orders list in your admin, and Shopify Flow is a free app on the Basic, Grow, Advanced and Plus plans. The real cost is ten minutes a morning working through the list, which gets shorter once the common causes are fixed.

Do it yourself, or have it done?

Yourself, free

Follow the steps above. Everything on this page is free, with no email needed.

Stuck orders checklist (PDF, 1 page)The saved view, the Flow query and what to do with each stuck order. Free, no email needed.

Done for you

We set it up in your store through a collaborator account, and tell you what it takes before you pay anything.

Frequently asked questions

Why is the Flow count lower than my saved view?

The Unfulfilled view also shows partially fulfilled orders. The Flow query above only asks for fully unfulfilled ones. Shopify lists partial as its own fulfillment_status value, so add it to the query if you want both numbers to match.

Does the email list each stuck order?

Shopify describes this template's email as a summary: the number of orders and their value. Use it as the daily warning, and open your saved view to see each order. The step that fetches the orders reads at most 100 per run, so if the email says 100, assume there are more.

Can the workflow run more often than once a day?

Yes. Shopify says the Scheduled time trigger can run as often as every 10 minutes. For most stores one morning email is enough and easier to act on.

Does this work on the Basic plan?

Yes. Shopify Flow is free on the Basic, Grow, Advanced and Plus plans, and you can save order views in the Orders list.

Get the week's fixes by email

One email a week with the new fixes and their checklists. No sales emails. Unsubscribe any time.

Got a store problem we haven't fixed yet? Send it to us and it may become a future fix.

All fixes