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.