Advanced orders Enabling or disabling order blocking

The blocking of orders is controlled by the order block manager which can be enabled or disabled on a store-by-store basis. The order block manager tells WebSphere Commerce whether an order is blocked or not. When you first publish a store that uses advanced order processing, the order block manager is enabled.

You can enable or disable order blocking for a store by issuing the following SQL statement from the SQL command line processor for your WebSphere Commerce database:

UPDATE STORE SET BLOCKINGACTIVE=blocking_value WHERE STORE_ID=store_ID

where the user-defined value is:

blocking_value
Use the following table to select the blocking value:
Action blocking_value
Enable order blocking for the store. 1
Disable order blocking for the store. 0
store_ID
This is the store ID for the store in which you want to enable or disable order blocking.

Order blocking must be enabled for you to use the following:

Order approval
WebSphere Commerce blocks orders requiring approval automatically until approval is received.
Negotiated pricing
WebSphere Commerce blocks orders when when a customer services representative (CSR) tries to offer a price that exceeds their limit.
Negotiated shipping
WebSphere Commerce blocks orders when when a customer services representative (CSR) tries to offer a shipping charge that exceeds their shipping discount limit.

Feedback