Priority of "Customers who bought this product also purchased" product listings?

[lolwaut]

I have a quick question about the "Customers also purchased" built-in module. Is there any kind of rhyme or reason as to what products get shown in the "Customers who bought this product also purchased" section of the product info pages? For instance, I think it would make the most sense to have it list the products that have been most frequently purchased with the product the customer is viewing. I'm not sure if that is how it is already set up or not? Does anybody know?

The reason I ask is because the products that get listed on my product info pages seem to be pretty unrelated to the product itself... now, I'm sure that some customers that bought the product have also bought the products that get listed, but it doesn't seem like it is listing the most frequently purchased products that have been paired with the product on the product info page... but I really can't say for sure, as I don't know how I would go about checking into that.

So, if anybody knows how it selects which products to display, I would love to know! Thanks!

[gilby]

I have a quick question about the "Customers also purchased" built-in module. Is there any kind of rhyme or reason as to what products get shown in the "Customers who bought this product also purchased" section of the product info pages? For instance, I think it would make the most sense to have it list the products that have been most frequently purchased with the product the customer is viewing. I'm not sure if that is how it is already set up or not? Does anybody know?

The reason I ask is because the products that get listed on my product info pages seem to be pretty unrelated to the product itself... now, I'm sure that some customers that bought the product have also bought the products that get listed, but it doesn't seem like it is listing the most frequently purchased products that have been paired with the product on the product info page... but I really can't say for sure, as I don't know how I would go about checking into that.

So, if anybody knows how it selects which products to display, I would love to know! Thanks!

If you have a look at the query here
includes/classes/db/mysql/define_queries.php
You will see that it is ordered by purchased date desc

order by o.date_purchased desc 

That means it will be ordered according to the most recently purchased item with the current item.

Not the items that have been sold the most with that item.

[lolwaut]

Thanks a lot! Now for the REAL question: Is there any way of changing it to products that are most frequently purchased with the item?

[gilby]

Thanks a lot! Now for the REAL question: Is there any way of changing it to products that are most frequently purchased with the item?

Of course it can.
But I don't have time to play with this as its not a priority for me.

Others may have a go at it or you might need to brush up on your mysql and have a go yourself.
I have shown you the file where it needs to be edited.