Commerce

Enabling Bestseller Products Display in IBM WebSphere

What is Best seller

In order to record the categories and products browsed/purchased by a customer, in WCS, in her profile during a given visit to site, the server tracks orders placed for products in the category you specify. Each day, the server generates a best-seller list based on the current order data. When a customer views for specific product or category Best-seller lists can motivate customers to purchase products that are popular with other customers.

Why Best seller

Best-seller lists can motivate customers to purchase products that are popular with other customers.

Need to make best-seller lists more relevant, For example: When a customer sees the best-selling products from the Apparel category regardless of what they are shopping for.

Use this action in a web activity to display in an e-Marketing Spot a list of the best-selling products for a category you specify.

Choose an e-Marketing Spot for the web activity that is on a category or product details page.
Choose one of the Display options that displays the list only when a customer is viewing the specified category or its subcategories.

What happens if Best seller is activated

When you activate a web activity with the Display Best Sellers action, the server tracks orders placed for products in the category you specify. Each day, the server generates a best-seller list based on the current order data. When a customer views the e-Marketing Spot specified in the web activity, the best-seller list displays from that server generated data.

Example

Here is an example of a web activity that uses the Display Best Sellers action:

When a customer views the e-Marketing Spot in the home page, display a list of the 4 best-selling catalog entries from the Apparel category:

Storefront example of a best-seller list

How to enable to display Best sellers?

  1. Create Espot
  2. Create webactivity with the espot
  3. Enable listeners
  4. Run Schedulers

 

Creating “BestSellers_CatEntries” espot

When a customer views the e-Marketing Spot in the home page, display a list of the 4 best-selling catalog entries from the Apparel category:

Example of Action: Display Best Sellers

Creating “DisplayBestSellers” webactivity

Enable Listeners

Edit file “WC/xml/config/wc-server.xml” as follows:

  • Find the “<Marketing” element and set the value of its “version” attribute to “Dialog”.
  • Find the “<PersistentSession” element, and set the value of the “cookieExpiry” attribute to “30”
  • Find the “<PersonalizationId” element. Set the value of its “enable” attribute to “true”
  • Find the following string: compClassName=”com.ibm.commerce.marketing.dialog.trigger.SensorEventListener”
  • Ensure that the value of the “enable” attribute of that element is set to “true”
  • Find the following string: compClassName=”com.ibm.commerce.marketingcenter.events.runtime.ExperimentEvaluationECEventListenerImpl” Ensure that the value of the “enable” attribute of that element is set to “true”

 

Run Schedulers

Browse and place the orders as many as

  • Register as a test customer with the store in the test environment.
  • For the Display Top Browsed action, browse multiple, different catalog entries in the target category. For the Display Best sellers action, place orders for multiple, different catalog entries in the target category.
  • For Display Best Sellers only: Either wait 5 minutes or manually run the RaiseECEvent scheduled job. To manually run the job, open the RaiseECEvent scheduled job in the Administration Console, and then click OK, which forces the job to run immediately. This job must run so that the marketing services are informed of the test orders you placed. By default, this job runs every 5 minutes.
  • Manually run the SaveMarketingStatistics scheduled job. To manually run the job, open the SaveMarketingStatistics scheduled job in the Administration Console, and then click OK, which forces the job to run immediately. This job must run so that the marketing services can access order and browsing statistics in the database. By default, this job runs every 15 minutes.
  • Run an SQL query to force the daily processing of the best-seller or top-browsed list to occur again. Once a day at 2:00 a.m. (by default), the marketing services process the statistical data collected during the day, and update the top browsed/best sellers lists. On the day you are testing, if the send time has already passed, you can force the marketing services to process the current statistical data. To do so, use the following SQL query to remove the entry from the DMACTATTR table that records that the data has already been processed. As a result, the best-seller or top-browsed list will be generated the next time the SendMarketingTriggers scheduled job runs:

DELETE FROM DMACTATTR WHERE DMACTIVITY_ID = 0 OR DMACTIVITY_ID =

(SELECT DMACTIVITY_ID FROM DMACTIVITY WHERE NAME = ‘activity_name’);

Where activity_name is the name of the activity you are testing.

Using the Administration Console, either run the SendMarketingTriggers job manually or wait for the next time the job runs according to its schedule interval setting. By default, this job runs every 30 minutes.

Verification

Storefront example of a best-seller list

About The Author

Leave a Reply

*