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.
Using UDFs (Drop Ship option turned OFF / not enabled)
- In UPS Worldship, the order information is pulled from Control's database using the UPSShipperInfo view.
- Once the shipment is processed, UPS Worldship updates the UPSShippingLog table with the processed information.
- 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.
- In Control, the order is opened and displays the changes made to the UDFs.
UDF Field Update (Drop Ship not enabled)
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_Charges | UPSShippingLog.ShipperCharge |
TransHeaderUserField.UPS_Total_Charges | UPSShippingLog.TotalCharge |
TransHeaderUserField.UPS_Package_Weight | UPSShippingLog.Weight |
TransHeaderUserField.UPS_Shipment_Date | UPSShippingLog.ShipDate |
TransHeaderUserField.UPS_Tracking_Number | UPSShippingLog.TrackingNumber |
Using UDFs (Drop Ship option turned ON)
- In Control, the Drop Ship option is checked and the ship to information is filled in and saved.
- In UPS Worldship, the order and ship to information is pulled from Control's database using the UPSShipperInfo view.
- Once the shipment is processed, UPS Worldship updates the UPSShippingLog table with the processed information.
- 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.
- 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 Name | Field Updated Form | ||
TransHeaderUserField.UPS_Shipper_Charges | UPSShippingLog.ShipperCharge | ||
TransHeaderUserField.UPS_Total_Charges | UPSShippingLog.TotalCharge | ||
TransHeaderUserField.UPS_Package_Weight | UPSShippingLog.Weight | ||
TransHeaderUserField.UPS_Shipment_Date | UPSShippingLog.ShipDate | ||
TransHeaderUserField.UPS_Tracking_Number | UPSShippingLog.TrackingNumber |
—-
Using Shipment Items (Shipping Tab in Order Entry)
- In Control, a shipment item is created in the Shipping Tab and the shipping information is filled in and saved.
- 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).
- 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.
- 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.
- 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.ActualCost | UPSShippingLogForShipments.ShipperCharge |
Shipments.CarrierID | ShippingMethod.ID |
Shipments.CarrierClassTypeID | ShippingMethod.ClassTypeID |
Shipments.CarrierService | UPSShippingLogForShipments.ServiceType |
Shipments.EstimatedCost | UPSShippingLogForShipments.TotalCharge |
Shipments.IsShipped | Automatically set to TRUE |
Shipments.NumberOfPackages | UPSShippingLogForShipments.NumberOfPackages |
Shipments.PackageSize | UPSShippingLogForShipments.PackageType |
Shipments.PackageWeight | UPSShippingLogForShipments.Weight |
Shipments.ShipDate | UPSShippingLogForShipments.ShipDate |
Shipments.TrackingNumber | UPSShippingLogForShipments.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"