What Is the Orders Paid but Not Fulfilled Report
The Orders Paid but Not Fulfilled report in Data Export helps you find paid Shopify orders that still need fulfillment. Cancelled orders are excluded, so you can focus on valid paid orders that need a shipping follow-up.
For your selected period, it brings together order references, product names, fulfillment status, shipping details, net quantity, shipping amounts and total sales. Use it to prepare a dispatch review, check delivery information or send your team a scheduled list of pending orders.
Product details can produce multiple rows for the same order. Use Order Name to keep related rows together and count distinct orders when measuring the size of your queue.
Report Overview
- Report period
- Choose the date range for your review; include earlier dates when checking older pending orders.
- Data included
- 16 fields covering orders, products, fulfillment, shipping details, quantities and sales amounts.
- Best for
- Daily dispatch checks and follow-up on paid orders awaiting fulfillment; cancelled orders are excluded.
- Export formats
- Excel, CSV, TXT and PDF.
- Automation
- Schedule delivery by email daily, weekly or monthly.
What Can You Learn from Paid Orders Awaiting Fulfillment
1. Which orders need a dispatch follow-up
Order Name and Fulfillment Status give your team a clear starting list. Review the products within each order before deciding the next step.
Example: A hypothetical paid order still shows an unfulfilled status during the morning review.
What you can do: Open the order and confirm what is preventing dispatch.
2. Which delivery details need attention
The shipping address fields let you review the information your dispatch team will use. A missing value is a reason to check the original order, rather than proof that delivery is impossible.
Example: A hypothetical order has an empty Shipping Address 2 field while its main address includes a unit number.
What you can do: Verify the full address before asking the customer for clarification.
3. Where pending shipments are going
Use Shipping Country, Shipping State and Shipping City to group pending shipments by destination for your dispatch review.
Example: Several hypothetical paid orders share the same destination state.
What you can do: Filter that state and give the relevant order list to the dispatch team.
What Should You Check First in This Report
Review these details before turning the export into a working dispatch list.
- Order coverage: Check the selected date range and count unique Order Name values, rather than treating every product row as a separate order.
- Fulfillment status: Review the status shown and confirm the current order details before assigning a shipping task.
- Shipping details: Check the address and available contact information for orders your team plans to dispatch.
- Quantities and amounts: Review Net Quantity, Shipping and Total Sales at the report’s row level. Confirm how amounts repeat or are allocated before adding them up.
When Should You Use This Report
| When to Use It | How It Helps |
|---|---|
| Reviewing paid orders awaiting fulfillment | Find paid orders that still need fulfillment follow-up. |
| Preparing the daily dispatch queue | Review order references, products, quantities and shipping details together. |
| Checking a paid order before responding | Locate the order reference and review its reported fulfillment status before checking the order itself. |
| Organizing pending shipments by destination | Filter by country, state or city to organize a regional shipping review. |
How to Create This Report in Data Export
Start with the premade report so you can use its existing columns and order-selection rules.
- Open Data Export in your Shopify admin and find the premade Orders Paid But Not Fulfilled report.
- Open the report and review its fields and filters. Preserve the paid-order scope and exclusion of cancelled orders.
- Choose your date range. Adjust available filters and sort by Date or Fulfillment Status to organize the review.
- Save the report and generate an export in Excel, CSV, TXT or PDF. Check a few order references before sharing it.
- Optionally schedule daily, weekly or monthly email delivery to the people responsible for follow-up.
Make the Most of This Report
Use these four checks to keep the exported queue useful.
01 / PERIOD
Include older pending orders A short date range can leave earlier records outside your review. Widen it when checking the full backlog.
02 / COUNTING
Count orders once Use distinct Order Name values for an order count. Keep product rows available for item-level review.
03 / TIMING
Recheck before dispatch A downloaded file reflects its generation time. Confirm the current order status before acting on an older export.
04 / SHARING
Limit customer details Remove addresses or phone numbers when recipients only need an order summary. Share delivery details with the team that uses them.
Frequently Asked Questions
Does this report include cancelled orders
No. The premade report excludes cancelled orders and focuses on paid orders awaiting fulfillment.
How is this different from a general unfulfilled orders report
This report specifically limits the queue to paid orders and excludes cancelled orders. Use it when your follow-up is focused on payment-complete orders awaiting dispatch.
Why can the same order appear more than once
An order can contain several products, so its reference may appear on multiple rows. Count distinct Order Name values to avoid overstating the number of pending orders.
Can I use Shipping to measure carrier costs
The supplied field is a shipping amount, not a confirmed shipping label cost. Do not use it as carrier spend or shipping profit without additional cost data.
Can I receive this report automatically every day
Yes. Save the report and set a daily email schedule. Review the date range and recipient list so each delivery covers the orders and details your team needs.
