Thread: Duplicated Product...

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

Were you importing products thru excel before? Are you sure that all fields have the same value including SKU + Product name? Did you happen to customize the import logic in the software or the like? This is my first time seeing this problem, so we need more details. We can't even replicate this with any of our stock copy. What version are you on?

Hi Alfred,

All products have been imported through excel.
I'm using 7.1.0.0/7.1.0.0
The import logic has not been modified.

I'm not too concerned about the cause - it's only happened twice with over 1000 products - I'm more interested in finding out which table those fields are being pulled from in aspdnsf_GetProducts so I can (manually) fix it.


TTFN

BFG

They should be from Product and ProductVariant tables.

I don't have a field named locale in either of those tables......


TTFN

BFG

Anyone able to offer any assistance here?

It's not actually a column/field but simply, an ML tag added to the Product and Product Variant Name columns. Like for instance:
Product:

Code:

<ml><locale name="en-PH">Simple Product</locale><locale name="en-US">Simple Product</locale></ml>

Product Variant:

Code:

<ml><locale name="en-PH">Simple Product Variant</locale><locale name="en-US">Simple Product Variant</locale></ml>

Thanks Jao,

So given the excel screengrab above - my current productvariant name field for that variant looks like this?


<ml><locale name="3M">en-GB</locale><locale name="3M">en-US</locale></ml>

How would the first 2 of the highlighted entries in the xml/excel have different distributorid's to the last one - all three entries are identical except for the fields you can see?


TTFN

BFG

Anyone?


TTFN

BFG