{$page} 



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 From ||
|| 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 From ||
|| 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 From ||
|| 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_componentbacklinks_pagefedex_integration_process_limit10]]