WCS 7 - product overview study notes

Features and benefits in WCS 7.0
 

Express –Professional –Enterprise

• Madison starter store
• Madison mobile starter store
• Brazil starter store
• MayUJoy starter store
• Remote widgets
• Coshopping
• Subscription support
• Product Ranking
• Digital wallet
• Social Commerce
• Social Bridging
• Websphere commerce search
• IBM gift center
• Punch-out payment
• Payment plug-in, Payment rule engine, payment plug-in controller
• Globalization and Localization support
• Marketing + Coremetrics supports
• Promotions
• Distributed Order Management Integration(DOM)
• Administration tool
• Coremetrics integration supports
• Websphere commerce Accelerator
• IBM Management Center-Catalogs, promotions, marketing activity, assets and managing  store

Professional –Enterprise

• Cross channel order processing
• Sales Center
• Workspaces
• Auctions

Enterprise

• B2B direct start store/Indirect starter store
• Elite starter store
• Extended site starter store
• Demand chain business model
• Supply chain business model
• Contracts and Entitlement
• Pricing
• Request for quote
• Enhanced Websphere Commerce search
• IBM Management Center –catalog filter ,price rules, price list

Fix pack and Feature pack list

• Fix pack 1

a)     Supports Feature pack 1

b)     Support IE8 for all starter stores

c)     Supports DB2 version 9.7

d)     Support for 64-bit WebSphere Application Server

e)     Support for Arabic language in the Madisons starter store

f)       Enhance WebSphere Commerce Accelerator Tax notebook to show start and end dates for tax rules

g)     Enhance returns capability to support non-ATP inventory

• Fix pack 2

a)     Supports Feature pack 2

b)     Support for 32-bit AIX 7.1

c)     Support for Windows 7 on WebSphere Commerce 7.0 Developer Edition

d)     Support for Oracle 11gR2

• Feature pack 1

WCS Editions

• Websphere Commerce Express
• Websphere Commerce Professional
• Websphere Commerce Enterprise
• Websphere Commerce Developer Express
• Websphere Commerce Developer Professional
• Websphere Commerce Developer Enterprise
• Sales Center for Websphere Commerce
• Gift Center for Websphere Commerce

Platform Details

• Hardware

a)     Intel 32 bit,64 bit for Windows , Linux

b)     Intel X86, X86/64 –windows ,Linux

c)     SPARC – Solaris only

d)     Z series – Linux only

e)     POWER® – AIX® and Linux

• Operating System

a)     Dropped –Windows 2000,Linux RHEL 3,Solaris 9

b)     Added –winserver 2008,win visa ,Linux SUSE 11

• Browser

a)     Dropped –Opera ,IE 5,Netscape ,Mozilla ,FF 1 and 2

b)     Added – IE8

• WAS server

a)     Websphere application sever 7

b)     Rational application developer 7.5

• Database

a)     DB2 9.5         jdbcdriver db2jcc4.jar

b)     Oracle 11g     jdbcdriver ojdbc6.jar

• Other Supports

a)     IBM Support assistant v4.1

b)     Websphere portal server 6.1

c)     Websphere MQ 7.0

New Features in WCS7.0

• Multi-channel precision marketing

a)     Automated marketing based on an individual consumer’s preferences and shopping intentions

b)     Desktop Browser To Trigged Event To Marketing engine Rules To Marketing message To Desktop Browser (same for all touch points)

c)     In other words the consumer’s experience is extended with triggers, or events, that can originate from any touch point, such as a desktop browser, mobile device, or a kiosk. The triggers are processed by a rules based marketing engine which produces targeted marketing messages. These messages are routed to the same touch points which originated the trigger.

d)     IBM Management Center => Marketing tool => Activity Builder

e)     Dynamic add/delete of customers from customer segments

f)       Enhanced promotions tool usability

g)     New promotion features

• Mobile Commerce

a)     Mobile Commerce is a method to enable mobile devices to participate in the shopping experience.

b)     A generic user interface optimized for mobile device interfaces is implemented with easily deployed page templates for these pages:

c)     Product information, order status, physical store locator, wish list, shopping list, and mobile message opt-in.

