This article describes the overall process used by Cyrious to integrate shipping with UPS Worldship. It expands on the how_the_shipping_integration_works article.

  1. In UPS Worldship, the order information is pulled from Control's database using the UPSShipperInfo view.
  2. Once the shipment is processed, UPS Worldship updates the UPSShippingLog table with the processed information.
  3. The database trigger UpdateUPSUDF is fired when the UPSShippingLog table is updated. The trigger updates the order UDF field values (stored in the TransHeaderUserField table). View the table below for the all the fields that are updated.
  4. In Control, the order is opened and displays the changes made to the UDFs.

This table shows the fields in the TransHeaderUserField database table that are updated after a shipment is processed through UPS Worldship.

Field Name Field Updated Form
TransHeaderUserField.UPS_Shipper_ChargesUPSShippingLog.ShipperCharge
TransHeaderUserField.UPS_Total_ChargesUPSShippingLog.TotalCharge
TransHeaderUserField.UPS_Package_WeightUPSShippingLog.Weight
TransHeaderUserField.UPS_Shipment_DateUPSShippingLog.ShipDate
TransHeaderUserField.UPS_Tracking_NumberUPSShippingLog.TrackingNumber


Using UDFs (Drop Ship option turned ON)

  1. In Control, the Drop Ship option is checked and the ship to information is filled in and saved.
  2. In UPS Worldship, the order and ship to information is pulled from Control's database using the UPSShipperInfo view.
  3. Once the shipment is processed, UPS Worldship updates the UPSShippingLog table with the processed information.
  4. The database trigger UpdateUPSUDF is fired when the UPSShippingLog table is updated. The trigger updates the order UDF field values (stored in the TransHeaderUserField table). View the table below for the all the fields that are updated.
  5. In Control, the order is opened and displays the changes made to the UDFs.

UDF Field Update (Drop Ship ON)
This table shows the fields in the TransHeaderUserField database table that are updated after a shipment is processed through UPS Worldship.

Field NameField Updated Form
TransHeaderUserField.UPS_Shipper_ChargesUPSShippingLog.ShipperCharge
TransHeaderUserField.UPS_Total_ChargesUPSShippingLog.TotalCharge
TransHeaderUserField.UPS_Package_WeightUPSShippingLog.Weight
TransHeaderUserField.UPS_Shipment_DateUPSShippingLog.ShipDate
TransHeaderUserField.UPS_Tracking_NumberUPSShippingLog.TrackingNumber

—-
Using Shipment Items (Shipping Tab in Order Entry)

  1. In Control, a shipment item is created in the Shipping Tab and the shipping information is filled in and saved.
  2. In UPS Worldship, the shipment information is pulled from Control's database using the ShipperInfoForShipments view. The Look up Value must be the shipment number (Ex: 1234-SAA).
  3. Once the shipment is processed, UPS Worldship updates the UPSShippingLogForShipments table with the processed information. The database trigger UpdateUPSShipment is automatically fired after this update.
  4. The database trigger UpdateUPSShipment updates the shipment field values (stored in the Shipments table). View the table below for the the fields that are updated.
  5. In Control, the order is opened and displays the changes made to the shipments.

Shipment Item Field Update
This table shows the fields in the Shipments database table that are updated after a shipment is processed through UPS Worldship.

Field Name Field Updated Form
Shipments.ActualCostUPSShippingLogForShipments.ShipperCharge
Shipments.CarrierIDShippingMethod.ID
Shipments.CarrierClassTypeIDShippingMethod.ClassTypeID
Shipments.CarrierServiceUPSShippingLogForShipments.ServiceType
Shipments.EstimatedCostUPSShippingLogForShipments.TotalCharge
Shipments.IsShippedAutomatically set to TRUE
Shipments.NumberOfPackagesUPSShippingLogForShipments.NumberOfPackages
Shipments.PackageSizeUPSShippingLogForShipments.PackageType
Shipments.PackageWeightUPSShippingLogForShipments.Weight
Shipments.ShipDateUPSShippingLogForShipments.ShipDate
Shipments.TrackingNumberUPSShippingLogForShipments.TrackingNumber

UPS Worldship updates the database directly and since there is no method to inform Control of the change, the order will not reflect the change if it is currently being displayed during the UPS Worldship processing. The display of the order must be closed and reopened for the changes to reflect.

include component"backlinks" page"FedEx Integration Process" limit"10"


You could leave a comment if you were logged in.