Configure deleting order items and requisition lists

+

Search Tips   |   Advanced Search

To improve performance you can enable the OrderTrashCan feature. If the OrderTrashCan feature is disabled, when a user deletes an order item or requisition list item the table rows representing those items are removed from the database. If enabled, these rows are updated to belong to the trashcan. You can clear the trashcan by running the OrderTrashCanClear scheduled job which will delete the rows, or by using the DBClean utility.

To configure the OrderTrashCan feature:

1. Open the WebSphere Commerce configuration file.

2. Within the file, the text can be put in any place between "<InstanceProperties>" and "</InstanceProperties>" as a child of InstanceProperties. e.g:

    
   <InstanceProperties>
   
   ....
   ....
   ....
   
   <ExpectedInventorySynchronize ExpCountFlag="Y"
                                 ExpRecCount="200" 
                                 display="false"/>
   
       <OrderTrashCan TrashCanOwner="-1002"
                      TrashCanRequisitionListSegmentLen="30"
                      TrashCanOrderItemSegmentLen="50"
                      TrashCanEnabled="true"/> 
   
   </InstanceProperties>
   
   
   

   The default behavior if this text is not included is the same as with this text included and TrashCanEnabled="true". And the parameters such as TrashCanRequisitionListSegmentLen are the default value described in the guide. The default behavior, when a user deletes an order item or requisition list item, the table rows representing those items will not be deleted from the DB but will be updated to belong to the trashcan.

   Where:

   TrashOwner

   The owner when deleting order items or requisition lists. The default value is -1002.

   TrashCanRequisitionListSegmentLen

   A commit count parameter that specifies the segment length of requisition list to delete. The default value is 30.

   TrashCanOrderItemSegmentLen

   A commit count parameter that specifies the segment length of order items to delete. The default value is 50.

   TrashCanEnabled

   Determines whether the trashcan feature is used to delete order items.

   false

   The order item is deleted from the database.

   true

   The order item is sent to the trashcan. This is the default value.

   Change the values appropriately and save the file.

3. Propagate your changes to the WebSphere Commerce configuration file.

4. Restart your WebSphere Commerce Server.

 

Related tasks

Deleting order objects

 

Related Reference

OrderItemDelete URL
OrderItemUpdate URL
RequisitionListDelete URL