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.
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
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:
- Open a connection to your database to run SQL statements
against your database.
- 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:
- 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:
- Open the Promotions tool.
- 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 . 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.