Enable or disabling order blocking

Enable 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 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:

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

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 a customer services representative (CSR) tries to offer a price that exceeds their limit.
Negotiated shipping: WebSphere Commerce blocks orders when a customer services representative (CSR) tries to offer a shipping charge that exceeds their shipping discount limit.

Related Concepts

Order blocks
Negotiated pricing