Developer forum

Hi Anders

What loop are you referring to? I cannot find a most frequently bought loop...

BR Nicolai

Hi Nicolai,

We have this function: "GetFrequentlyBoughtItems" in "Dynamicweb\eCommerce\CustomerCenter\Renderer.vb" and the sql-statement sums the quantity here: Sum(EcomOrderLines.OrderLineQuantity) AS ProductAmount which I think should be: Count(EcomOrderLines.OrderLineProductID) AS ProductAmount.

Best regads, Anders

Hi Anders,

This bug has been created as TFS-28533.

Kind regards

Christian

Hi Anders

The problem TFS#28533 "GetFrequentlyBoughtItems uses sum instead of count" has now been fixed in version 9.1.4

You are able to find this build in the download section:

http://doc.dynamicweb.com/releases-and-downloads/releases

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

Hi,

Sorry for waking the dead here - but we are experiencing this problem again.

The module Customer Center has this loop GetLoop("FrequentlyBoughtItems").

It is listing the items that are bought with the highest quantity - not most frequently.

Has this bug re-introduced itself?

Testet in 9.6.12 and 9.7.4

Kind regards

Mikkel Ulstrup

Hi Mikkel

Just checked the code - it is still using Count.

Only changes in the past 4 years is taking order contexts into consideration and handling BOM items.

BR Nicolai

Hi Nicolai,

We do have different contexts on the solution. I will check again and return.

Thank you for the quick reply!

- Mikkel

Hi again,

It works as expected.  We were missing an orderstatus on the orders we got from the ERP system. 

Kind regards

Mikkel Ulstrup