Analytics Visualization Bug: Products and SKUs Duplicating in Reports

Data and Analytics
,
1

Hi everyone,

Since this 24th of August, we’ve noticed a bug in Shopify Analytics: almost all products and SKUs are appearing twice (sometimes more) in “List by dimensions” visualizations. Draft items are also showing up, even when they shouldn’t.

Screenshot 2025-09-04 at 10.41.10
Screenshot 2025-09-04 at 10.41.103184×1476 332 KB

  • Issue appears in all our stores.

  • Data looks fine in the report itself — the problem is only in visualization mode.

  • Tried “Product title at time of sale” and “Product variant SKU at time of sale”, but the duplication remains.

  • The only thing that help is adding another dimension - “Product ID”

Shopify Support confirmed this is happening on their end too and escalated it internally. But still no updates.

Is anyone else seeing the same issue? Any workarounds that helped you?

Thanks,

Gregory

2

Hi @ArkhipovG

This issue of duplicated products in your reports is almost always caused by small, invisible inconsistencies in your product data, such as stray spaces or differences in capitalization (e.g., SKU-100 vs. sku-100). To fix this, you need to clean your data.

The most effective way to do this is to export your products as a CSV file and open it in a spreadsheet program like Google Sheets or Excel. There, you can use the TRIM function to remove any leading or trailing spaces from your SKUs and titles, and ensure that the capitalization is consistent across all similar items.

Once your data is clean and consistent, save the CSV and re-import it back into Shopify, making sure to check the box to “Overwrite existing products.” This will standardize your product data and should resolve the duplication issue in all of your future reports.

Hope this helps!

3

Hi PieLab,

I am sure that we are using the same SKUs with different names and this is the reason for duplicates. Amount of duplicates in visualization is the exact amount of different product IDs if they were sold in selected date ranges. Before the end of August visualization was working properly, then Shopify developers did something and broke it.

Here is explanation:
We have the same products with the same SKU which are both active (not draft) but with different names or same SKU/Title but different prices.

For example - “DETOX ME” and “DETOX ME Dekel Verified”, we need to see sales of this product in 1 row, not in 2 or 3, like it was before the end of August.

Another example - “CLEANSE ME” for 19$ and 14.5$ for upsell needs. We need 1 row of “CLEANSE ME”, not 2 rows. If we want 2 rows we will look at different dimensions, for example “product ID”.

At the moment the only solution is to put “Product ID” as a second dimension. Then visualization becomes normal.

Before the end of August visualization was working properly, we didn’t do any changes. It was Shopify developers who ruined it and still didn’t fix it.