Thread: How do Related products work?

The products that show up on the product page under "related items" are soooooo not related. What is the algorithm that determines they are related?

Picture this. You are viewing a Wireless Adapter and the related item is a wire. That is how out of whack this is.

These will correct themselves as time goes on. This is heuristic data that is compiled over time as products are viewed at the same time as other products. Of course, someone with a unique set of requirements or someone just casually browsing early on in the process may foul things up originally, but the idea is that over time people will view items that are related to each other (eg. someone viewing a wireless adapter may also view a wireless router or access hub, or an ethernet cable). However this same person could also view a wireless adapter, a frying pan, a jug of windshield washer fluid, and a candy bar, but under normal circumstances you won't see this happen very often. As more and more people view relevant items the related items will work themselves out. You could always disable the dynamically related products through the admin section in the appconfig parameters, or if you really want the logic for this is almost wholly found in the aspdnsf_GetCustomersRelatedProducts stored procedure and is based on records that can be found in the dbo.ProductView table.

Thanks George, is there a way in the db to specifically remove 1 or 2 related items? I suspect it has a high value due to original testing perhaps.

You could remove records from the ProductView table where ProductID = the product that is showing up where it shouldn't.