Web Analytics Product Comparisions:

Product Comparision between the industries leading web analytic products

Reference : http://web-analytics-review.toptenreviews.com/

Creating a new store with desired store id in Websphere Commerce

The store_id for the new store is pulled from the KEYS.COUNTER column. You need to edit the COUNTER column value corresponding to the column tablename='storeent' in KEYS table like below,

The new store_id is generated by value of "KEYS. COUNTER (column value) +1". To get a desired store_id, you can increase or decrease the present COUNTER column value from KEYS table as long as "COUNTER (column value) +1" value is not used in the STOREENT.STOREENT_ID column.

Important Note:
1. If you try to decrease the KEY.COUNTER column value to get a desired store_id, whenever you restart the server then KEY.COUNTER column value is increased by KEY.PREFETCHSIZE column value. So after restarting the server, if the new COUNTER (column value) +1 matches the STOREENT.STOREENT_ID then it will throw an error when you try create a new store.
2. Remember to backup the tables before doing an update.

Reference : http://www-01.ibm.com/support/docview.wss?uid=swg21626815

Integration of Websphere Commerce with MQ

 Following link provides the detailed steps for WCS Integration with Websphere MQ

http://www.websphereusergroup.org/webspherecommerceguru/blog/2012/03/07/integration_of_wcs_commerce_with_mq

Creating Websphere Commerce e-Spot using SQL's

Sometimes as a part of project requirement you might need to create espots for your eComemrce website. Instead of creating them through Management Center it is easy to create through SQL's.

Recently found a nice article which explains the different tables used as a part of eSpot creation. Following is the URL for creating eSpots using SQL's

http://www.daharveyjr.com/creating-a-websphere-commerce-e-marketing-spot-wsql-text-content/

Displaying Numeric Keypad only on mobiles for Numeric Inputs on Forms

In order to display Numeric Keypad only on mobiles/tablets create the <input> types as "number" or "tel" for telephone numbers as shown below

<input type="tel" name="mobilenumber"/>

<input type="number" name="age"/>

or

<input type="text" pattern="[0-9]*" /> (Works only for iOS)