WCS Inteview Questions

What is the controler command explain it?
What is the difference between ATP and NON-ATP?
How can we make or specify that we are going to use ATP or NON-ATP?
Difference between controller command and task command?
Steps to create controller command?
Steps to create task command?
How retrive data in JSP?
Dfferences between the Smart databean and Command databean?
What do you mean by Lazy fetch?
What are the TAG Libraries used in the JSP?
Explain EJB creation?
What is the use and why do we use AccessBeans?
How to use AccessBeans to insert and retrieve data?
What is the use of finder methods in the AccessBeans?
What is the use of RefreshCopyHelper()?
What is the use of CommitCopyHelper()?
-----*-----*-----*------*----*----*----*----*----*----*----*----*----*-----*-----*-----*-----*----*-----*----

What are the Order Status and when do then get changed?
When and which command changes the order status from "S" to "D"?
How to configure Promotions?

What are the fields in the ORDER table?
Ans: Order_Id, OrderItems_Id, Member_Id, Address_Id etc

How to get Address information from ORDER table?
Ans: Using Address_id in the Orders Table we can get the corresponding Row in the ADDRESS table.

List out the tables in the Catalog Subsystem?
Ans: CATENTRY, CATENTREL, CATENTATTR, ATTR, ATTRVAL, ATTRVALDESC etc

Which table holds the Relation between the parent and child catentry?
Ans: CATENTREL
How to check exceptions in the production environment and debug them?
Ans: By Enabling the trace logs
Where Do we create products?
Ans: Accelerator and Management Center

-----*-----*-----*------*----*----*----*----*----*----*----*----*----*-----*-----*-----*-----*----*-----*----
Can we invoke the Task command from URL if give the struct entry?
what are the diffrent type of promotion?
what are all the methods there for AccessBean?
Explain the OOB Order Flow?


More Questions...

General

• JSTL tags and its details?
• How to configure JMS in wcs?
• How to develop webservice in wcs?
• Explain the access control policy?What is the purpose of access control policy?
• How to publish the store?what you mean by starter store?
• How to setup payment ,tables,payment policy,payment types ?
• Explain the Dynacache?
• How to enable single sign on?
• How to enable cross site scripting?
• How to do fitgap analysis in WCS?
• What the EJB transaction parameters?
• which are different types of entity beans n which one is used in commerce?
• Which are the different types of databeans. What is commonly used in commerce.when do we use it?
• which are the different flavours of EJB in wcs ?
• What are acessbeans? What is the advantage of accessbean?
• How to read the object status from the Remote Java VM?
• Steps of insert and read data into commerce tables?
• State one diff between 6.0 and 7.0 commerce version?
• what is optimistic locking?
• Which are the different subsystems in commerce?
• What are the different tools available in commerce?
• How to schedule job in the commerce ,tables ?
• Which are the different databases which commerce supports?
• Which is default database in commerce?
• Explain Control command and task command in wcs ?
• What is the use of KEYS table in wcs ?
• What is the use of CMDREG table in wcs ?
• How to instatiate a databean -2 ways?
• What is a command context.?
• List different types of command context ?
• How do you instantiate a task command ?
• Can we instantiate controller command from another controller command ?
• How do you pass data from controller command to task command?
• Name five methods available in a Controller command?
• What is validateParameters() used for?
• What is the purpose of isRetriable() method in a controller command?
• what is the first method executed when a controller command is invoked?
• What is the method called when a databean is invoked?
• what is the use of optCounter field?
• List all tag libraries used in a JSP?
• Why is struts-config entry required while creating a JSP or a command?
• What is the use of commitCopyHelper() and refreshCopyHelper()?
• What does map.mapxmi file contain?
• what does stores project contain?
• While creating a new View, what are the entries made in struts-config xml?
• What is format tag used for?
• what is a locale?
• What does SAR file mean?
• What is the default store for b2c?
• What are the different editions of WCS?
• List the different business models of wcs ?
• Which are different types of Exceptions used in commerce?
• Whats the difference between system Exception and Application Exception?
• Which exception is retriable?
• How can we make a command retriable?
• Which the main Exception class used in commerce?
• Functional architecture and Runtime architecture of WCS 6.0/WCS 7.0.

Member subsystem

• Organization hirarchy?
• Different tables used for user registraton?
• Releationship between the user and organization?
• How to create roles ?
• How to create users?
• How to create organization?
• What are the different typs of user types?
• What are the different types of member groups

Merchandizing

• How to setup promotion- explain the tables used for promotion ?
• How to create campagin activity?
• What are the diffent activity in marketing campaign?

Order Subsystem

• Explain the differnt order status?
• Difference between the order item and orders and tables ?
• Different types of promotions and details with tables?
• Explain the Calculation frame work with example and tables?

