Unable to arrange categories in Sterling Business Center
Business Center allows the arrangement of categories into the order they are to be displayed on the web channel. When multiple categories have the same sequence number in the database, the categories can no longer be moved.
The issue is noticed when the catalog administrator is unable to arrange/move categories in the catalog using Sterling Business Center.
The display of categories is controlled by the YFS_CATEGORY.SEQUENCE_NO column. When categories belonging the same parent category (PARENT_CATEGORY_KEY) have the same sequence number (SEQUENCE_NO) the categories can not be arranged using Sterling Business Center.
Diagnosing the problem
The is problem can be diagnosed by running the following SQL on the database to determine which categories have the same sequence number as the one you are unable to move.
SELECT CATEGORY_ID, SEQUENCE_NO FROM YFS_CATEGORY WHERE SEQUENCE_NO = (SELECT SEQUENCE_NO FROMYFS_CATEGORY WHERE CATEGORY_ID = '<Your Category Id>') AND PARENT_CATEGORY_KEY = (SELECT PARENT_CATEGORY_KEY from YFS_CATEGORY WHERE CATEGORY_ID = '<Your Category Id>')
Note: Substitute <Your Category Id> with the category id which can not be moved.
Resolving the problem
This issue is resolved by either manually updating the YFS_CATEGORY.SEQUENCE_NO column using SQL or running the manageCategory API to change the sequence number for the affected categories.
|Commerce||Sterling Selling and Fulfillment Suite||AIX, HP-UX, Linux, Solaris, Windows||9.0|
More support for:
Sterling Order Management
Software version: 9.1, 9.2
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1617727
Modified date: 27 November 2012