Fraska Portal

Exploring the WebSphere Commerce world

Subscribe to this list via RSS Blog posts tagged in Web Activity
WebSphere Commerce, Playing around with the coupon promotion data model

Let' s analyze a specific requirement: create a coupon promotion and assign it without using CMC and web/dialog activity but just querying the DB

This requirement could sounds a bit odd alone but if you think it in terms of promotions integration taking the data from an external 3rd party system it can start to make a bit of sense. 

The CMC authoring promotion tables and the Promotion XML

To accomplish our task, first of all, we need to understand exactly the tables involved during the creation of a coupon promotion. Starting from Info Center documentation we can find the following diagram reviews the main promotions data and their interactions within the promotion use:

b2ap3_thumbnail_promotions_tables.png

 

Basically, there are two main parts: the management center tables and the runtime tables.

The authoring promotions tables (PX_PROMOAUTH, PX_DESCRIPTION, ...) is a set of tables contains data useful to handle the created promotions in the management center console; in this way the business users can view, edit and delete the promotions as they prefer in a simple and fast way with the Promotion Tool.

However, the runtime engine of the store, uses just the promotion XML to evaluate if a promotion is applicable or not for an order. As you can already imagine, the promotion XML- contained in the field PX_PROMOTION.XMLPARAM- is the XML description of the promotion created in Management Center. So, the same information is stored in the MCM promotions tables and in PX_PROMOTION like an XML document. 

WebSphere Commerce, Recommend products on search landing page

This article is focused on explain how to implement a personalized recommendation based on search keyword using the E-marketing Spot Title provided with FEP6.

In particular, the use case is the following:

  • recommend the products "Widescreen LCD monitor" and "Office chair" 
  • with an image and the text "Don't forget the importance of the ergonomics! Improve your workspace with our ergonomics products"
  • when the customer search the keyword "Laptop"

The result is the following:

 WebSphere Commerce Marketing e-spot title search landing page

Let's review the steps to get the above requirement ...

Most Popular Post

WebSphere Commerce, the SOLR extension index
Administration
Rate this blog entry:
4
WebSphere Commerce, Data Load and SOLR Delta Index
Data Load
Rate this blog entry:
0
WebSphere Commerce, FEP 7, SOLR index pre-process error
Administration
Rate this blog entry:
0

Latest Blogs

WebSphere Commerce, CommandLevelAuthorizationCache
Cache
Rate this blog entry:
0
WebSphere Commerce v8, toolkit exception, ClassNotFound db2
Administration
Rate this blog entry:
1
WebSphere Commerce, ATP migration
Store
Rate this blog entry:
0
WebSphere Commerce, the curious life of a front-end catalog request
Core
Rate this blog entry:
5
WebSphere Commerce, Performance analysis of few European stores
Performance
Rate this blog entry:
0