Completed Draft Order Report for Shopify

See which Shopify draft orders converted into paid sales, with gross sales, discounts, returns, net sales, duties, tax, and total sales for each one

Table of contents

What Is the Completed Draft Order Report in Shopify?

The Completed Draft Order report lists the draft orders in your Shopify store that were paid and turned into placed orders, along with the money each one brought in. A draft order is one you or a staff member build by hand in the admin, usually for a phone sale, a wholesale account, or an invoiced deal, and it stays in the Drafts section until payment is collected.

The key word is completed. Open drafts and invoiced drafts that nobody has paid are not sales yet, so they are left out. Only drafts that actually closed show up here. If you want the wider background on how drafts work, the Shopify draft orders guide covers it in depth.

Merchants use this report because assisted and B2B revenue rarely starts at the storefront, so it is easy to lose track of. Pulling those converted drafts into one financial view lets you read them beside your regular sales and give manual selling the same scrutiny as your online store.

Which Fields Are Included in the Completed Draft Order Report?

The fields trace each converted draft from its quoted value down to the final total, so you can see where discounts, returns, and added charges changed the number.

Field What it shows
Date The day the draft was completed and became a placed order, so converted drafts line up on the same calendar as the rest of your sales.
Order Name The order number assigned once the draft converted, such as #1001, letting you open the exact order in your Shopify admin.
Sales Channel The source Shopify records for the order. Converted drafts carry the Draft Orders channel, which is how you tell them apart from Online Store, POS, or Buy Button sales.
Gross Sales Product revenue before any adjustment, calculated as product price times quantity. On a draft this is the quoted line value before the manual discount is applied.
Discount The amount taken off the order. Draft discounts are typed in by hand rather than pulled from a storefront promotion, so they can run deeper and vary more.
Returns The value of items refunded from these orders. On a large wholesale order, a single return can move this figure noticeably.
Net Sales Gross sales minus discounts minus returns. The product revenue left after the negotiated price and any returns.
Shipping Shipping charged on the order, after shipping discounts and any refunded shipping are accounted for.
Total Duties Import duties collected on the order, which apply when you invoice accounts across a border.
Tax The total tax collected on these orders.
Total Sales The full amount each order contributed: net sales plus shipping, duties, and tax.

You can customize the pre-made report by adding, removing, or reordering columns so it matches how you review draft-order revenue.

Important Insights You Can Find in This Report

How much of your revenue actually runs through manual and wholesale orders?

Compare Total Sales on completed drafts against your storefront sales for the same window. A small share means assisted selling is a side workflow. A share that keeps growing is a signal to give it a real process, dedicated pricing, or a proper B2B channel, rather than leaving it as a manual habit that lives in a few people's heads.

Is one returned order distorting your net sales for the period?

On high-value drafts, a single figure in the Returns column can drag Net Sales down for the whole report. Sort by Returns before you read a dip as a trend, and check whether one account or one deal is behind repeated reversals. A single wholesale return is a very different problem from a soft sales week.

How much of each draft's total is product revenue versus shipping, duties, and tax?

Read Net Sales against Total Sales on these rows. When you invoice international accounts, shipping and Total Duties can make the final total sit well above the product revenue you actually keep. Watching that gap helps you quote cross-border deals accurately instead of being surprised by the added charges after the sale closes.

THE ANALYST'S READ: The Signal Most Merchants Miss

Storefront discounts are capped by the promotion rules you set in advance. Draft discounts are not. Someone types the price in directly, which is the entire point of a quote, but it also means the distance between Gross Sales and Net Sales on completed drafts tends to be wider and less predictable than on your web orders.

Read that gap across several periods rather than in a single snapshot. If the discount share on drafts keeps climbing while draft volume stays flat, it may suggest deals are increasingly being won on price rather than on the offer. Compare the average discount rate here against your storefront average, and if the wholesale gap is much wider and still widening, it is worth checking whether your list pricing or your negotiation floor needs a look, instead of treating the extra discounting as simply the cost of doing B2B.

How Can You Automate the Completed Draft Order Report?

Once the columns and date range are set, you do not need to rebuild the report. Save it, then schedule it to send on its own daily, weekly, or monthly. A report can go to more than one person, so finance and the wholesale team can both receive the same file, and you can push it to Google Sheets or Google Drive to keep a running record. Exports are available as Excel, CSV, or PDF, with PDF useful for a clean summary and Excel for deeper work.

Frequently Asked Questions

What counts as a completed draft order in this report?

A draft that was paid and converted into a placed order. Open drafts and invoiced drafts still waiting on payment do not appear, because they are not sales yet. Every row here is a draft that actually closed.

Are completed draft orders already counted in my other sales reports?

Yes. Once a draft is paid it becomes a regular order and flows into your normal Sales and Order reports. This report does not add new revenue. It isolates the orders that started as drafts so you can study that slice on its own.

Why does the Sales Channel column show Draft Orders?

Shopify labels the channel of a draft-origin order as Draft Orders. That label is how you confirm a row began as a manual draft and separate it from Online Store, POS, or Buy Button sales sitting in the same data.

Why is the gap between Gross Sales and Net Sales often wider on these orders?

Because draft discounts are entered by hand instead of being bound by storefront promotion rules. Read Discount against Gross Sales, and if a persistent wide gap shows up, it usually means the negotiated price, not a coded promotion, is doing the discounting.

Can I focus the report on one account or period?

Yes. Set any date range you need, and apply a filter so only the rows for a specific customer, period, or channel show. You can also add, remove, or reorder columns.

Can I export or schedule it?

Yes. Download it as Excel, CSV, or PDF, push it to Google Sheets or Google Drive, or schedule it to email itself to you and your team on a daily, weekly, or monthly cycle.

Report Not Found
Let's create it!
Your request is in! Check out all reports with the button below.
* Error. Please input correct email

Related Reports

Build and automate your
Shopify Reporting

Unlock the full potential of your Shopify store with Report Pundit.Gain access to over 2000 data fields, automate reports, and makedata-backed decisions to grow your business.

Field What it shows
Date The date associated with the report row.