Greetings All,
I'm having an issue where a product is being displayed twice.
The problem occurs both in an admin search & also on a category view.
Here's what I mean :-
http://www.3mselect.co.uk/c-327-optical-mice.aspx
You'll see that the Ergonomic Wireless Optical Mouse -Laptop / PC - USB Small (ProductID 1769) is being displayed twice.
That xmlpackage uses aspdnsf_GetProducts
I turned the debug on & dumped the runtime.xml then imported it into excel.
Here's a screengrab from excel :-
The 3 rows I highlighted are all for the same product - also - ALL the other fields (not in screenshot) are identical from one row to the next - including GUID.
All other products only have one row appearing each.
It looks to me like I need to get rid of the rows that have an entry in the locale & name2 fields.
Any idea which table that data is being pulled from so I can dig in & see what's happening?
Many Thanks,
BFG