Marketing Widgets

Marketing Widgets

My Top Selling Items

My Top Selling Items is an Account Level version of Top Selling Items feature. It displays the most ordered items for the logged in user’s account.

Types of Display

There are two views for “My Top Selling Items”. One is shown as a carousel and is shown on the shopping cart page. The other is a list section and is available to users once they log in. Both are built from the data specific to that user’s account and both are sourced from the same location. The data comes from JDE and is saved to a K-Rise table for the Account Top Selling Items. That table is refreshed by a scheduled batch job.

Carousel

The top selling items for the logged in user’s account are displayed in a carousel that allows the user to quickly scroll through the items they have purchased the most.

In the carousel, each top selling item shows some basic information and allows the user to perform these actions.

List

This list will display the same items as the carousel, but it comes from a list in the “My Lists” feature.

If you navigate to the “My Lists” feature, each active account will have an auto created list called “Account Top Selling Items List”.

Any time items are added to the K-Rise table for the Account Top Selling Items, it is also maintained in this list.

How Items are Considered Top Selling

There is a batch job called “TopSellingItemsAccount” which can be run from the “Work with Batch Jobs” page under “Site Management” from the admin panel.

The account level batch job first selects all the active accounts, then for each account, performs the following steps

First it deletes all the records in the K-Rise table for top selling items (EC_TopSellingItemsByAccount). It then runs a query to select the most ordered items from the JDE order history detail tables (F4211 and F42119) for that account and one by one, it adds them to the K-Rise table.

The items only get added if they also exist in the K-Rise Item Master. This way, if the admin has placed restrictions on the site to only allow a certain type of items to be imported and viewable in the site, those same restrictions extend to this import. If it wasn’t found in the item import due to various filters, it won’t be added here.

It does this in a loop until it either has enough to fill the carousel or it reaches the end of the list of ordered items in JDE.

It then continues to populate the Auto Created list in EC_Lists from the EC_TopSellingItemsByAccount table it just populated. This ensures that the list in the “My Lists” feature stays in sync with the carousel.

Changing the Number of Items that Display In the Carousel

The number of items that display is stored in a configuration variable and can be edited in the Feature Configurator through the Admin panel. To edit this, log in as admin and navigate to “Feature Configurator” under “Site Management”. Find and click on the configuration “TopSellingItems” to open all the variables and find “DisplayNumberOfTopSellingItemsAccount”. Enter a numeric value in this text box to display that number of items in the carousel.

Work with Top Selling Items Admin Panel

The Work With Top Selling Items Admin Panel allows the admin to edit the items in our K-Rise table which stores the top selling items. Although the items that are auto-filled into this table come from JDE, if the admin would like to add his/her own, it can be done here. Similarly, if the admin wanted to remove one of the items from displaying, there is a delete button next to each item in the list.

This is the same Admin Panel for both Top Selling Items (Site Level) and My Top Selling Items (Account Level), so make sure the radio button at the top is set to Account when editing.

Developer Notes

K-Rise Tables

EC_Lists

  • AutoCreated=’True’
  • OwnerId=’[WebAccountId]’

EC_TopSellingItemsByAccount

JDE Tables

F4211

F42119

Configuration Variables

$EP_Profile_TopSellingItems_Default_DisplayNumberOfTopSellingItemsAccount

Processes

PRC-10000532 Top Selling Items: Account

PRC-10000533 Top Selling Items: Account - Insert

PRC-10000526 Top Selling Items: Account - Create List

Webparts

WPT-10001262 Cycling Items Widget - Parameters

Top Selling Items

Top Selling Items displays the most ordered items at a site level. These items are displayed in a carousel that allows the user to quickly scroll through the items that have sold the most in JDE. The data comes from JDE and is saved to a KRise table. That table is refreshed by a scheduled batch job.

In the carousel, each top selling item shows some basic information and allows the user to perform these actions.

How Items are Considered Top Selling

There is a batch job called “TopSellingItemsSite” which can be run from the “Work with Batch Jobs” page under “Site Management” from the admin panel.

The site level batch process first deletes all the records in the K-Rise table for top selling items (EC_TopSellingItems). It then runs a query to select the most ordered items from the JDE order history detail tables (F4211 and F42119). One by one, it adds them to the K-Rise table.

The items only get added if they also exist in the K-Rise Item Master. This way, if the admin has placed restrictions on the site to only allow a certain type of items to be imported and viewable in the site, those same restrictions extend to this import. If it wasn’t found in the item import due to various filters, it won’t be added here.

It does this in a loop until it either has enough to fill the carousel or it reaches the end of the list of ordered items in JDE.

Changing the Number of Items that Display In the Carousel

The number of items that display is stored in a configuration variable and can be edited in the Feature Configurator through the Admin panel. To edit this, log in as admin and navigate to “Feature Configurator” under “Site Management”. Find and click on the configuration “TopSellingItems” to open all the variables and find “DisplayNumberOfTopSellingItemsSite”. Enter a numeric value in this text box to display that number of items in the carousel.

Work with Top Selling Items Admin Panel

The Work With Top Selling Items Admin Panel allows the admin to edit the items in our K-Rise table which stores the top selling items. Although the items that are auto-filled into this table come from JDE, if the admin would like to add his/her own, it can be done here. Similarly, if the admin wanted to remove one of the items from displaying, there is a delete button next to each item in the list.

This is the same Admin Panel for both Top Selling Items (Site Level) and My Top Selling Items (Account Level), so make sure the radio button at the top is set to Site when editing.

Developer Notes

K-Rise Tables

EC_TopSellingItems

JDE Tables

F4211

F42119

Configuration Variables

