Unable to arrange categories in Sterling Business Center

Technote (troubleshooting)


Problem(Abstract)

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.

Symptom

The issue is noticed when the catalog administrator is unable to arrange/move categories in the catalog using Sterling Business Center.


Cause

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.

Cross reference information
Segment Product Component Platform Version Edition
Commerce Sterling Selling and Fulfillment Suite AIX, HP-UX, Linux, Solaris, Windows 9.0

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Sterling Order Management
Maintenance

Software version:

9.1, 9.2

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1617727

Modified date:

2012-11-27

Translate my page

Machine Translation

Content navigation