To enable the attribute dictionary and non attribute dictionary attribute functionality concurrently

1. witch the implementation of ResolveSkuCmd to ResolveSkuAllCmdImpl in CMDREG table:

a. Open a respected database command window.
b. Run the following SQL command:

SQL> update cmdreg set classname='com.ibm.commerce.catalog.commands.ResolveSkuAllCmdImpl' where interfacename ='com.ibm.commerce.catalog.commands.ResolveSkuCmd';

2. To enable the attribute dictionary only, switch the implementation of ResolveSkuCmd to ResolveSkuNewCmdImpl in the CMDREG table:

a. Open a respected database command window.
b. Run the following SQL command:


SQL> update cmdreg set classname='com.ibm.commerce.catalog.commands.ResolveSkuNewCmdImpl' where interfacename ='com.ibm.commerce.catalog.commands.ResolveSkuCmd';

c. Customize the Catalogs tool to hide the local attribute table to prevent users from using the table to create a new attribute in the legacy table.

Note: To change the ResolveSkuCmd implementation for one store, you create a new row in the CMDREG table with the STOREENT_ID set to the store ID. If you set the STOREENT_ID to "0", the command applies to all the stores.


There are two types of attribute. Determine type of attribute you want to add

i. Allowed value attribute
ii. Assigned value attribute

Note: Supported data types : Text (STRING), Whole number(INTEGER) and Decimal Number(FLOAT)

To enable the attribute dictionary and non attribute dictionary attribute functionality concurrently

1. witch the implementation of ResolveSkuCmd to ResolveSkuAllCmdImpl in CMDREG table:

a. Open a respected database command window.
b. Run the following SQL command:

SQL> update cmdreg set classname='com.ibm.commerce.catalog.commands.ResolveSkuAllCmdImpl' where interfacename ='com.ibm.commerce.catalog.commands.ResolveSkuCmd';

2. To enable the attribute dictionary only, switch the implementation of ResolveSkuCmd to ResolveSkuNewCmdImpl in the CMDREG table:

a. Open a respected database command window.
b. Run the following SQL command:


SQL> update cmdreg set classname='com.ibm.commerce.catalog.commands.ResolveSkuNewCmdImpl' where interfacename ='com.ibm.commerce.catalog.commands.ResolveSkuCmd';

c. Customize the Catalogs tool to hide the local attribute table to prevent users from using the table to create a new attribute in the legacy table.

Note: To change the ResolveSkuCmd implementation for one store, you create a new row in the CMDREG table with the STOREENT_ID set to the store ID. If you set the STOREENT_ID to "0", the command applies to all the stores.


There are two types of attribute. Determine type of attribute you want to add

i. Allowed value attribute
ii. Assigned value attribute

Note: Supported data types : Text (STRING), Whole number(INTEGER) and Decimal Number(FLOAT)