$EP_Profile_TopSellingItems_Default_DisplayNumberOfTopSellingItemsSite

Processes

PRC-10000531 Top Selling Items: Site

Webparts

WPT-10001262 Cycling Items Widget - Parameters

Recommendations (Related Items)

When viewing an item on the item main page there is a carousel that contains recommended items. This allows the user to quickly scroll through items that are considered related.

In the carousel, each recommended item shows some basic information and allows the user to perform these actions.

How are Items Considered Related

There is a batch job called “RelatedItems” which can be run from the “Work with Batch Jobs” page under “Site Management” from the admin panel.

The batch job will first delete all records from the K-Rise Table EC_RelatedItems. Then it will go through all the items stored in the K-Rise Table EC_Item_Master and find related items first in JDE then in the K-Rise tables (EC_Item_Master and EC_Item_Branch) and store the max number of items from each in the K-Rise table EC_RelatedItems. The max number is determined by a configuration variable that is editable in the admin panel.

JDE Related Items

The process will go through the JDE order history detail tables (F4211 and F42119) and find all the orders that contain the current item that is processing and choose other items in the orders to be considered related. It will confirm that the item and related item exists in the K-Rise Item Master table and check if the record already exists in the K-Rise Related Items table to avoid duplicate records. If it does not already exist, it will then save the record to the K-Rise Related Items table with the type JDE.

K-Rise Tables Related Items

The process will go through the K-Rise items tables (EC_Item_Master and EC_Item_Branch) to find related items. It compares the items to see if they are from the same catalog and have the same Category 1, 2, and 3 codes. It will check if the item and related item pair exists in the K-Rise Related Items table to avoid duplicate records. It will then save the record to the K-Rise Related Items table with the type Category.

Work with Related Items Admin Panel

The Work with Related Items Admin Panel allows the admin to look up all the related items for a particular item. It will show the item number, related item number, and description, as well as where the related item came from. Clicking on the item numbers will open on the Item Quick View to give more information about that item.

ADD TO COMPARE - This button will add the item to the compare list.

MORE DETAILS - This button will forward the user to the Item Main Page.

ADD TO CART - This button will add the item to the cart.

Changing the Number of Items that Display

The number of items that display is stored in a configuration variable and can be edited in the Feature Configurator through the Admin panel. To edit this, log in as admin and navigate to “Feature Configurator” under “Site Management”. Find and click on the configuration “RelatedItems” to open all the variables and find “NumberToStore”. Enter a numeric value in this text box to display that number of items in the carousel.

Developer Notes

K-Rise Tables

EC_Item_Master

EC_Item_Branch

EC_RelatedItems

JDE Tables

F4211

F42119

Configuration Variables

$EP_Profile_RelatedItems_Default_NumberToStore

Processes

PRC-10000534 Related Items WORKER

PRC-10000535 Related Items From JDE

PRC-10000536 Related Items From Category

Webparts

WPT-10001268 ECItemMainPage

        

Recently Viewed Items

There is the recently viewed items carousel on the ECShoppingCart page. Once a user views an item and opens the item main page, this item will be added to the carousel. The order of the items are based on the viewed timeline.

In the carousel, each recently viewed item shows some basic information and allows the user to perform these actions.

Source of Data

There is a process which is called once the user enters the Item Main Page. This process will update the EC_Items_Viewed table. It adds the item if it is new or updates the viewed time if it has been previously viewed. This table has two keys, user id and item number. We check the record based on both of them.

Once the total number of items has reached the max (right now hardcoded to 20), then the table will delete the top 1 record based on the ascending order of view time.

Changing the Number of Items that Display In the Carousel

The number of items that display is stored in a configuration variable and can be edited in the Feature Configurator through the Admin panel.

To edit this, log in as admin and navigate to “Feature Configurator” under “Site Management”.

Find and click on the configuration “RecentlyViewedItem” to open all the variables and find “DisplayNumberOfRecentlyViewedItem”.

Enter a numeric value in this text box to display that number of items in the carousel.

Developer Notes

K-Rise Tables

EC_Items_Viewed

  • UserId
  • ItemNumber

        

Configuration Variables

$EP_Profile_RecentlyViewedItem_Default_DisplayNumberOfRecentlyViewedItems

WebParts

WPT-10001196 Cycling Items Widget

WPT-10001268 B2B Item Main Page

Processes

PRC-10000540 Item Viewed

Categories


On the default (login) page, there is a carousel which displays the Categories for the site. This Carousel is located on the default (login) page.

Clicking on a Category forwards to the catalog page with a filter to show only the selected category.

How the carousel is populated

Default (Categories)

When the type is set to Categories the carousel will be populated with categories from the K-Rise Table Solr Attribute Values for the particular site and has a large image associated with it. The Title can be set from the admin panel. In the admin panel the type should be set to Categories.

Hard Code

The admin can hard code categories that they want the carousel to be populated with. This is done through the admin panel. In the text box for Category HardCode the admin will enter comma separated categories. If the category exists in the K-Rise Solr Attribute Values table the link and image will be populated otherwise it will be an empty box.

How to change Type, Title, and Hard Coded Categories

Login as an Admin and navigate to “Work With Pages”. Find the Default page and click “Design”.

Once the designer is open, find the Category Carousel webpart (WPT-1094) then click on edit properties. There will be a text box  labeled Category Hardcode where comma separated categories will be entered. The Type can be be set to HardCode for Hard Coded categories or Categories for the Default mode. Then a Title can be set in the A Category Title text box.

Developer Notes

Webparts

WPT-10001094 Category Carousel

K-Rise Tables

EC_Solr_Attributes

EC_Solr_Atrribute_Values