IBM WCS ACPLOAD Command Execution Steps

Acpload command
To run the access control policies you need to use acpload.bat in  \bin directory with in you WebSphere Commerce Developer installation directory (M:\IBM\WCDE80\bin).

To run acpload if you are using default WCD (Derby DB)

• Open command prompt and go to bin directory 
• Run acpload ACPolicyfilename.xml

To run acpload if you are using DB2 or Oracle

• Open command prompt and go to bin directory 
• Run acpload <your database name> <your Db user name>  <your Db user password>   <ACPolicyfilename.xml >  <DB schema name (normally it will be same as  your database user name)>

acpload.bat WCSDB db2admin db2admin D:\IBM\WCDE80\xml\policies\xml\ACPPolicy.XML WCSADMIN

• check the acpload.logs and make sure there is no errors. 

Sharing Is Caring!!!!!!

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!!!!

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.

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.