Deleting a published store in Websphere Commerce

If you want to delete any published store from websphere commerce, there are certain steps to perform as detailed out below.

First, open the accelerator, and select “Extended sites hub”. I am assuming here that there is an extended site. Once the hub opens select the option “View Stores”. Select the store and then click “Delete”. This will delete the store that the consumer can access.

There are other elements of the store that needs to be deleted from the database. A store can be linked to a StoreFrontAssetStore, CatalogAssetStore, etc. Also, stores are associated with fulfilment centres. Hence to delete these objects from the database, use dbclean utility provided by IBM. Following are the steps.

1. Deleting Store Object

Use dbclean utility to clean up store objects in the database as below

dbclean -object store -type specified -db <<dbname>> -loglevel DEBUG -name <<StoreId>> -instancexml <<WC_Install_Dir>>/instances/<<instance_name>>/xml/<<instance_name>>.xml

2. Deleting Contract Objects (Only for WCS Enterprise edition)

dbclean -object contract -type obsolete -instancexml <<WC_Install_Dir>>/instances/<<instance_name>>/xml/<<instance_name>>.xml -db <<dbname>> -loglevel DEBUG

3. Deleting Fulfillment Centre Objects

Use dbclean utility to clean up fulfilment centre objects in the database as below

dbclean -object fulfillment_center -type obsolete -instancexml <<WC_Install_Dir>>/instances/<<instance_name>>/xml/<<instance_name>>.xml -db <<dbname> -loglevel DEBUG