I actually had the same exact thing happen to me yesterday. I am still struggling with it a little bit, however, I managed to get rid of the (1) (2) etc.
How I did it:
In the search of the product I used Grouping and filtered out the name of the product and showed the first one in the list.
Grouping Explanation: [New Feature] Grouping and Aggregating Data
I am still struggling with being able to click on it to show relative data but it seems like a step in the right direction. If you get passed this please post the answer so I can take a look too. I would appreciate it.