Shopify Analytics Update: How to Recover Sales Data for Deleted Products

Hey there, fellow store owners! At Shopping Cart Mover, we're dedicated to ensuring your e-commerce data is always accurate and actionable, especially when navigating platform changes or migrations. Recently, a significant shift in Shopify's analytics framework has caused a bit of a stir, leading to a common and frustrating issue: those head-scratching 'none' values popping up in your sales reports, particularly for products you've discontinued or deleted.

If you've migrated to Shopify's updated analytics framework (the one that rolled out around October 2024), you're probably familiar with this problem. It came up in a really helpful community thread started by a merchant named Cocochew, who perfectly articulated the problem many of us are facing. They noticed thousands of dollars in sales suddenly appearing as 'none' across product fields, making it impossible to track performance for discontinued items. Sound familiar? You're definitely not alone.

The good news is, we've got some solid insights and clear steps from that discussion to help you recover that vital historical sales data. Let's dive in and fix this together!

What's Happening Behind the Scenes? Understanding the 'None' Phenomenon

So, why are we suddenly seeing 'none' where product titles and vendors used to be? It all boils down to a fundamental shift in how Shopify's analytics system references product information. As Cocochew brilliantly explained, the previous analytics system took a 'snapshot' of product details at the time of sale. That meant if you sold a widget, the report would forever show 'Widget' even if you deleted the product later.

The updated analytics, however, work differently. They now perform a dynamic lookup, trying to pull product details from your current product records. This is where the problem creeps in. If you've deleted a product, there's no current record for the system to reference. The result? A big, fat 'none' staring back at you in your reports.

This isn't just for manually deleted products, either. If you use a third-party POS integration that removes SKUs from Shopify when they're discontinued, you could be seeing the same data gaps. The impact can be significant:

• Sales showing as 'none' for product title, vendor, or type.
• Missing revenue attribution for discontinued items, making historical performance analysis impossible.
• Incomplete historical product performance data, hindering strategic decision-making.

Shopify's own documentation confirms this change: "The previous analytics default to using a product’s title, variant title, SKU, and vendor at the time of sale. The current Analytics default to using a product’s current title, variant title, SKU, and vendor."

The Solution: Leveraging 'Product Title at Time of Sale'

The key to recovering your historical data lies in understanding and utilizing the correct dimensions within Shopify's analytics. To see all sales by product, you need to use the "Product title at time of sale" dimension instead of the default "Product title" when building or editing your reports. This crucial field preserves the product information as it existed when the sale occurred, regardless of whether the product has since been deleted from your store.

Step-by-Step Guide to Rebuilding Your Reports:

Don't let missing data impact your business insights. Follow these steps to adjust your Shopify reports:

1. Go to your Shopify Admin and navigate to Analytics > Reports.
2. Click on New exploration to create a new report, or select an existing saved report that you need to fix.
3. In the Dimensions menu (usually on the left sidebar), you'll need to replace the problematic dimensions.
4. Find "Product title" and replace it with "Product title at time of sale".
5. If your reports use product variants, also find "Product variant title" and replace it with "Product variant title at time of sale".
6. Keep your existing metrics (e.g., gross sales, net sales, items sold, etc.) as they are.
7. Once you've made these changes, Save your updated report.

This simple adjustment will bring back the accurate historical data you need to make informed business decisions.

For the Advanced User: ShopifyQL Template

If you're comfortable with ShopifyQL, here's a rough template that incorporates the 'at time of sale' dimensions:

FROM sales
SHOW net_items_sold, gross_sales, discounts, sales_reversals, net_sales, taxes, total_sales
GROUP BY product_title_at_time_of_sale, product_vendor_at_time_of_sale, product_type_at_time_of_sale WITH TOTALS
SINCE 2023-01-01 UNTIL 2024-12-31 (use your own desired date range)
ORDER BY net_items_sold DESC

Note: The 'returns' field on the current reporting will be deprecated in May 2026 and is replaced with 'sales_reversals'. Also, ensure you use the `_at_time_of_sale` suffix for all product-related dimensions you wish to preserve historically.

Important Considerations and Best Practices

Finance Reports Remain Unaffected

It's worth noting that Shopify's Finance reports still use "at time of sale" by default, so they are generally unaffected by this change. This means your core financial reconciliation should remain accurate, but detailed product performance reports will need the adjustments outlined above.

Data Export Limits

If you have a large store with more than 1,000 product rows in your report, you might need to export the data or use smaller date ranges to see complete results within the Shopify analytics interface. For comprehensive, flexible reporting beyond Shopify's built-in tools, a dedicated reporting app can be invaluable. Mipler Reports, for example, offers advanced features for "snapshot at time of sale" reporting with easier exports and more flexible grouping, as mentioned in the community thread.

Preventative Measure: Archive, Don't Delete!

The best way to avoid this issue in the future is to change your product management strategy. Instead of deleting discontinued products, consider using the "Archived" status. Archived products preserve all historical data relationships and will keep your analytics intact, ensuring you never lose valuable sales history.

Why This Matters for Your Business (and Migrations)

Accurate historical sales data is the backbone of smart business decisions. It informs inventory planning, marketing strategies, product development, and understanding customer behavior. For merchants considering or undergoing a platform migration, like those we assist at Shopping Cart Mover, understanding these data nuances is critical. Ensuring your historical sales data is correctly mapped and accessible post-migration is paramount to maintaining business continuity and growth.

We hope this detailed guide helps you recover your historical product sales data and empowers you to leverage Shopify's analytics more effectively. Don't let a technical change obscure your business's past performance!