What Is the Deleted Product List Report?
The Deleted Product List report helps you find products that have been deleted from your Shopify catalog but still appear in past orders. It brings together the product reference, order details, and recorded sales amounts so you can review transactions even when the original catalog entry is no longer active.
For a selected date range, the report shows the order date and name alongside gross sales, net sales, shipping, and total sales. This makes it useful for historical sales reviews, recordkeeping, and questions about orders containing products you no longer sell.
It is a report about deleted products found in order history, not a complete inventory of every deleted catalog record. Its sales figures reflect the report's configured period and calculation settings.
Report Overview
- Report type
- Sales & Order Reports; deleted products that appear in historical orders.
- Report period
- A date range you select when reviewing past transactions.
- Data included
- Nine fields covering order identity, sales amounts, product name, and product ID.
- Best for
- Historical sales checks, order research, and retaining a usable reference to deleted products.
- Export and frequency
- Excel, CSV, TXT, or PDF exports, with optional daily, weekly, or monthly email delivery.
What Can You Learn from Orders Containing Deleted Products?
1. Identify Past Orders Linked to Deleted Products
Product Name and Order Name help connect an item no longer in your catalog to the orders in which it appeared. Date gives the period for the transaction.
Example: A deleted winter accessory is still listed in a March order.
What you can do: Use the order reference to look up the original transaction when responding to a customer or conducting an audit.
2. Review Sales Associated with Removed Products
Gross Sales, Net Sales, and Total Sales provide context for sales tied to products appearing in order history. These figures are not the same as profit or cash received.
Example: A retired product appears across several older orders with a reported net sales amount.
What you can do: Compare the displayed figures to the source orders and review the report grouping before using them in a financial summary.
3. Investigate Differences Between Gross and Net Sales
Review the Gross Sales and Net Sales columns together to spot records that need a closer look. The listed fields do not identify the individual discount or refund behind a difference.
Example: An old order shows net sales below gross sales.
What you can do: Open the relevant order in Shopify to investigate the components of the difference.
4. Keep a Traceable Reference After Catalog Cleanup
Product Name and Product ID, when available, help reconcile historical order lines with older exports or internal notes. Deleting a catalog record does not make these sales records irrelevant.
Example: A support team needs to confirm which discontinued product a customer originally purchased.
What you can do: Save a dated export for reference and use the order name for further verification.
What Should You Check First in This Report?
Begin with the fields that make historical order research reliable:
- Order Name and Date: Match each row to the correct historical order and period.
- Product Name and Product ID: Check that the historical item can still be identified.
- Gross versus Net Sales: Flag differences and inspect the original order for the cause.
- Total Sales and Shipping: Confirm grouping before totaling rows or attributing shipping.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing historical orders for deleted products | Review older orders containing deleted products. |
| Answering a question about an older order | Find the old order and product name for a customer question. |
| Tracing sales records for a deleted product | Keep order and sales references for transaction checks. |
| Checking retired items during catalog cleanup | Find retired items that remain in historical orders. |
How to Create This Report in Data Export
Start with the premade report called Deleted products in Order in the Sales & Order Reports category:
- Open Data Export and find the Deleted products in Order premade report.
- Review the prepared columns: Date, Order Name, Order Count, Gross Sales, Net Sales, Shipping, Total Sales, Product Name, and Product ID.
- Select the reporting date range. Add a supported filter or change the sort order if you need to focus on specific records.
- Click Save, then export the report as Excel, CSV, TXT, or PDF. For regular delivery, schedule an email daily, weekly, or monthly.
Make the Most of This Report
These four practices help you interpret and deliver the report more consistently.
01 / DATE RANGE
Choose a defined period: Use the same reporting window when comparing historical sales across exports.
02 / ORDER CONTEXT
Check line-level context: Confirm how values are grouped before adding rows or assigning whole-order figures to a product.
03 / FILE FORMAT
Export for the task: Use Excel or CSV for further review and PDF for a fixed, shareable snapshot.
04 / RECIPIENTS
Limit who receives it: Schedule delivery only to teammates or advisers who need access to order and sales details.
Frequently Asked Questions
Can I see deleted Shopify products in previous orders?
Yes. This premade report is designed to show products deleted from the catalog that still have references in historical orders, along with the related order and sales fields.
Does the report list every product ever deleted from Shopify?
No. It focuses on deleted products found in order history. A product deleted without any historical order is not established by this report's supplied fields.
Can I find the original order for a deleted product?
Use Order Name and Date to identify the relevant historical order. Product Name and Product ID provide additional reference where available.
Does the report show profit or explain individual refunds?
No. The specified columns show sales values and shipping, but they do not include item costs, profit, discount reasons, or individual refund details.
Can I export or automatically email the report?
Yes. The supplied Data Export workflow supports Excel, CSV, TXT, and PDF exports and daily, weekly, or monthly email schedules after you save the report.
