Sample store - do not use as a base for a production site

Enabling the shipment tracking URL

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

  1. Set up a shipment tracking URL for every Shipping Provider, as described in Setting up shipping.
  2. 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.

Results