Is my order data uploaded anywhere?

No. The CSV is read by JavaScript in your browser and never sent to our servers. Close the tab and the data is gone. That makes it safe to use with customer names, emails and addresses in the export.

How do I export orders from Shopify?

In Shopify admin, open Orders and click Export. Choose a date range or all orders, select CSV for Excel, Numbers, or other spreadsheet programs, and click Export orders. Small exports download straight away; larger ones are emailed to the store owner as a download link.

What is the difference between gross sales, net sales and total sales?

Gross sales is product price times quantity, before discounts and returns. Net sales is gross sales minus discounts and returns. Total sales is net sales plus shipping charges, taxes and duties. Shopify Analytics uses the same three figures, and gift card sales are left out until the gift card is redeemed.

Why doesn't the result match Shopify Analytics exactly?

Analytics records a return on the day the refund happens, while an orders export ties the refund to the original order. Refunded shipping and tax are shown under returns here but under shipping and taxes in Analytics. Time zones, cancelled orders, test orders and edited orders can also move a few orders in or out of a date range. Over a full month or quarter the two usually land close together.

Can I check a competitor's Shopify revenue?

Not with real numbers. Shopify does not publish store revenue, so any tool that shows another store's sales is estimating from traffic, ads or review counts, and the result cannot be verified. This checker only works with an orders export, which only the store owner or staff can download.

How do I verify revenue before buying a Shopify store?

Ask the seller to export all orders for the last 12 to 24 months and share the CSV, or to export it while you watch on a screen share. Run it here and compare total sales by month against the figures in the listing, and against the payouts in Shopify Payments or the payment provider. Large gaps, heavy refunds or test orders are worth questioning.

Does the orders export include refunds and cancelled orders?

Yes. Each order has a Refunded Amount and a Cancelled at column. This tool subtracts refunds as returns, and leaves cancelled, unpaid and test orders out by default. You can switch each of those back on to see how they change the totals.

Can I upload more than one CSV?

Yes. Drop several exports at once, for example one per year. Orders that appear in more than one file are counted once, matched by order number.

← Back to tools

Shopify Revenue Checker

Q: What is a Shopify revenue checker?

It is a calculator that totals a store's revenue from its own order data. This one reads the orders CSV you export from Shopify admin and returns gross sales, discounts, returns, net sales, shipping, taxes and total sales, using the same labels as Shopify Analytics. Because it works from real orders, the figure can be checked line by line, unlike a revenue estimate.

Check your Shopify revenue from real orders, not an estimate. Drop in an orders CSV export and get gross sales, discounts, returns, net sales, shipping, taxes and total sales, laid out the way Shopify Analytics reports them.

Share

Drop your Shopify orders CSV here

One file or several. Read in your browser, never uploaded.

Shopify admin → Orders → Export → “CSV for Excel, Numbers, or other spreadsheet programs”. Step-by-step guide

From To

Include unpaid orders Include cancelled orders Exclude test orders

Same orders, bigger baskets. Add-ons and upsells raise revenue without more traffic. Get SellUp

Built for real Shopify catalogs — apparel, beauty, home, and more

How to export your Shopify orders CSV

The orders export is the source of truth for Shopify revenue. It lists every order with its line items, discounts, shipping, taxes and refunds, which is exactly what the checker needs.

1
Open Orders in Shopify admin

Log in to Shopify admin and go to Orders. Filter the list first if you only want one sales channel or location.
2
Export the orders as CSV

Click Export, choose the date range or all orders, select CSV for Excel, Numbers, or other spreadsheet programs, then click Export orders.
3
Drop the CSV into the revenue checker

Drag the file onto the checker or browse for it. It is read in your browser and never uploaded.
4
Read and reconcile the totals

Set the date range, review gross sales, discounts, returns, net sales, shipping, taxes and total sales, and compare them with Analytics → Reports → Total sales.

Large exports are emailed to the store owner instead of downloading. Upload the file as Shopify sends it: re-saving in Excel can change dates and number formats.

How Shopify calculates revenue

"Revenue" means different things in different reports. Shopify Analytics breaks it into gross sales, net sales and total sales. The checker uses the same definitions.

Gross sales

Line item price × quantity

What the products sold for before any discount or refund. Gift card sales are left out, because Shopify counts a gift card when it is spent.

Discounts

Gross sales − order subtotal

Discount codes, automatic discounts and line item reductions. The checker also lists the discount codes that cost the most.

Returns

Σ Refunded Amount

Money refunded on the orders in range. Shopify Analytics books a return on the day of the refund, so recent refunds on old orders land in a different month there.

Net sales

Gross sales − discounts − returns

Product revenue the store actually kept. This is the figure to use for margin, ad efficiency and growth.

Total sales

Net sales + shipping + taxes + duties

Everything customers paid, after refunds. It is the headline number on the Shopify Analytics dashboard.

Average order value

(Gross sales − discounts) ÷ orders

What a typical order is worth, using Shopify's AOV definition. Raise it and total sales grow without extra traffic.

Why your total may differ from Shopify Analytics

An orders export and the Analytics dashboard count the same money from different angles. These are the usual causes of a gap, and how to close it.

Cause	What happens	How to reconcile
Refund timing	Analytics records a return on the refund date. The export attaches it to the order date.	Compare a full quarter, or export a wider range than the period you are checking.
Refunded shipping and tax	The export's Refunded Amount includes refunded shipping and tax. Analytics shows them under shipping and taxes.	Total sales still match; net sales here can be slightly lower.
Cancelled orders	Analytics keeps the original sale and records the cancellation as a return.	Tick “Include cancelled orders” to mirror that.
Unpaid orders	Pending payments (bank transfer, cash on delivery) count as sales in Analytics.	Tick “Include unpaid orders”.
Test orders	Orders placed with the Bogus Gateway appear in the export but not in sales reports.	Leave “Exclude test orders” on.
Time zone	Orders near midnight can fall on a different day depending on the store time zone.	The checker uses the store-local date written in the export.
Tax-inclusive prices	UK, EU and Australian stores often include tax in product prices.	Detected per order: tax is taken out of gross sales so it is not counted twice.
Multiple currencies	Exports list each order in its order currency.	Pick a currency in the filter; currencies are never mixed.

Checking another store's revenue?

Shopify never publishes a store's sales. Tools that put a revenue figure on a competitor are estimating from traffic, ad activity or review counts, and there is no way to check how close they are.

What you can verify from outside is how a store is built. See which apps it runs and where it is losing conversions:

Shopify App Detector Store Audit

Buying a Shopify store? Verify the revenue

Ask for an orders export covering the last 12–24 months, ideally exported live on a screen share.
Run it here and compare total sales by month with the figures in the listing.
Match those months against payouts from Shopify Payments or the payment provider.
Look at returns, unpaid orders and test orders. Heavy refunds or a spike of unpaid orders deserve a question.
Check top products and discount codes: is revenue concentrated in one item or bought with deep discounts?

Frequently asked questions

Related tools

Grow revenue from the orders you already get

SellUp adds AI-powered add-ons, cross-sells, and cart offers in about 60 seconds. Stores typically see a 10–30% AOV lift.

Get SellUp on the Shopify App Store