Changing Product Names and Combining Details on Report

Shopify Discussion

Topic summary

A store owner updated product titles to differentiate variants (e.g., adding “Green” to distinguish from a new “Black” option), but Shopify’s native reports now display these as separate line items instead of consolidating them under one product. This creates confusion for inventory tracking and reporting.

Problem: Changing a product name generates a new report entry, even though the product ID remains the same. The user wants to merge historical data with current titles.

Proposed Solutions:

  • Three third-party reporting apps were suggested (Report Pundit, Report Toaster, Mipler: Advanced Reports), each claiming ability to consolidate sales data under current product titles using custom logic.

Community Feedback: One user criticized this as a fundamental Shopify limitation, arguing that reports should track by product ID rather than title, and that basic functionality shouldn’t require paid third-party apps.

Status: The issue remains unresolved within Shopify’s native reporting. Workarounds require external applications with free trial periods available.

Summarized with AI on October 27. AI used: claude-sonnet-4-5-20250929.
1

When we originally started our store, we named our products. Some products have had their name/title updated since the store opened. I have noticed after changing the product name/title, it creates a new line item on our reports which makes it difficult to read/inventory.

Is it possible to combine these products so it does not show 2 line items?

Example:

Old Title: 12" C9 SPT-1 Socket Wire

New Title: 12" C9 SPT-1 Socket Wire, Green

Both items are the exact same thing. Both are green. We just updated the 2nd title after bringing in a Black Wire option so customers can see the difference of the products in the titles.

Is it possible to merge those 2 items in our reports so they do not show as 2 line items?

2

If you are using a consistent pattern to update all newly updated product titles, our custom reporting options can display newly created product Title in a single line. To confirm this, please install Report Pundit, and we will create a report tailored for you. Take advantage of our 14-day free trial to explore its features.

3

Our Report Toaster app can help. We can consolidate all sales automatically under the current title. Please feel free to take a look and reach out to support if you need any help.

4

Hi @Ashley1225 ! My name is Sviat from Mipler: Advanced Reports!

Our application can help create such a report, taking into account the necessary logic for displaying the title for the product. Accordingly, data on the changed product will be displayed in one line.

Additionally, you can add other columns to your reports for analyzing data, or other custom solutions according to your wishes.

To prepare various reports, you can check the Mipler app and write to our support - we will be happy to help!

5

This is another one of Shopify’s quite frankly, unacceptable limitations
Why does it create a new item for analysis, when it should be set by the product ID when it was created?

You shouldn’t need to install a 3rd party app, for the most basic of things that Shopify should cover…