Deleting a published store

When you publish a store using WebSphere Commerce, store assets and database objects are saved within the WebSphere Commerce Server. If you want to delete the store, you must ensure that it is cleaned from the WebSphere Commerce system. You might want to delete a store if you encountered problems when you tried to publish the store, or you have a corrupted store. Once the store is cleaned from the WebSphere Commerce system, you can republish it. The following procedure to delete a published store is not applicable for the toolkit environment as dbClean is not supported in the toolkit. If you want to delete a store, contract, or fulfillment without using dbClean, then refer to the following link, which contains all the dbClean objects Database Cleanup utility objects

Procedure

Open the WebSphere Commerce Accelerator

Close the store and mark it for deletion.

Option	Description
For B2B and B2C stores	Select your store in the Store name options. Click Store > Open/Close Click Close Store. Connect to the development database. In the STOREENT table, enter '1' for the MARKFORDELETE flag for your store. In the FFMCENTER table, enter `'1'` for the MARKFORDELETE flag for your store.
For Extended Sites stores	Select Extended Sites Hub in the Store name options. Select Extended Sites > View Stores. If you do not see this menu, then your logon ID does not have the appropriate authority to perform this task. Contact your Site Administrator. Select the check box to the left of the store that you want to delete. Click Delete. The page displays the updated list of stores. Connect to the development database. In the FFMCENTER table, enter `'1'` for the MARKFORDELETE flag for your store.

Option

Description

For B2B and B2C stores

Select your store in the Store name options.
Click Store > Open/Close
Click Close Store.
Connect to the development database.
In the STOREENT table, enter '1' for the MARKFORDELETE flag for your store.
In the FFMCENTER table, enter '1' for the MARKFORDELETE flag for your store.

For Extended Sites stores

Select Extended Sites Hub in the Store name options.
Select Extended Sites > View Stores. If you do not see this menu, then your logon ID does not have the appropriate authority to perform this task. Contact your Site Administrator.
Select the check box to the left of the store that you want to delete.
Click Delete. The page displays the updated list of stores.
Connect to the development database.
In the FFMCENTER table, enter '1' for the MARKFORDELETE flag for your store.

Delete WebSphere Commerce objects from the database:
1. Delete store objects
2. Delete contract objects
3. Delete fulfillment center objects (a default fulfillment center is assigned to all stores, so fulfillment center objects must be removed before you can republish the store).
4. Delete all SEO data objects that are related to the store. These objects can be found in the following tables: SEOURLKEYWORD, SEOURL, SEOREDIRECT, and SEOREDIRECTTRAFFIC.
Delete the store files from the file system using a partial application update.
Republish the store and test that it works. Use the same store name that you used previously. If you encounter issues when you republish your store, see Troubleshooting: Publishing a store archive.