What Is the Pending Draft Orders Report?
The Pending Draft Orders report brings your unfinished Shopify draft orders into one follow-up list. Review the draft name, creation date, customer details, status and amounts to decide which quotes or invoice-sent drafts need attention.
Each row represents a draft order within your selected creation-date range, filtered to Open or Invoice Sent. Use it for wholesale quotes, custom requests and phone orders that have not yet become regular orders. Draft totals show potential order value, rather than confirmed revenue or cash collected.
Report Overview
- Report period
- Select a creation-date range; include older dates when reviewing your full pending list.
- Data included
- Seven fields covering draft details, customer contact information, status and amounts.
- Best for
- Reviewing open quotes and following up on invoice-sent drafts.
- Export formats
- Excel, CSV or PDF.
- Automation
- Schedule daily, weekly or monthly email delivery for a recurring follow-up list.
What Can You Learn from Pending Draft Orders?
1. Which quotes have been waiting longest
Created Date helps you identify drafts that have remained unfinished. It measures time since creation, rather than time since an invoice or reminder was sent.
Example: For example, a furniture quote created three weeks ago still shows Open.
What you can do: Review the quote history and ask whether the customer needs an updated estimate.
2. Which drafts have reached the invoice stage
Status separates open drafts from those with an invoice sent. This helps you choose an appropriate follow-up without assuming every open draft has already been shared.
Example: For example, a wholesale draft shows Invoice Sent while a newer quote remains Open.
What you can do: Check the invoice-sent draft before sending a payment reminder.
3. Where larger potential orders are waiting
Total Price helps you rank drafts by potential order value. Review customer details alongside the amount so you can prioritize relevant conversations.
Example: For example, a bulk gift order has a higher total than several small draft orders.
What you can do: Contact the buyer to confirm quantities and the next step before allocating resources.
What Should You Check First in This Report?
- Status: Keep Open and Invoice Sent in view, and exclude completed drafts.
- Created Date: Sort oldest first, then check whether the selected date range hides earlier drafts.
- Total Price: Review larger drafts first and confirm the currency before summing amounts.
- Customer details: Check for missing emails and duplicate drafts before assigning follow-up.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing wholesale quotes | Find older or higher-value drafts that need a buyer response. |
| Following up after sending invoices | Filter to Invoice Sent and identify the customer to contact. |
| Checking custom order requests | Review unfinished drafts before confirming the next production step. |
| Clearing phone order backlogs | Locate open drafts that your team needs to review or finish. |
| Preparing a sales follow-up list | Export customer details, draft identifiers and amounts for a regular team review. |
How to Create This Report in Data Export
Start with the Pending Draft Orders premade report and review its settings before saving.
- Open Data Export and go to Prebuilt Reports. Find Pending Draft Orders under Draft Orders.
- Open the report and review the seven columns against the fields available in your store.
- Set the draft status filter to Open and Invoice Sent. Choose a Created Date range broad enough to include the drafts you want to follow up on.
- Generate and review the results, then save the report. Check older drafts, customer details and the displayed amounts.
- Set daily, weekly or monthly email delivery. Choose the recipients and export format needed for your follow-up process.
If the premade report or a field is unavailable, ask Data Export support to help configure the view.
Make the Most of This Report
Use these checks to keep your exported follow-up list useful.
01 / DATE RANGE
Include older drafts A recent creation-date filter can hide outstanding quotes from previous months. Expand the range for a full review.
02 / STATUS
Separate your next steps Open drafts may need quote review; invoice-sent drafts may need a reminder after checking the customer history.
03 / VISUAL REVIEW
Chart comparable totals In Excel or Google Sheets, group draft totals by status or creation week. Confirm a consistent currency before charting.
04 / SHARING
Share only what is needed Customer emails are contact details. Keep scheduled recipient lists limited to the people handling these drafts.
Frequently Asked Questions
What counts as a pending draft order?
For this report, pending means a draft with Open or Invoice Sent status. Completed drafts are excluded.
Does this show every unpaid Shopify invoice?
No. A draft can be completed and converted into a regular order with payment still pending. Use the appropriate order or payment report to review those unpaid orders.
Does Created Date show when the invoice was sent?
No. It shows when the draft was created. This field alone cannot tell you how long an invoice has been outstanding.
Can I export and schedule this report?
You can export Excel, CSV and PDF files, with daily, weekly or monthly email delivery. Review the available options when saving your report.
Can this report measure quote conversion?
Not by itself. Compare the same group of drafts across pending and completed records, matching draft identifiers and the period. Completion alone does not establish that payment was collected.