What Is the Last 24 Hours Orders Report?
The Last 24 Hours Orders report lists every order placed in the past day at the line-item level, pairing each product and variant sold with its sales values and the customer's location. It is fixed to a rolling 24-hour window, so each time it runs it covers the most recent day without you touching the date range.
Unlike a summary that rolls sales into a single daily total, this report keeps one row per product sold. You see the actual variant, the SKU, the net quantity, and the full money breakdown from gross sales down to total sales, alongside the customer's country and city. That line-item detail is what separates it from a period summary: you are reading what sold in the last day, not just how much came in.
Merchants reach for this report when the first question of the day is "what actually sold overnight, and was any of it eaten by discounts or returns?" Because the window moves forward on its own, it works as a standing near real-time view rather than an export you rebuild each morning.
Which Fields Are Included in the Last 24 Hours Orders Report?
The fields pair each item sold with its full sales breakdown and the customer behind it, so you can read recent activity down to the individual product line.
You can customize the pre-made report at any time by adding, removing, or rearranging fields to match how you review your store.
Important Insights You Can Find in This Report
Did overnight revenue hold up after discounts and returns were taken out?
Read gross sales and net sales side by side across the last day's lines. When net sales sit far below gross sales, a discount code or a wave of returns is quietly thinning the day's takings. If one product line shows a wide gap while others hold steady, that item is where your margin is leaking, and it is worth checking whether a promo is running deeper than intended or a variant is being returned repeatedly.
Which variant, not just which product, is driving the last day's sales?
Because the report breaks sales down to variant and SKU, you can see whether one size, colour, or configuration is carrying a product's overnight performance. A product that looks like a strong seller in a summary may actually be one variant selling out while the rest sit still. Reading net quantity by variant tells you what to prioritise for a fast restock before the day gets ahead of you.
Is recent demand concentrated in a country or city you did not expect?
Scan Customer Country and Customer City against the products selling in the last 24 hours. A sudden cluster of orders from one location often traces back to a campaign, a feature, or an influencer post that landed overnight. Catching it early lets you confirm the source, check stock for those items, and decide whether to lean into the surge while it is live.
THE ANALYST'S READ: The Signal Most Merchants Miss
Most people open a 24-hour view to read one number: how much did we make overnight. The more useful read is the spread between gross sales and net sales at the line level, because that spread is where a good-looking day hides a weak one.
A high gross sales figure paired with a soft net sales figure on the same product line usually points to one of two things. Either a discount is applied more aggressively than planned, or returns are landing against items that only just sold. On a rolling daily view, a return value that keeps reappearing against the same SKU day after day is worth checking, since it may signal a sizing, quality, or listing problem rather than normal churn. Compare the returns column against net quantity for that variant, and if units are moving but returns keep pace with them, the product is selling and unselling at once.
The habit worth building is to read this report as a margin check on the last day, not just a sales tally. The rolling window gives you the head start; the line-item detail tells you whether the sales you are celebrating are actually sticking.
How Can You Automate the Last 24 Hours Orders Report?
The value of this report is having the overnight picture ready before you sit down. Open the pre-made Last 24 Hours Orders report in Report Pundit, where the columns are already set, and save it. Then schedule it to send on a fixed frequency, daily or more often, so the latest day arrives without a rebuild. Because the 24-hour window rolls forward on its own, every send covers the most recent day with no manual date changes.
You can deliver it to email, Google Sheets, Google Drive, FTP, Slack, and other connected destinations, and auto-send it to your team, your VA, or your accountant on the same schedule. Export options include Excel, CSV, and PDF.
Frequently Asked Questions
How do I see only the last 24 hours of orders in Shopify?
Shopify's native Orders page shows a flat list you filter by hand and cannot schedule. The Last 24 Hours Orders report in Report Pundit is fixed to a rolling 24-hour window and saved as a standing report, so it always shows the most recent day without manual filtering.
Does the report update on its own?
Yes. The 24-hour window rolls forward each time the report runs or is scheduled, so it always covers the most recent day. For a continuously refreshed copy, pair it with a scheduled Google Sheets export.
Why does one order show more than one row?
The report is built at the line-item level, so each product sold on an order appears on its own row with its own sales values. An order containing three products shows three rows. This is what lets you read sales by product and variant rather than as a single order total.
What is the difference between gross sales and net sales in this report?
Gross sales is the product price multiplied by quantity sold on a line, before any deductions. Net sales is that figure after discounts and returns are removed. Reading them together shows how much of the last day's sales survived discounting and returns.
Can I get it emailed to me every morning?
Yes. Schedule it to send at a set time, including several times a day, to email, Slack, Google Drive, Google Sheets, or FTP.
Can I focus the report on one product or location?
Yes. Add a filter to narrow it to a single product, variant, or customer country, and save that version to reuse.
Can I export the report?
Yes. Download it as Excel, CSV, or PDF, or push it straight to Google Sheets or Google Drive.