Top
Top
LibraryEASYCommerce Reference ManualItems and Shopping Cart FeaturesItem Popularity

Item Popularity

The catalog has a Sort By option of “Popularity”. This will sort items based on high popularity to low popularity. This sorting is done based on the values assigned to the ItemPopularity column in K-Rise Item Branch Table ([EC_Item_Branch]).


How an Item is Considered Popular
Item Usage Type Weights
Item Popularity Calculation Example

How an Item is Considered Popular

Every time the Item Main Page is visited, Item Quick View is visited, the item is added to the cart, or the item is ordered an entry is created in the K-Rise Item Usage Table ([EC_Item_Usage]) where the item number and Usage Type is stored. Usage Types are Defined in The K-Rise Item Usage Types Table ([EC_Item_Usage_Types]). Types are MainPage, QuickView,  Cart, and Order. Each is assigned a weight.

There is a batch job called “ItemPopularity” (EASYProcess Process PRC-10000659) which can be run from the “Work with Batch Jobs” page under “Site Management” from the admin panel.

The process will get all the entries in the K-Rise [EC_Item_Usage] Table and get the weights for each Usage Type from the [EC_Item_Usage_Types] Table. For each item it counts how many entries there are for each type and multiplies that by the weight of the type. It then adds the results from each type and add that value to the K-Rise Item Branch Table ([EC_Item_Branch]) to the ItemPopularity column.

The process will clear the Item Usage Table as part of clean up.


Item Usage Type Weights

Each action that can be performed and recorded for an item has an associated weight. The weight is a numerical value associated with the Usage Type.

When determining the popularity of an item, its Usage Type counts are multiplied by their corresponding Usage Type Weight and then all those values are added together to form the popularity value.

(Usage Type 1 Count * Usage Type 1 Weight) + (Usage Type 2 Count * Usage Type 2 Weight) + … = Popularity Value

The weights of each action are stored in the Application database table [EC_Item_Usage_Types]. The counts of the usage types per item are stored in the Application database table [EC_Item_Usage].

Changing Usage Type Weights

To edit, Log in as admin and navigate to “Work With Usage Types” under “Site Management”. Here all the Usage Types and Usage Weights will be listed.

Click on edit to change a Usage Type’s weight. A window will popup with a text box. Change the value in the text box to a numeric value and click Save. The Usage Type Weight will now be updated and used the next time the batch job is run to perform the calculation and update each item’s popularity value.


Item Popularity Calculation Example

In this example below, we are going to compare the popularity of two items.

Item Number

Add To Cart Count

Ordered Count

Item Main Page Count

P001

10

5

1

180001

0

0

10

For this example, here are the assigned weights for each of the actions recorded above.

Usage Type

Weight

Add To Cart

2

Ordered

5

Item Main Page View

1

Item Number

Calculation

Popularity Value

P001

(10 * 2) + (5 * 5) + (1 * 1)

46

180001

(0 * 2) + (0 * 5) + (10 * 1)

10


Powered by EASYProcess (© 2019 K-Rise Systems, Inc).