What is the Last 24 Hours Orders Report?
The Last 24 Hours Orders Report shows orders placed in your Shopify store during the past 24 hours, including products sold, quantities, discounts, returns, taxes, and total sales.
Each product is displayed as a separate line item, so you can see exactly what customers purchased and how much each sale contributed.
The report uses a rolling 24-hour window. If you run it at 9 AM today, it covers orders from 9 AM yesterday to 9 AM today. This makes it useful for reviewing recent sales, tracking product demand, and sharing order updates without manually adjusting dates every day.
Report Overview
- Report period
- Rolling last 24 hours, based on the configured reporting time.
- Data included
- Orders, products, variants, SKUs, quantities, sales, discounts, returns, taxes, and customer locations.
- Best for
- Daily order reviews, sales monitoring, fulfillment planning, and bookkeeping preparation.
- Export options
- Excel, CSV, and other supported formats.
- Automation
- Schedule delivery daily, hourly, or at selected intervals to email, Google Sheets, Google Drive, FTP, or SFTP.
What Can You Learn from Your Last 24 Hours of Orders?
1. Identify Which Products and Variants Are Selling
Use Product Title, Variant SKU, and Net Quantity to see which products customers are buying most frequently.
Example: Medium-sized T-shirts sold 25 units, while large-sized ones sold 7.
What you can do: Identify fast-selling variants, check stock availability, and plan replenishment based on recent demand.
2. Understand How Discounts and Returns Affect Sales
Compare Gross Sales and Net Sales to understand how discounts and returns reduce your sales value.
Example: $3,000 in gross sales with $300 in discounts and $150 in returns leaves $2,550 in net sales.
What you can do: Identify products with larger sales reductions and investigate whether promotions or returns are responsible.
3. Review Recent Orders Before Fulfillment
Check products, variants, quantities, and customer locations to understand what customers ordered.
Example: Several customers purchase the same skincare product overnight.
What you can do: Check stock availability, prepare for daily operations, and share recent order details with your fulfillment team. Confirm fulfillment status separately before shipping.
4. See Where Your Customers Are Ordering From
Use Customer Country and Customer City to identify locations associated with recent purchases.
Example: Multiple orders come from Manchester during a promotion.
What you can do: Compare regional order activity over time and use the findings to support shipping and marketing decisions.
What Should You Check First in This Report?
You don't need to review every column to understand your recent orders. Start with these four:
- Net Quantity: Check how many units were sold after returns.
- Net Sales: See the product sales amount remaining after discounts and returns.
- Gross Sales vs. Net Sales: Identify how much sales value was reduced by adjustments.
- Discount vs. Returns: Understand whether promotions or returned products caused those reductions.
Quick example: A product with $100 in gross sales and a $20 discount generates $80 in net sales, assuming no returns.
Reviewing these figures together gives you a clearer picture of recent sales activity than looking at gross sales alone.
When Should You Use This Report?
Different teams can use the same report for different daily tasks.
| When to Use It | How It Helps |
|---|---|
| Checking orders from the last 24 hours | Review recent orders and monitor daily sales activity |
| Identifying recently sold variants for stock checks | Identify products and variants that need stock checks |
| Reviewing recent purchases before fulfillment | Review recently purchased products and quantities |
| Checking recent order-level sales and tax figures | Access order-level sales, discounts, returns, and tax information |
| Monitoring recent sales during a promotion | Check recent sales activity during promotions or product launches |
During a promotion or product launch, you can schedule the report more frequently to monitor recent orders and see which variants are selling.
How to Create This Report in Data Export
Data Export provides a premade Last 24 Hours Orders Report with relevant order, product, sales, and customer fields already selected.
You don't need to build the report from scratch.
Follow these steps:
- Open Data Export and find the Last 24 Hours Orders premade report.
- Review the selected fields and confirm the rolling 24-hour period.
- Add or remove columns and apply filters if needed.
- Click Save to keep your report configuration.
- Select Schedule if you want the report delivered automatically.
You can also create a custom report using the same fields if you need a different layout.
Make the Most of This Report
A few quick checks to keep your order exports accurate, organized, and ready to share.
01 · DATE RANGE / Check the reporting window / A report generated at 9 AM covers orders from 9 AM yesterday, not the previous calendar day.
03 · SCHEDULING / Avoid overlapping exports / Hourly exports of a rolling 24-hour report will overlap. Adjust the date range if you only need new orders.
02 · ORDER COUNT / Count orders, not rows / One order with three products can create three rows. Count unique Order Names for the actual order total.
04 · SHARING / Keep only the fields you need / Remove unnecessary customer details before sharing. Give each team only the columns relevant to their work.
Frequently Asked Questions
Is a daily Shopify order report the same as a last 24 hours report?
No. A daily report typically covers a fixed calendar day, while a rolling 24-hour report covers the 24 hours immediately before it runs.
For example, a report generated at 10 AM covers orders from 10 AM yesterday to 10 AM today.
Can I automatically receive Shopify orders from the last 24 hours?
Yes. Data Export lets you schedule the report for automatic delivery to email, Google Sheets, Google Drive, or other supported destinations.
What is the difference between order quantity and net quantity?
Order quantity represents the number of units originally purchased. Net Quantity subtracts returned units.
For example, if three units were purchased and one was returned, the net quantity is two.
Can I share this report with someone who doesn't have Shopify access?
Yes. You can schedule the report to be delivered to an approved recipient without requiring them to log in to your Shopify admin.
Does this report include Shopify POS and draft orders?
POS orders can be included when they are available in Shopify's order data and match the report filters.
Draft orders that haven't been converted into regular orders are not part of a standard placed-orders report. Check the available configuration if you need additional order types.
