Shipment tracking

  • Updated

Overview

Optimizely Configured Commerce provides an option to display shipment/order tracking information both on the website and in the Admin Console. Displaying this information requires data to exist within the Shipment database tables. Use the information in this article to enable this functionality.

Examples when tracking is enabled

This screen capture shows how the tracking information is displayed on the website within the Order Details section of My Account.

To view the data within the Admin Console, go to Sales > Order History, click View Only for an order and scroll to the Shipping Details section under the Order Lines.

Configuring

To see these views, data must exist in the Shipment and ShipmentPackage tables. The ShipmentPackageLines table is an optional table to provide details of products that are within each shipment package.

Shipment refreshes are required to integrate data between Configured Commerce and the ERP.

For testing purposes, populate the Shipment tables to view shipment information in the Admin Console or website. The following queries can be used to populate some test data into the database:

//This adds a shipmentINSERT INTO [dbo].[Shipment]           ([ShipmentNumber]           ,[ShipmentDate]           ,[EmailSentDate]           ,[WebOrderNumber])     VALUES           ('A1232114'           ,'2017-08-22'           ,'2017-08-22'           ,'WEB001001' //This web order or ERP order number should be an existing web or ERP order. The ERPOrderNumber column can also be used instead. )//This adds a shipment package related to a shipmentINSERT INTO [dbo].[ShipmentPackage]           ([ShipmentId]           ,[Carrier] //The value entered in this field needs to match the Name field for a Carrier. //These require specific values. See below           ,[TrackingNumber]           ,[Freight]           ,[PackageNumber]           ,[ShipVia]           )     VALUES           ('F478E1A3-DC88-E711-9487-80000B2CEBFA' //relative to the Shipment Id           ,'UPS'           ,'Z2321213215903'           ,2.00000           ,'1'           ,'GROUND'           )

The Carrier names listed in the table below are examples only. The only requirement is that a Carrier name in the Name field within the Admin Console must match the value entered in the Carrier field in the ShipmentPackage table (referenced above).

You also need to make sure the ERP Ship Code matches the ERP's ShipVia on the Carrier Service. See Creating Carrier Services for more details.

WebOrderNumber is required if you want to send out Shipment confirmation Emails.

Sample Carrier Names

Carrier Tracking Samples URL

UPS

http://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=[trackingnumber]

FEDEX

http://www.fedex.com/Tracking?language=english&cntry_code=us&tracknumbers=[trackingnumber]

Speedee

http://packages.speedeedelivery.com/packages/packages.php?tracking= [trackingnumber]

DHL

http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=[trackingnumber]

OLDD

http://www.odfl.com/trace/Trace.jsp?pronum=[trackingnumber]

If a matching tracking number is not found, the tracking number will not be hyperlinked.