Changing promotion folders

You can change the details and hierarchy of your promotion folders to improve the structure of your promotion folder hierarchy to match changing promotion management needs. If you are a business user, an Operations Manager or Site Administrator is required to aid in changing the promotion folder.

Feature Pack 6 or later Support for changing promotion folders within the Management Center Promotions tool is provided by default. If you are a business user, you no longer require an Operations Manager or Site Administrator to change promotion folders. Use Management Center to change your promotion folders. For more information, see Changing promotion folders

Feature Pack 8 As an administrator, you can also use the Data Load utility to change your store promotion folders. Sample configuration and input files are provided which you can copy and modify to help you configure the Data Load utility to change promotion folders. For more information, see Loading promotion folders and promotions into promotion folders.

About this task

A promotion folder can contain sub folders or promotions. A subfolder cannot be assigned to multiple parent folders. You can assign a single PARENTFOLDER_ID to a folder. To change the relationship and hierarchical structure of your store promotion folders, you must run SQL update statements against your WebSphere Commerce database. Changing the hierarchical relationship of your promotion folders does not change the promotions that are associated with the folder. When you change the hierarchy of a folder, all of the folders contents are moved with the folder. When the promotion folder is changed, business users can add and remove promotions into the promotion folder with Management Center. For more information about managing promotion folders with Management Center, see Organizing promotions with folders

Procedure

Optional: Determine the unique ID of the store that contains your promotion folder. If your site uses an extended site store model, then multiple folders can exist with identical names and descriptions. The unique store ID can be required to identify your promotion folder:
1. Open a connection to your database to run SQL statements against your database.
2. Run the following SQL query:
```
SELECT STORE_ID FROM STORE WHERE DIRECTORY='YourStoreName';
```
  Make note of the value. This value is used for the STOREENT_ID of your promotion folder.
Retrieve the details of the promotion folder you want to change. If your WebSphere Commerce instance has folders with the same IDENTIFIER and are associated with different stores, use the STOREENT_ID to identify your folder. Run the following SQL query and make note of the FOLDER_ID value:
```
SELECT FOLDER_ID, IDENTIFIER, DESCRIPTION, PARENTFOLDER_ID FROM FOLDER WHERE STOREENT_ID=YourStoreId AND IDENTIFIER='YourPromotionFolder' AND TYPE='IBM_PromotionFolder';
```
Make a note of your promotion folder FOLDER_ID and details.
Determine the new PARENTFOLDER_ID for the folder you want to have as the parent folder for the promotion folder you are updating:
- If you are changing your folder to a top-level folder, the parent folder must be set to NULL.
- If you are moving your folder under an existing folder, you must find the ID of the parent folder. Run the following SQL query to list all current folders for your store:
```
SELECT FOLDER_ID, IDENTIFIER, DESCRIPTION FROM FOLDER WHERE STOREENT_ID=YourStoreId AND TYPE='IBM_PromotionFolder';
```
  Select the parent folder and make a note of the FOLDER_ID value for the folder.
Run the following SQL update statement to create the hierarchy for your promotion folder with the values determined in the previous steps:
```
UPDATE FOLDER SET PARENTFOLDER_ID=YourParentFolderID WHERE FOLDER_ID=YourFolderId AND STOREENT_ID=YourStoreId AND TYPE='IBM_PromotionFolder';
```
Where YourFolderID is the ID of the folder you are updating the parent of. If you are creating a top-level folder, YourParentFolderID is NULL. If you are creating a sub folder, YourParentFolderID is the unique ID value of the parent folder you found in step 3.
Verify that your promotion folder is changed:
1. Open the Promotions tool.
2. Click Promotion Folders. The Promotion Folders List displays. Verify that your changed promotion folder displays.
  Note: If your promotion folder does not display or has the incorrect parent, click File > Reload All and Close. Click Promotion Folders. The Promotion Folders List is updated. Verify that your promotion folder displays.

Results

Your folder is changed. Business users can now continue managing the promotion folder with the Management Center Promotions tool.