ADSX
NOVEMBER 17, 2026

Find a Renamed Shopify Product in Historical Sales Reports

Build a product ID crosswalk so a catalog rename does not split a best seller or combine unrelated items.

AUTHOR
AT
AdsX Team
ECOMMERCE EDITORIAL
READ TIME
3 MIN
SUMMARY

Build a product ID crosswalk so a catalog rename does not split a best seller or combine unrelated items.

The buyer wants to know how many Sunday Cups sold last quarter. The report also shows Studio Cup, the name used before the spring catalog refresh. Adding the two title rows sounds reasonable until someone points out that a second product briefly used the same name.

ID 410 — Studio Cup — 12 units. ID 410 — Sunday Cup — 8 units. ID 912 — Studio Cup — Keep separate
ID 410 — STUDIO CUP — 12 UNITS. ID 410 — SUNDAY CUP — 8 UNITS. ID 912 — STUDIO CUP — KEEP SEPARATE

Original AdsX illustration.

Choose the dimension that answers the question

Shopify distinguishes the current product title from the title at the time of sale. The historical title helps answer what buyers saw. The current title helps merchandisers recognize the catalog today. In a report covering a rename, inspect which dimension is selected before interpreting two rows as two products. Shopify analytics field definitions

Build a small crosswalk with product ID, variant ID when relevant, historical title and current title. Use the same reporting period, sales channel, metric and currency on both sides. In our fictional example, product 410 sold 12 units as Studio Cup and eight as Sunday Cup. Combining those rows gives 20. Product 912 also used Studio Cup but belongs on its own row. Matching by title alone would attach its sales to the wrong design.

Reconcile the totals before adopting a new label

Export the report with historical titles and preserve the original columns. Ask an assistant to group by identifier and retain every distinct label as a review field. Check that units and net sales sum to the original totals. If the export lacks identifiers, look for a report configuration that supplies them. Hold ambiguous names for manual review. A similar spelling or matching price is weak evidence of identity. Shopify report dimensions and grouping

When one item was discontinued and a successor launched under a new ID, decide what the report measures. Buying teams may want a family total to forecast demand for the next design. Catalog operations may need separate totals to trace actual orders. Save the explicit family mapping and both IDs if you choose to combine them.

Finish by testing one transaction before and one after the rename. The current-title view should answer the buyer’s catalog question while the historical view still lets support recognize the item described on an old order.

Try the worksheet prompt

Illustrative prompt, not execution-tested.

Group these fictional sales rows by stable product ID and preserve historical and current names. Show units and net sales before and after grouping. Flag reused titles, missing IDs and successor products. Never merge on spelling alone.

Copy the prompt from the merchant library. For related work, see Why a Shopify Barcode Scan Finds Two Variants.

ABOUT THE AUTHOR
AT
AdsX Team
ECOMMERCE EDITORIAL

AdsX Team is the shared editorial byline for our Shopify and ecommerce publication. Guides combine primary sources with practical decision frameworks and clearly labeled examples. See our editorial policy for sourcing and corrections.

MORE BY ADSX TEAM →