d)     Mobile messages can be sent to inform you of marketing information or for current order status.

e)     Mobile enabled pages integrate with Multi-channel Precision Marketing to provide a set of mobile enabled triggers.

• Social commerce

a)     Social commerce uses Web social networking concepts to allow customers to market your products for you.

b)     The social networking concepts that have been implemented are

a.      product reviews and ratings

b.      product blogs at the category level

c.      user profiles viewable by others

d.      Photo galleries at the product category level.

c)     These social networking concepts involve data stored by external products and services.

d)     The integration of these products and services are accomplished with WebSphere sMash technology.

e)     Bazaarvoice is a third party service provider that provides a service for hosting ratings and reviews.

f)       Pluck is a third party service provider that provides a service for hosting blogs, profiles, and galleries.

g)     IBM Lotus Connections is a product that also provides hosting for blogs, profiles, and galleries.

a)     The high efficiency data loading utility is provided for loading catalog, pricing, and inventory data for initial installation of a store implementation.

b)     It can also be used to update this data. Compared to the mass loader in V6, the data load utility is easier to implement the input data specifications, and provides improved performance and scalability for large amounts of data.

c)     The key improvement in the data loader design is that it supports data loading by business objects and data loading by database tables.

d)     This design also allows the utility to have better reliability and data consistency in the result of a load failure.

• Starter store enabled by web 2.0

a)     The starter stores have been enhanced by adopting Web 2.0 technology at more current support levels. The starter stores have the ability to selectively enable Web 2.0 style shopping paths by using the Accelerator change flow function.

b)     The functional improvements are improved page layout and styling, more complete use of Web service tags, updated Ajax framework, and Dojo libraries updated to Dojo 1.3.1.

c)     Both the business-to-consumer and the business-to-business starter store business models adopt the Web 2.0 technology.

d)     Madison’s business-to-consumer starter store has the same functionality as Madisons in V6, feature pack 5. The Elite business-to-business starter store is new in V7.

• Elite Business to business starter store

a)     The Elite business-to-business starter store has support for streamlined checkout, contract based pricing, buyer organizations, order scheduling and splitting, back ordering, save orders, and organizational participants.

b)     The Elite starter store also is integrated with Multichannel Precision Marketing using triggers, targets and actions.

• Management Center enhancement

a)     The Management Center has been enhanced with more operations formerly done only in Accelerator. You can now create customer segments, create e-marketing spots, and change your password at login.

b)     General usability and efficiency has been improved with case-insensitive search, keyboard shortcuts, text edit undo and redo, and direct editing of list columns.

• Migration assistant utility

a)     A set of migration utilities assist migrating older WebSphere Commerce versions to V7 using a graphical wizard on top of an Apache Ant script framework.

b)     You can migrate from V5.6.1 or from V6.0 with any feature pack enabled. You can also accommodate upgrading to a higher edition of the product.

c)     The Ant scripts handle migrating your database, applications and Web server configurations.

Changed Functionality

• Madison starter store replaces Consumer direct
• Apache Derby replaces Cloudscape database support
• DB2 loop-back configuration has been removed on Unix platforms
• Oracle database character set has been changed from UTF8 to AL32UTF8
• Order trash can feature disabled by default

Deprecated and Discontinue Functionality

Deprecated Feature	New Feature
Accelerator.Change Flow	Management center.Store management tool
Accelerator.Manage Files	Management center.Asset tool
Accelerator.Change Page	Management center.e-Marketing spot
Accelerator.Banner	Management center.e-Marketing spot
Accelerator.Upload Logo	Management center.e-Marketing spot
Accelerator.Catalog tool	Management center.Catalog tool
Accelerator.Prmotion tool	Management center.Promotion tool
Accelerator.Marketing tool	Management center.Marketing tool
Accelerator.Price tool	Management center.catalogfilter,Pricing tool
Accelerator.Extended sites catalog filter	Management center.catalog filter,Pricing tool
Accelerator.B2B contract catalog filter	Management center.catalog filter,Pricing tool
Accelerator.Marketing engine	Management center.marketing engine
Configuration Noun	Online store noun
Accelerator.content spot	Management Center.e-Spots
OMS/ERP integration	DOM integration
WCS payments	Payment subsystem and appropriate plug-in
Product Advisor	Websphere commerce search
PriceTCMasterCatalogWithOptionalAdjustment	PriceTCMasterCatalogWithFiltering
Discontinue Feature	New Feature
WCS Analyzer	Coremetrics ,Omniature –see details
IBM Lotus quick place	See details
Staging check utility	Stagegroup – see details