Accelerator

• Explain the Acceleretor framework?
• Explain in detal any customisations or development done in acceleretor using Notebook, Wizard, Dialogs?
• Best practices for customizing accelretor?

Adminstration

• How to setup the email?
• What is the use of transport option in administration console?

Contracts

• How to create contract?
• How to setup the Catalog filter and explain with tables?

Catalog

• Difference between mastercatalog and sales catalog?
• How to setup different category - tables and commands?
• Explain the SKU,partnumber with catalog tables?
• What is dictionary?
• Which tool is used for catalog management ?
• what is the difference between product and item?

wcs7.0

• About wcf

Sharing is caring... Share it with the one's who need it..

CLICKABLE CATEGORY SPECIFIC PROMOTION IMAGE AD IN PLP IBM WCS

There are Six Major activities Need to perform the Above Task as mentioned below.

Make the DEFAULTCATEGORYPAGELAYOUT as NOT default for CATEGORIES DISPLAY

Steps:

·         Go to Database open the table "PAGELAYOUT"

·         Filter the row for "DEFAULTCATEGORYPAGELAYOUT" and make its corresponding column IsDefault=”0”

(OR)

·         Run the below Query in DB.

update PAGELAYOUT set ISDEFAULT='0' where NAME=’ DefaultCategoryPageLayout’  and PAGELAYOUTTYPE_ID=' Category'

Steps to configure Category Ad promotions

Steps:

·         Logon to Management center and open Commerce Composer.

·         Open the Default category Page Layout

·         Move to Design Layout Tab.

·         In the design Expand the 4th Slot Named "Promotion Ad Widget" which is dedicated for Category Promotion Banners.

·         Change the Espot Type to "Page Specific EMSpot"

·         Give the Espot Suffix (this suffix we will be using in the further steps so make a note of this)

Eg: CategoryAd

·         Save the Layout.

Creating the Espot for particular Category

Here we will be creating ESPOT.

Note: for Each Category we have to create a Espot with the Above Given Suffix (Eg:categoryAd).

Steps:

·         Create a Espot then find the name of the Catalog pages names for the category to which you are creating this Espot (to find this go to Commerce composer and click on the StoreCAS folder and you will get the list of catalog pages, From  there retrieve the Page Name for respective category)

·         Use the Page Name in the Espot Name and add the Suffix without spaces

Syntax

CategoryPageName+Suffix

Eg: PantsCategoryAd

IMPT NOTE: No need to give default title content and default content

Creating the Content for particular Category

Steps:

·         Give any name to Content

·         Select the Content Type of Select box to be "Text For Store page display"

·         In the Text field add the Image URL.

Eg:

<img src="/wcsstore/BOSTESStorefrontAssetStore/images/promo1.png">

<img src="/wcsstore/BOSTESStorefrontAssetStore/images/promo2.png">

·         Number of click actions : "Single".

·         Click action type: "Predefined click action for a Promotion"

·         Content Behavior : "Static"

Creating a Web Activity for Promotion recommendations

Steps:

·         Create a Webactivity as "Promotion Recomendation" as the Template.

·         Select all other required fields and give value as requirement.

·         Now add Espot Name where the content shld be displayed.

·         Add the Promotion which is to be displayed and add the content that is to be displayed in the ESPOT.

·         Refer the below Web Activity Images

Eg:

Web-Activity-1

Web-Activity-2

Make the DEFAULTCATEGORYPAGELAYOUT as default for CATEGORIES DISPLAY .

Steps:

·         Go to Database open the table "PAGELAYOUT"

·         Filter the row for "DEFAULTCATEGORYPAGELAYOUT" and make its corresponding column IsDefault=”1”

(OR)

·         Run the below Query in DB.

update PAGELAYOUT set ISDEFAULT='1' where NAME=’ DefaultCategoryPageLayout’  and PAGELAYOUTTYPE_ID=' Category'

Download it as a Document from Below Link:

https://drive.google.com/open?id=0Bylj2QumWJdVY2wxTnM5Zk9xbUk

Creating Bundles and Kits in IBM WCS

Steps for creating Bundles:

1. Go to CMC : https://DomainName:8000/lobtools/cmc/ManagementCenter

2. Navigate to Management center tools > Catalogs
3. Select the Store Name in which you want to create the Bundle.
4. From the explorer filter, select Master Catalog.
5. To add a Bundle,

• Click File > New > Bundle
• Click the Manage bundle tab. The Bundle Properties view displays.

6. Fill the Mandatory fields like Code, Name, Short description, Long description, Keyword, and Parent Category.
7. Navigate to Components tab.
Click on Text field and search for Catalog id's > Find and Add.
8. Save the Bundle.

Steps for creating Kit:

