What Is the Shopify Unfulfilled Orders Report?
Unfulfilled Orders is a working dispatch list. It pulls every order whose fulfillment status still shows nothing has shipped, and it leaves cancelled orders out, so the list only holds orders that genuinely need to move.
What makes it practical is the full shipping block sitting on each row. Recipient name, street address, secondary line, city, state, zip, country, and phone all appear next to the product, the units to pick, and the shipping amount collected. A picker or a VA can work the list from top to bottom without opening each order in Shopify admin.
One distinction worth clearing up: unfulfilled is not the same as unpaid. An order can be fully paid and still sit unfulfilled, and it can be both unpaid and unfulfilled. This report is organized around fulfillment status, not payment status. If you need the money-in-hand view instead, that is a separate report.
Which Fields Are Included in the Unfulfilled Orders Report?
These fields turn the report into a pick-and-pack sheet: what to ship, how many, where it goes, and who to reach if a carrier needs a contact.
You can adjust the pre-made report by adding, removing, or reordering columns so it matches how your dispatch team actually works a queue.
Important Insights You Can Find in This Report
Which unfulfilled orders have been sitting the longest?
The count of unfulfilled orders matters less than their age. Sort by Date, oldest first, and the orders most likely to draw a complaint, a "where is my order" ticket, or a chargeback rise to the top. A backlog of ten fresh orders is normal on a busy day. A single order from eight days ago still marked unfulfilled is the one that damages trust. Work the top of a date-sorted list before you touch anything placed today.
Are unfulfilled orders clustering around one destination?
Group by Shipping City, State, or Country and look for a bunch of stuck orders heading to the same place. A cluster can mean a batchable dispatch run to one region, or it can point to a carrier or zone problem, such as a lane you paused or a service that stopped accepting parcels. Either way, a concentration tells you to handle those rows as a group rather than one at a time.
Are any unfulfilled orders held up by incomplete shipping details?
Scan Shipping Address 2, Shipping Zip, and Shipping Phone for blanks. Because this report carries the full address block, missing values are easy to catch here. An order stuck on a bad or empty address is not a warehouse-capacity problem, it is a data problem, and it needs a customer message rather than a pick. Separating these two causes stops you from throwing labor at orders that physically cannot ship yet.
THE ANALYST'S READ: The Signal Most Merchants Miss
Most teams treat this report as a flat to-do list and clear it in whatever order the rows appear. The signal they miss is that two very different problems live in the same list. One is genuine backlog: real orders, good addresses, simply waiting for hands. The other is orders that will never ship as-is because a shipping field is wrong or empty.
Read the Date column and the address fields together. If your oldest unfulfilled orders also have gaps in Shipping Address 2, Zip, or Phone, the age is not a dispatch-speed story, it is a stuck-data story, and adding warehouse staff will not move those rows. If your oldest orders have clean, complete addresses, then the age genuinely reflects capacity, and the fix is throughput. Splitting the list this way is worth checking before you decide whether the bottleneck is people or data.
How Can You Automate the Unfulfilled Orders Report?
Open the pre-made Unfulfilled Orders report in Report Pundit. The columns are already set, so you can save it as-is or adjust the fields first. Once saved, schedule it to run daily, weekly, or monthly and have it emailed to you, your dispatch team, or a VA on that schedule, so the queue lands ready each morning instead of being rebuilt by hand.
You can also export it to Excel, CSV, or PDF, or send it to Google Sheets or Google Drive when someone downstream needs it in their own workspace.
Frequently Asked Questions
What counts as an unfulfilled order in this report?
An order whose fulfillment status has not reached fulfilled and that has not been cancelled. It stays on the list until it ships, regardless of whether it has been paid for.
How is this different from Orders Pending Fulfilment and Orders Paid But Not Fulfilled?
All three surface orders waiting to ship. Unfulfilled Orders is the plain fulfillment-status view with the complete shipping block for dispatch. Orders Paid But Not Fulfilled narrows the same idea to orders that are already paid, so you prioritize revenue you are holding. If your store also runs Orders Pending Fulfilment, it overlaps heavily with this report, and you generally want one of the two, not both.
Does this report include cancelled orders?
No. Cancelled orders are excluded by design, so the list only shows orders that still need action.
Can I see the full delivery address to print labels?
Yes. Recipient name, street address, secondary line, city, state, zip, country, and phone are all included, so you can pick, pack, and label directly from the report.
Can I have this report sent to my team automatically?
Yes. Schedule it to run daily, weekly, or monthly and deliver by email, Google Sheets, or Google Drive, so the queue reaches whoever handles dispatch without anyone rebuilding it.