SOlr configuration steps

SOlr configuration steps

The Following Steps should be followed to configure (Commands are case-sensitive)

1 Stop the server 

2 Go To Db2Console/CMD Prompt then click on the database and search for the store table and check the STORE_ID (DEFAULT IS 10001)

3 Then go to DB2CMD or CMD

4 Go to path "C:\IBM\WCDE_ENT70\components\foundation\subcomponents\search\bin"

5 And Run the following command(Without Quotes)

 "setupSearchIndex.bat -masterCatalogId 10001"

6 10001 is the STORE_ID

7 Start the Server now

8 Now again go to the path "C:\IBM\WCDE_ENT70\bin"

9 Execute the command (Without Quotes)

"di-preprocess.bat c:\IBM\WCDE_ENT70\search\pre-

processConfig\MC_10001\DB2"

10 Execute the command (Without Quotes)

"di-buildindex.bat -masterCatalogId 10001"

Note:

The exit code should be '0' for both the Commands or Batch processes... 

If the Exit code is '3' then Re-Run the command with the parameter "-force true" which means run this forcebily even if there is any other scheduled Preprocess/buildindex is running. Refer the below links for more information.

Reference Links:
Preprocessing:
http://www.ibm.com/support/knowledgecenter/SSZLC2_8.0.0/com.ibm.commerce.search.doc/tasks/tsdsearchbuildpre.htm

BuildIndex:
http://www.ibm.com/support/knowledgecenter/en/SSZLC2_8.0.0/com.ibm.commerce.search.doc/tasks/tsdsearchbuildindex.htm

Cheers!!!! You have completed the Preprocessing and Reindexing.

Sharing is Caring!!!!

WCS IBM Issue Fix: PricePending Issue even after the Di-preprocess and Di-build Index

If facing any Price Pending issue in the store front its normally because of the Di-preprocess and Di-buildIndex, But if its same even after performing the Di-preprocess and Di-buildIndex then it seems to be the issue because your currency is not being mentioned in the XML's and its taking the default/OOB currencies and your currency is not mentioned in the XML's.

Steps to fix this:
1. First select a currency that you feel you are not going to use it in the future for this project and search for it in the below mentioned three files and replace it with the currency you want to use.
2. Navigate to the below location>Open below files in any Text editor like Notepad++

• For Solr:

          C:\IBM\WCDE80\search\solr\home\MC_10001\en_US\CatalogEntry\conf\wc-data-config.xml

• For pre-processConfig:

          C:\IBM\WCDE80\search\pre-processConfig\MC_10001\DB2\wc-dataimport-preprocess-listprice.xml
          C:\IBM\WCDE80\search\pre-processConfig\MC_10001\DB2\wc-dataimport-preprocess-offerprice.xml

Eg:
    ILS is Israel Currency and i'm not going to use it in the future and i Need AUD currency which is Australian Dollar. 

3. Search for the Text "ILS" and Replace all of its OCCURANCES with "AUD"
Repeat the step for all the Three above mentioned Files and make sure you save Them.

4. Then Perform Di-Preprocess and Di-Build Index or Click here to Refer the Blog

 Cheers!!!! You have Done and It should work if the Issue is related to Currency...

Sharing is Caring!!!!

Script to Reset the wcsadmin password in WCS IBM

To Reset the wcsadmin password in WCS IBM follow the below steps:

Step-1
Open the Db2 console center or any other db2 client to run sql's and go to query editor.

Step-2
Copy and paste the below queries one by one or together and execute them.

update userreg set logonpassword = x'74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020' where logonid='wcsadmin';

update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin';

update userreg set status = 1 where logonid='wcsadmin';

update userreg set passwordexpired = 0 where logonid='wcsadmin';

Step-3 

The above scripts reset's the password of the wcsadmin user to "wcsadmin"

Navigate to the store in the browser and login to the site using the user name "wcsadmin" and password "wcsadmin".

After successful login change the password as required.

Sharing is Caring!!!!

Database Backup Steps and commands for IBM WCS

Steps:

• Go to Start and type "run" and open.
• In the Run console type "db2cmd" and the window will open.

Execute the below commands in the given order.

• CONNECT TO DBNAME user USERNAME using PASSWORD
• QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
• CONNECT RESET
• DEACTIVATE DATABASE DBNAME
• BACKUP DATABASE DBNAME TO "C:\CASE STUDY DB BACKUP" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS  WITHOUT PROMPTING
• ACTIVATE DATABASE DBNAME
• CONNECT TO DBNAME
• UNQUIESCE DATABASE
• CONNECT RESET

Note: 

         -Replace the word DBNAME with the name of your Database.
         -USERNAME is databse admin name and PASSWORD is Databse admin password.

         -Example commands are given below.

         -For each command the "db2" should be pre-fixed before executing as given below.

Example of script:

db2 CONNECT TO AURORADB user db2admin using passme!23

db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS

db2 CONNECT RESET

db2 DEACTIVATE DATABASE AURORADB

db2 BACKUP DATABASE AURORADB TO "C:\CASE STUDY DB BACKUP" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS  WITHOUT PROMPTING

db2 ACTIVATE DATABASE AURORADB

db2 CONNECT TO AURORADB

db2 UNQUIESCE DATABASE

db2 CONNECT RESET

In the above the AURORADB is the Database name used, db2admin is database admin name and passme!23 is the password for the admin.

Please try and any doubts or queries comment down..

Sharing is Caring!!!!

Adding/Importing the SSL or Signer certificates in IBM WCS

     To Add a Signer certificate.

1.  Open Server Admin console from RAD.
2.  Navigate to Secutity and Expand it.
3.  Then click on  SSL certificate and key management.
4.  in the console check on Right Side for more options and click on Key stores and certificates
5.  In that there should be a lot of NODES select for NodeDefaultTrustStore  click on it.
6.  on the right side check for Additional Properties and in that click on the Signer certificates.
7.  The Navigated Path should look like this "SSL certificate and key management > Key stores and certificates > NodeDefaultTrustStore > Signer certificates"
8.  Next to add and delete button find the retrieve from port button
9.  now gotta fill the mandatory fields  like Host, Port and Alias.
10.  Host can be for eg "developer.authorize.net" and port try 443 and Alias give any meaning ful name to recognise it. 
11. Then click on Retrieve Signer Information and wait for the certificate import.
12. Then apply and save it with out fail.
13. Restart the server and test.

Important Note:

If you get the error as "ErrorReceived fatal alert: handshake_failure" while adding the certificate follow below steps as a Fix.

1. Navigate to SSL certificate and key management.
2. In the Related Items and click on SSL Configurations.
3. Then click on NodeDefaultSSLSettings.
4. Find the Additional Properties and click on Quality of protection (QoP) settings.
5. Here by Default SSL_TLS might be selected.
6. Change it to  TLSv1.2 or SSL_TLSv2.
7. It will solve the issue.

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