• Data Loading utility

How to create a user in wcs ?

There are several ways to create a user in wcs.

1. UserSyncBean myBean= new UserSyncBean( myuserProps ); is one of the way to create user and by adding values to USERS,USERREG,USERDEMO,ADDRESS,BUSPROF,USERPROFIL and MEMBER tables

2. UserRegistrationAddCmdImpl

3. comming soon ....

How to disable password invalidation in websphere commerce ?

update the wc-server.xml..

String strPasswordInvalidationSetting = WcsApp.configProperties.getValue("PasswordInvalidation/enabled", "false");


Regards
Bipin

Websphere commerce server taking long time to start

-Please check the following stuff..
1)ComponentManager initComponent CMN0009S: Component Scheduler is enabled.
CNTR0098I: Container-managed pre-find persistent store synchronization disabled for bean: "WC#Enablement-BaseComponentsData.jar#SchedulerStatus".

Check the time to complete above code. - it could be your SCHSTATUS table with lot of data.

How to setup Content spot , e marketing spot

key words - content spot, e-marketing spot, bipinkumar@gmail.com

1. Create an content in Accelerator-Marketing -Contents.
while creating conent in text use value place holder eg : {name}.
Thios value will pass from the JSP at runtime
2. Create an EMarketing spot in Accelerator-Marketing -Contents.
3. Decide your webpage locattion to display the content
4. Open and check the ContentSpotDisplay.jsp
5. Copy paste below code to your jsp ..

< c:import url="../Snippets/Marketing/Content/ContentSpotDisplay.jsp">
< c: param name="spotName" value="mycontent1" />
< c:param name="substitutionValues" value="{spotname},${spotName}"/>
< c:param name="substitutionValues" value="{myname},${name}"/>
< c:param name="substitutionValues" value="{myid},${id}"/>
< c:param name="substitutionValues" value="{mycomment},${comment}"/>

< / c:import>

-You can repeat above steps for displaying multiple content spots
-Alignment issue can be resolved in ContentSpotDisplay.jsp

what is eSpots?: eSpots reserve space on your store pages in which content displays

2 types of eSpots-e-Marketing Spots(for marketing activity) & Content Spots(only for display- no marking )

what is the different between E-Marketing Spot ,Content Spot and Content ?
Here is the hirarchy
E-Marketing Spot contains -->Content
Content Spot contains ->Content

Content
-File
-text
-place holder{name} -- this will be pass from the jsp
-no start date and end date

Content Spot
-atleast one content is mandatory -
-can be scheduled with start/end date
-call the content spot name in jsp to display the attached content


E-Marketing Spot
Add emaiil activity ( send promotional mails for selected group in
specified time(capture all userinput from the mails )

Add web activity(start,end date,priority,status) - also add
-Campaign
-days to display
-activation types
-promotion
-product recommendation
-Category recommendation
-Advertisement(only contents - NO CONTENT SPOT here )
-upsell
-cross sell
-Target customers
-customer segments
-Target customer behaviors

-TABLE --
DMEMSPOTCMD FP
DMEMSPOTDEF FP
DMEMSPOTPAGE FP
INTVSCHED
SHDCACRM
schconfig
campaign
shdcacrm
esmapobj
esmaptyp

for calling e-marketing spot use below jsp
< c : import url="${jspStoreDir}include/eMarketingSpotDisplay.jsp">


< / c:import>

All about Webspere commerce promotions

  Promotion Tables

• CLCDPROMO
• PX_PROMOTION
• CALCDOE
• CATENCALCD

  How to stop promotions?

• Stop promotion in table level. PX_PROMOTION/CALCODE
• Stop promotion in instance level -wc-server.xml
• RLPromotionComponentConfiguration -false
• RulesBasedDiscount-false
• component enabled="false" name="RulesBasedDiscount
• Clean the promotion registry
• Stop promotions from your customized commands /jsp

  

Search key words.
promotion promotions . XMLPARAM , PX_PROMOTION,
customize ,CategoryLevel, ProductLevel, mix and , Buy x , Get x free ,Mix and match and all promotion with calcode , create /edit calcode

How to create a promotion ?
--Comming soon

How to customize the promotions
--Comming soon

More about Promotion Engine ?

--Comming soon

Note : Pls Put your comments..

Things should know about - Scheduler in WCS

--Main tables..
select count(*) from SCHCONFIG;
select count(*) from SCHACTIVE;
select count(*) from SCHORDERS;
select count(*) from SCHSTATUS;

--Commands---

--General---

Some tips ..
Suppose You have 2 appserver running in clusterd enviroment.Each have 2 JVM .You started one scheduler . Now how we will identify this scheduler is taken care by which Appservers'JVM .. :) ?
Don't worry Bipin have answer : Check the SCSQUEUE for details ..

wcs Server is not staring. ?? workspace crashed?

Don;t worry . A proven solution from Bipin is given below :)

