Top N products by sale

Top  Previous  Next

The Top N products by sale web part displays the top N best-selling products. The best-selling products are chosen according to the frequency of their occurrence in customers' orders, not according to the total volume of sales.

 

For instance, if a customer buys 10 items of the product A and 2 items of the product B and a second customer buys 4 items of the product B, the product B is evaluated as the best-selling.

 

You can modify the functionality of Top N products by sale by setting following properties in the Web Part properties dialog:

 

topNproducts1_up

 

 

Content filter main properties

 

Path

Path of the documents to be displayed.

Document types

Types of documents that should be displayed, separated with a semicolon (;).

Select top N products

Indicates how many best-selling products should be displayed.

WHERE condition

WHERE part of the SELECT query.

ORDER BY expression

ORDER BY part of the SELECT query.

 

 

Transformations main properties

 

Transformation name

Transformation used in the list view mode.

 

 

topNproducts2_up

 

On the sample E-commerce site at the Products page, the Top N products by sale web part is configured to display 4 products at most from the currently chosen products category. Its properties are set to the following values:

 

Show for document types: CMS.MenuItem

The given web part is displayed only in CMS.MenuItem documents. On the sample E-commerce site, the given web part is therefore displayed only in the list of products of a chosen category and is hidden in the product detail.

 

Path: ./% 

Only best-selling products from the currently selected category are displayed. For more information about the path expressions please refer to Appendix B - Path expressions chapter in Kentico CMS Developer's Guide.

 

Select top N products: 4

The maximum of 4 best-selling products is displayed.