Changing Product Names and Combining Details on Report

[Ashley1225]

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?

[Report-Pundit]

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.

[CloudlabSam]

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.

[Sviat_nov]

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!

[Monty_3540]

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