Shopify Analytics Update: How to Recover Sales Data for Deleted Products (Say Goodbye to 'None'!)

Hey there, fellow store owners! Let's talk about something that's been causing a bit of a stir in the Shopify community recently – those head-scratching "none" values popping up in your sales reports, especially 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 frustrating issue.

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, you could be seeing the same issue. As Shopify's own documentation (which Cocochew kindly linked to) states:

"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."

It's a subtle but significant change that has big implications for historical reporting.

The Cleanest Fix: Reclaiming Your Data with "Product title at time of sale"

Thankfully, the community discussion quickly pinpointed the solution, and it’s a pretty straightforward one once you know where to look. Markk60 jumped in to confirm Cocochew's findings, emphasizing that using "Product title at time of sale" (and its variant counterpart) is indeed the "cleanest fix" to get accurate historical attribution back.

Step-by-Step: Rebuilding Your Reports

Here’s how you can adjust your existing reports or create new ones to capture that crucial data:

1. Navigate to Analytics: From your Shopify admin, go to Analytics > Reports.
2. Start a New Exploration (or Edit): Click on New exploration to build a new report from scratch, or select an existing saved report that's giving you trouble and click "Edit".
3. Swap Dimensions: In the Dimensions menu (usually on the left or top of your report builder), you'll need to replace the standard product fields.
• Replace "Product title" with "Product title at time of sale".
• If you're tracking variants, also replace "Product variant title" with "Product variant title at time of sale".
4. Keep Your Metrics: Don't worry about changing your metrics! Keep your existing ones like gross sales, net sales, items sold, etc.
5. Save Your Report: Once you’ve made these changes, make sure to save your updated report so you don't have to rebuild it every time.

Voila! You should now see actual product names instead of "none" for your discontinued items. It's a small change in the report builder, but a massive win for data integrity!

For the Code-Savvy: ShopifyQL Template

If you're comfortable with ShopifyQL and prefer to build your reports programmatically, Cocochew shared a fantastic template that incorporates the correct 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, product_type WITH TOTALS
SINCE 2025-01-01 UNTIL 2025-12-31 (use your own desired date)
ORDER BY net_items_sold DESC

Just a quick heads-up: the returns field on the current reporting will be deprecated in May 2026 and is replaced with sales_reversals, so it's good practice to start using the new field now.

Beyond the Quick Fix: Proactive Data Management & App Solutions

While the "at time of sale" dimension is a lifesaver, the discussion also brought up some excellent points about preventing this issue in the first place and considering other reporting avenues.

Archive, Don't Delete!

One of the most valuable insights from Cocochew was a simple but powerful recommendation: consider using "Archived" status instead of deleting products entirely. Archived products preserve all historical data relationships, keeping your analytics intact and avoiding the "none" problem down the line. It's a best practice that can save you a lot of headaches!

A Note on Finance Reports & Large Datasets

It's good to know that your Finance reports are generally unaffected by this change, as they still default to using "at time of sale" data. So, no need to panic about your accounting! Also, if you're dealing with a massive amount of data (more than 1,000 product rows), you might need to export the data or use smaller date ranges to ensure you're seeing complete results in your explorations.

When an App Might Be Your Best Friend

While Cocochew mentioned they personally try to keep apps to a minimum (a sentiment many of us share!), Markk60 made a great point about specialized reporting apps. If you find yourself constantly rebuilding explorations, or if you need more flexible grouping, easier exports, or more advanced "snapshot at time of sale" reporting capabilities, an app could be a fantastic solution. Markk60 specifically mentioned Mipler - Advanced Reports Mipler ‑ Advanced Reports - Custom reports and 100+ Reports of Sales, Tax, Inventory, COGS | Shopify App Store as a tool that handles this kind of reporting exceptionally well. It's definitely worth exploring if the built-in options aren't quite meeting your needs.

Navigating these analytics updates can feel a bit like detective work, but thanks to community discussions like this one, we can quickly get to the bottom of things and keep our stores running smoothly. Recovering that historical sales data for your deleted products is crucial for understanding your business's performance over time, making informed decisions, and ensuring your data tells the full story. So go ahead, update those reports, and get back to analyzing your sales with confidence!