(Business processes) Update order status

Process: Update order status

Flow

Legend

Objective

Update the status of an order that was placed using Websphere commerce, and has been transferred to an external system for processing. The external system may transfer the statuses of such orders, so that users may monitor the status online using Websphere Commerce.

Description

The OrderStatus command is used when an Update_WCS_OrderStatus, Update_NC_OrderStatus, or Order Status Update message is received from a back-end system. The command updates information regarding the status of an existing order.

Features

Integration of order system with external systems

Edition

Professional, Enterprise

Tasks

Task Description Role

Associate item status with order
Associate the item status in the ORDISTAT table with a WebSphere Commerce order.
System

Create order status
Create the order status in the ORDSTAT table using the input information.

The first order status for an order must have orderId and merchantOrderNumber specified.
Check if the order specified in orderId exists in the ORDERS table.
If serialization information is available, such as the sequenceNumber and the lastUpdateTimestamp parameters, check if the values are more recent than the ones already in the ORDSTAT table; if not then no update will be performed.
System

Remove status for items not updated
Since a request for update was requested, remove the status for all items that are in the ORDISTAT table for the order and not in the input information provided.
System

Update existing order status
Update the existing order status in the ODSTAT table with the information provided as input.
System

Update order item status
Update the order item status in the ORDISTAT table for each item in the input provided.
System

Update order release
Update the order release in the ORDRELEASE table with the external order number from the input information provided.
System

Update status version
Update versioned status by making a copy of the last order status. Its version (OSVERNBR) will be set to the maximum number of existing version +1.
System

Business artifacts

Order item status
Order releases
Order status
Order status XML

Feedback

(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.

Task	Description	Role
Associate item status with order	Associate the item status in the ORDISTAT table with a WebSphere Commerce order.	System
Create order status	Create the order status in the ORDSTAT table using the input information. The first order status for an order must have orderId and merchantOrderNumber specified. Check if the order specified in orderId exists in the ORDERS table. If serialization information is available, such as the sequenceNumber and the lastUpdateTimestamp parameters, check if the values are more recent than the ones already in the ORDSTAT table; if not then no update will be performed.	System
Remove status for items not updated	Since a request for update was requested, remove the status for all items that are in the ORDISTAT table for the order and not in the input information provided.	System
Update existing order status	Update the existing order status in the ODSTAT table with the information provided as input.	System
Update order item status	Update the order item status in the ORDISTAT table for each item in the input provided.	System
Update order release	Update the order release in the ORDRELEASE table with the external order number from the input information provided.	System
Update status version	Update versioned status by making a copy of the last order status. Its version (OSVERNBR) will be set to the maximum number of existing version +1.	System