The
sample store contains
a shipment
tracking URL on the order status page. This field allows customers
to track the status of each order item from purchase to delivery.
To use the shipment tracking URL, every order item needs to create
a manifest with a tracking ID. You will need to customize WebSphere
Commerce to add information to the ORDRELEASE, MANIFEST, and ORDERITEMS
tables. This information may come from a back-end system as part of
integration. These instructions outline the information that needs
to be added to the database for every order item.
Procedure
- Set up
a shipment tracking URL for every Shipping Provider,
as described in Setting
up shipping.
- For every order item, enter
the following information into
the database. As an example:
insert into ORDRELEASE (ORDERS_ID, ORDRELEASENUM, STATUS)
values(11001, 10001, 'MNF')
insert into MANIFEST (DATESHIPPED, MANIFEST_ID, ORDERS_ID,
ORDERELEASENUM, SHIPPINGCOSTS, TRACKINGID)
values('2003-07-21-14.47.17.797000', 10001, 11001,
10001, 5.3, 'trackingID')
update ORDERITEMS set ORDRELEASENUM=10001 where CATENTRY_ID=10000
Where:
- ORDERS_ID
- ORDERS_ID from the ORDERS table for which the manifest is performed.
- ORDRELEASENUM
- A
unique identifier for the release. This value must be an integer.
- STATUS
- Use
the status MNF. This status indicates that the release shipment
confirmation was received.
- DATESHIPPED
- The date and time that
the package was shipped. This value must
be in the YYYY-MM-DD-HH.MM.SS.mmmmmm format.
- MANIFEST_ID
- A generated unique ID.
- SHIPPINGCOSTS
- A
decimal value indicating the shipping costs.
- TRACKINGID
- The tracking ID for the
shipping provider as entered on the Shipping
notebook.
- CATENTRY_ID
- The ID of
the item in the order.