What Is the Deleted Products in Order Report?
Deleting a product from your Shopify catalog does not necessarily erase its appearance in past order records. The Deleted Products in Order report helps you find order history associated with products that are no longer in the catalog.
It brings together order dates, names, product identifiers, and sales figures in one view. This is useful when you need to trace historical revenue, answer a question about an older order, or review sales tied to products that have since been removed.
Choose the period you want to examine. This is a historical sales-and-order view, not a list of currently available products or an inventory report.
Report Overview
- Report period
- A date range selected when generating the report.
- Included data
- Date, Order Name, Order Count, Gross Sales, Net Sales, Shipping, Total Sales, Product Name, and Product ID.
- Best for
- Tracing orders and historical sales linked to products deleted from the catalog.
- Export options
- Excel, CSV, TXT, and PDF.
- Delivery
- The report can be saved and scheduled for email delivery.
What Can You Learn from Deleted Product Order History?
1. Trace sales from products no longer listed
Identify historical transactions associated with removed products without relying on the current catalog.
Example: A discontinued lamp still appears against an order from last quarter.
What you can do: Keep a record of past sales when reviewing discontinued lines.
2. Locate the original orders
Use Order Name and Date to narrow down the transactions connected to a deleted product.
Example: A customer asks about an item that was removed months ago.
What you can do: Find the relevant order reference before responding.
3. Review financial history
Compare the displayed Gross Sales, Net Sales, Shipping, and Total Sales to understand the historical sales values represented in the report.
Example: A deleted item appears in orders with both gross and net sales figures.
What you can do: Use the amounts as a reference during a sales-history review.
4. Separate similarly named past products
Use Product ID together with Product Name when an old catalog had repeated or revised names.
Example: Two discontinued products were both named “Basic Tee.”
What you can do: Use their product IDs to distinguish the records.
What Should You Check First in This Report?
Start with the identifying fields, then review the sales amounts in the context of your reporting period.
- Product ID and Product Name: Confirm which historical product each row refers to.
- Order Name and Date: Locate the order and establish when the transaction occurred.
- Order Count: Check how many orders are represented, especially if the view is grouped.
- Gross Sales, Net Sales, Shipping, and Total Sales: Review the values separately rather than assuming they are interchangeable.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Investigating a past order for a deleted item | Order Name, Date, and Product Name help locate the relevant historical transaction. |
| Reconstructing sales history for discontinued products | Gross Sales, Net Sales, and Total Sales provide a reference for older sales activity. |
| Checking catalog cleanup after removing products | Shows which deleted products still appear in past orders. |
| Distinguishing products with reused names | Product ID helps separate records with similar Product Names. |
| Preparing a historical order export for review | Combines the identifying order fields and reported sales amounts in one shareable file. |
How to Create This Report in Data Export
Start with the premade report and adapt the view to the period or question you need to review.
- Open Data Export and find the premade “Deleted products in Order” report.
- Open the report and review the included fields, especially Product Name, Product ID, Order Name, and sales columns.
- Choose the date range, then use available sorting or filters to focus the results if needed.
- Save the report, and export it in your preferred supported format.
- If you need regular reviews, configure scheduled email delivery to the appropriate recipients.
Make the Most of This Report
A few small checks make historical product records easier to interpret and share.
01 / DATE RANGE
Keep the period clear: Use a defined reporting window so historical comparisons have consistent boundaries.
02 / IDENTIFIERS
Check IDs as well as names: Product names may be reused; Product ID adds a more reliable reference.
03 / SALES VALUES
Read totals carefully: Check the row grouping before assigning an order-level sales or shipping value to one product.
04 / SHARING
Share only what is needed: When exporting for review, consider whether recipients need every order reference and amount.
Frequently Asked Questions
Can this report show orders containing products deleted from Shopify?
Yes. Its stated purpose is to identify historical orders associated with products deleted from the catalog.
Does deleting a product remove it from past order history?
Not necessarily. Past order records can retain the product information needed for historical reference; this report brings that information into one view.
Which fields help me identify a deleted product?
Product Name and Product ID identify the item, while Order Name and Date help locate its historical orders.
Does this report show inventory availability or profit?
No. Neither inventory quantities nor product costs or profit are included in the supplied field list.
Can I export or schedule this report?
The report can be exported in Excel, CSV, TXT, and PDF, plus recurring email schedules. Review the chosen report settings before delivery.
