Add new order block codes

Each block on an order has a block reason code. In addition to the order block reason codes with WebSphere Commerce, you can add additional order block codes to meet your business needs. These new order blocks can be added manually to orders.

You must add a new block reason code to the BLKRSNCODE table and a description of the new block reason in the BLKRSNDESC table. You can add the description in various languages in the BLKRSNDESC corresponding to the languages in which people use the WebSphere Commerce tools.

To add a new block reason code, issue the following SQL statements from the SQL command line processor for your WebSphere Commerce database

 INSERT INTO BLKRSNCODE (BLKRSNCODE_ID, BLOCKREASONTYPE, MANUALBLOCK, MARKFORDELETE) VALUES (code, " reason", 1, '0')  INSERT INTO BLKRSNDESC (BLKRSNCODE_ID, LANGUAGE_ID, DESCRIPTION) VALUES (code,  language_id, " description",0) 


By default, the generated code is respected by all stores on the site. To disable the code for a specific store, issue the following statement:

INSERT INTO STORBLKRSN (STOREENT_ID, BLKRSNCODE_ID, RESPECTED, TKLRGENERATION) VALUES (<storeent_id/>," code", 0, 0)


The user-defined values are:

code

A numeric code for the new reason. Four digit codes starting with "5" (5xxx) are reserved for IBM use.

reason

A broad classification for the reason code. Use this field to group reason codes of a similar nature by using the same broad classification for various reason codes.

language_id

This is the language ID (primary key) of the LANGUAGE table corresponding to the National Language in which you are adding the description. The following table lists the language IDs initially available in WebSphere Commerce.

storeent_id

This means that the <code> will be disabled or enabled on storeent_id.


English (US) -1
French -2
German -3
Italian -4
Spanish -5
Brazilian Portuguese -6
Simplified Chinese -7
Traditional Chinese -8
Korean -9
Japanese -10

description

A description of the reason code in the National Language whose code you selected as the language_id. This descriptions appears in the WebSphere Commerce Accelerator.

 

Related Concepts


Order blocks

 

Related tasks


Add a block to an order