1. Go to CMC : https://DomainName:8000/lobtools/cmc/ManagementCenter
2. Navigate to Management center tools > Catalogs
3. Select the Store Name in which you want to create the Bundle.
4. From the explorer filter, select Master Catalog.
5. To add a Kit,

• Click File > New > Kit
• Click the Manage Kit tab. The Kit Properties view displays.
• Select Kit type to Kit.

6. Fill the Mandatory fields like Code, Name, Short description, Long description, Keyword, Parent Category and price information (List and offer Price).
7. Navigate to Components tab.
Click on Text field and search for Catalog id's > Find and Add.
8. Save the Kit.

Note: Bundles are displayed along with products in the PLP page under the created category and Kits are displayed in the PDP Page.

Note: Preprocess and Di-build Index should be done After creating to see the bundles or kits in the storefront.

Sources and References:

Infocenter Links:

Creating Bundles in Accelerator

Creating Bundles in CMC

Disabling/ Removing the “Other customers also purchased” in PDP page.

The default page layouts are used by default.

So follow the below steps carefully.

1.    Go to Database and search ”PAGELAYOUT” Table in that check for the corresponding column values NAME=DefaultProductPageLayout and PAGELAYOUT_ID=Product then its IsDefault should be made “0“ and commit.

2.       Now Go to CMC/Management center, Login then navigate to management center tools->Commerce composer.

3.       Go to “LAYOUTS” folder and double click.

4.       Find the Layout with Name as “DefaultProductPageLayout” then Navigate to its Design Layout settings.

5.       Then in the Layout find the corresponding “slot” That is two things should be noted as below

·         Title Number

·         Tab Number

Both title and tabs corresponding to the “Other customers also purchased” should be removed/Deleted from the Layout.

Steps To delete:

v  select the slots from “Layout slots and widgets”
v  Click on the    (Delete Icon).

6.       Now Save Your changes in Management center.

7.       Go to Database and search ”PAGELAYOUT” Table in that check for the corresponding column values NAME=DefaultProductPageLayout and PAGELAYOUT_ID=Product then its IsDefault should be made “1“ and commit.

8.       Test Your Changes in the Store Front.

Steps to remove Select Stores in PDP, Pick Up At stores in checkout page and Remove Store locator from Header

•            Go to Management Center and login.

•            Navigate to Marketing center tools -> Store Management.

•            Double click on “Stores” Folder and select the store to which you want to disable the feature.

•            In the corresponding store Settings Navigate to “Configurations” and uncheck “Store Locator Option” which will automatically change the buy online and pick up at store option.

•            The above change will also Remove “Store locator” from Header.

•            Save the changes and check for the changes in the store front.

WCS SOLr SERVER CONFIGURATION STEPS.

Pre-Requisites

Initially before configuring the Solr server we need to publish a store so that a store ID gets generated. To publish the store follow the following steps.

1 Open IBM => Web Commerce => Web Sphere enterprise

2 Project clean and build

3 Start the server

4 Go to C:\IBM\WCDE_ENT70 and open the file "hintsandtips.html"

5 Go and click on the "IBM Web Sphere Commerce Administration Console"

6 the Default User name: "wcsadmin" and password: "wcsadmin".

7 Change the password when asked

8 Then go to store Archives-Click and check publish status 
-NO STORES WILL BE PUBLISHED-

9 Go to Store Archives  Then Click on publish and publish a  aurora.sar  store as a Non-ATP (Not 

available to promise) inventory.

10 Then wait for the store publish to complete.

IBM WCS - Disabling/Enabling the product compare feature from PLP page.

Follow the Below Steps:

1. In Database, Search for "PAGELAYOUT" Table.Check for the Name="DefaultCategoryPageLayout" and confirm its "PAGELAYOUTTYPE_ID"="Category".
2. Note down it's corresponding "PAGELAYOUT_ID" eg: PAGELAYOUT_ID=10052 (in My case).
3. Then navigate to the "PLWIDGET" table in the Database.
4. Filter the rows with the "PAGELAYOUT_ID"(Noted in the Above step-2).In that navigate to the corresponding column "ADMINNAME" with value "CatalogEntryListWidget" and note its "PLWIDGET_ID" Eg: PLWIDGET_ID=1110 (In my case).
5. In Database now navigate to "PLWIDGETNVP" table and filter the rows with the "PLWIDGET_ID" fetched in the above step-4.
6. Now navigate to the row with value "NAME=disableProductCompare".
7. The corresponding Value column will have "false" by Default(which means the compare feature is enabled).
8. Now Make it "True" to Disable and "False" to Enable.

Note: The compare option will still be available in the search results page, To disable it repeat the same steps as above for the "Name=DefaultSearchResultLayout"  in the PAGELAYOUT table.

Note:- Finally To Test don't forget to do registry Update in the Admin console.