Please try these steps
Right click WC project in RAD
Click Properties menu
Click Server section
Selct the Websphere commerce Test server
Restore defaults
CLose it
Open the WC again
Close the WC project (uncheck both check box)
Allow to rebuld your workspace
REstart it.. :)
enjoy your toolkit

How to clear the activity data

Clear data from CTXDATA. WCS 7.0 + ie 8 may stuck with activity data. Better solution is clear the data from ctxdata and update CTXMGMT status to 'E'

Hope your problem solved.. :) enjoy madi

How to disable Order locking feature in wcs?

Stop order locking/ disable order locking.
stop order lock/locking

Add the following element to the wc-server.xml file between the InstanceProperties> and InstanceProperties> tags.

< orderlockfeature enabled="false" > But this is

But this is not advisable...and only available in the WCS 7.0 not in WCS 6.0
As per my understanding there are 3 locking mechanism available in SOFT lock section
Lock 0- orderlockfeature enabled="false"
Lock 1- orderlockfeature enabled="true"
Lock 2- CSR lock

You can try below code in wcs6.0 this will help u to unlock the SOFT lock in order subsystem
OrderLockingHelper oh = getOrderLockingHelper();
oh.setLockingSystem(0);
This will unlock the order for the curren transaction ..

:) enjoy order with out lock ..

WebSphere Commerce -Member Subsystem

WebSphere Commerce Member Subsystem:
Business logic in the Member subsystem provides member registration and profile management services

Member Subsytem: A top view

User Registration Flow:

User type :

• S(Site administrator ), A(Administrator) ,G(Guest user),R(Registered User)

User Role:

Table:

• USERS,USERREG,USERREPROF,USERDEMO,
• BUSPROF
• MEMBER,MBRATTR,MBRATTRVAL
• MBRREL
• MBRROLE
• MBRGRP,MBRGRPTYPE,MBRGRPMBR,MBRGRPUSG
• ORGENTITY
• ADDRESS

Commands:
UserRegistrationAddCmd

• PreUserRegistrationAddCmd
• Update USERS.REGISTERTYPE='R' from 'G'
• Create new record in USERREG
• Create new records in USERPROF,BUSPROF,USERDEMO
• Create new record in ADDRESS with unique nickname
• AuthenticationPolicyCmd
• ProcessPaymentMemberCmd
• ProcessPolicyTypeCmd
• AuditUserRegistrationCmd
• UserRegistrationRoleAssignCmd
• PostUserRegistrationAddCmd

AddressAdd

• Address type-S, B, SB
• isPrimary -0,1
• Address Status : P(permanent),T(Temporary)
• Unique nickname
• AddressBook

AddressDelete: status = T (from P)
AddressCheck:Check user has atleast one P address
AddressUpdate : Nick name cannot be updated

How to Improve the RAD performance -?

Hi guyes..
Your productivity is so much related to the tools that you are using for your daily works
So keep your tools efficient as you..

Here are the tips..
http://www.ibm.com/developerworks/rational/library/05/517_radtip/

How to redirect from controller command to view ?

responseProperties.put(ECConstants.EC_VIEWTASKNAME, ECConstants.EC_GENERIC_REDIRECTVIEW);
responseProperties.put(ECConstants.EC_REDIRECTURL, "MySearchView");

How to get the http request and Http Response in WCS?

ViewCommandContext viewContext = (ViewCommandContext) getCommandContext();

HttpServletRequest httpRequest = ((HttpControllerRequestObject) viewContext.getRequest()).getHttpRequest();

HttpServletResponse httpResponse = (HttpServletResponse) viewContext.getResponse();

If your RAD not working in Debug mode.. check here

Thanks to Yateesh

Hi Bipin,

1. Navigate to the below dir D:\WCToolkitEE60\wasprofile\config\cells\localhost\nodes\localhost\servers\server1\

2. Edit server.xml

Please make sure you have the below entry in this file - debugArgs.


jvmEntries debugArgs="-Dcom.ibm.ws.classloader.j9enabled=true -Xj9 -Xdebug -Xnoagent -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=7777" debugMode="true" genericJvmArguments="-Xquickstart" hprofArguments="" initialHeapSize="512" maximumHeapSize="1024" runHProf="false" verboseModeClass="false" verboseModeGarbageCollection="false" verboseModeJNI="false" xmi:id="JavaVirtualMachine_1247828987711" >

systemProperties name="com.ibm.wca.logging.configFile" required="true" value="D:/WCTOOL~1/conf/xml/loader/WCALoggerConfig.xml" xmi:id="Property_1247829214602"

systemProperties name="com.ibm.websphere.ejbcontainer.FbpkAlwaysReadOnly" required="true" value="true" xmi:id="Property_1247829214633"

systemProperties name="com.ibm.commerce.dynacache.decrypt" required="true" value="false" xmi:id="Property_1247829214664"

systemProperties name="com.ibm.servlet.file.esi.timeOut" required="true" value="0" xmi:id="Property_1247829214680"

jvmEntries>

Also
Window-Preferences-Run/Debug-Launching-
Select Launch in debug mode when workspace contains breakpoints-Always


Make sure your debugMode=true.. :) enjoy the debugging...

Regards,
Yateesh

What is the difference between Session and Context

Websphere commerce supports both session and context.
In some extend Context is a container. It is used to hold Session , request respose etc
In WCS we have multiple Context. Starting from BaseContext it holding he EntitlementContxt,BusinessContext etc Each is used for carrying specific set of data in the server- Botton line.. Context is widely used by server rather than developer. But that will redirect the business flow

Sesssion : Hope basis every body knows that. Session will sit inside the Context

mm sounds confuced.. sorry this is what i can share n ow ..

Do you know about RunAsId() ? here is the ans

It is to run the request against some other user id.

Ex. You(user Id: 1000) logged into the system .But you want to place an order as if your wife(User Id:1001) is placing an order. In this case, you can set RunAsId to 1001.

com.ibm.commerce.context.base Interface BaseContext.setRunAsId(java.lang.Long nMemberId)
This method sets the run-as user for the request associated with this context

getRunAsId()
This method gets the run-as user for the request associated with this context.

BaseContext baseContext = (BaseContext)getCommandContext().getContext(BaseContext.CONTEXT_NAME);
baseContext.getRunAsId();

Thanks for senthil ..

How to get the MerchantKey in the controller command ?

Object sMkey= com.ibm.commerce.server.WcsApp.configProperties.getValue("Instance/MerchantKey");

System.out.println("My sMkey is "+sMkey);

Best WCS supporting site

http://www.wcsadmin.com

http://www.albeesonline.com/blog/2010/12/02/websphere-commerce-7-order-flow-process-for-elite-b2b-starter-store/

How to get the access log/ client ip address/ which pages client access ?

Make below changes in the wc-server.xml
wc-server.xml location is given below
C:\WCDE_ENT70\workspace\WC\xml\config\wc-server.xml

compClassName="com.ibm.commerce.event.accesslogging.AccessLoggingEventListener"
enable="true" name="AccessLoggingEventListener">















Table names
ACCLOGMAIN and ACCLOGSUB