{$page}

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

Using UDFs (Drop Ship option turned OFF / not enabled)

1. In Fed Ex, the order information is pulled from Control's database using the ShipperInfo / FedExShipperInfo view.

1. Once the shipment is processed, FedEx updates the ShippingLog / FedExShippingLog table with the processed information.

1. The database trigger UpdateFedExUDF is fired when the ShippingLog / FedExShippingLog 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.

1. 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 FedEx. ||~ Field Name ||~ Field Updated From || || TransHeaderUserField.FedEx_Actual_Price || ShippingLog.ActualPrice || || TransHeaderUserField.FedEx_List_Price || ShippingLog.ListPrice || || TransHeaderUserField.FedEx_Package_Weight || ShippingLog.Weight || || TransHeaderUserField.FedEx_Shipment_Date || ShippingLog.ShipDate || || TransHeaderUserField.FedEx_Tracking_Number || ShippingLog.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 Fed Ex, the order and ship to information is pulled from Control's database using the FedExShipperInfo view.
   # Once the shipment is processed, FedEx updates the FedExShippingLog table with the processed information.
   # The database trigger UpdateFedExUDF is fired when the FedExShippingLog 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 FedEx.
   ||~ Field Name ||~ Field Updated From ||

|| TransHeaderUserField.FedEx_Actual_Price || FedExShippingLog.ActualPrice ||

—-
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 Fed Ex, the shipment information is pulled from Control's database using the ShipperInfoForShipments view. The Look up Value can either be the shipment number or the order number.
# Once the shipment is processed, FedEx updates the FedExShippingLogForShipments table with the processed information. The database trigger UpdateFedExShipment is automatically fired after this update.
# The database trigger UpdateFedExShipment updates the shipment field values (stored in the Shipments 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 shipments.
Shipment Item Field Update
This table shows the fields in the Shipments database table that are updated after a shipment is processed through FedEx.
||~ Field Name ||~ Field Updated From || || Shipments.ActualCost || FedExShippingLogForShipments.ActualPrice || || Shipments.CarrierID || ShippingMethod.ID || || Shipments.CarrierClassTypeID || ShippingMethod.ClassTypeID || || Shipments.CarrierService || FedExShippingLogForShipments.ServiceType || || Shipments.EstimatedCost || FedExShippingLogForShipments.ListPrice || || Shipments.InsuredValue || FedExShippingLogForShipments.DeclaredValue || || Shipments.IsShipped || Automatically set to TRUE. || || Shipments.Notes || FedExShippingLogForShipments.DeliveryInstructions || || Shipments.NumberOfPackages || FedExShippingLogForShipments.NumberOfPackages || || Shipments.PackageSize || FedExShippingLogForShipments.PackageType || || Shipments.PackageWeight || FedExShippingLogForShipments.Weight || || Shipments.ShipDate || FedExShippingLogForShipments.ShipDate || || Shipments.TrackingNumber || FedExShippingLogForShipments.TrackingNumber || —- FedEx 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 being displayed during the FedEx processing. The display of the order must be closed and reopened for the changes to reflect.

Links

include_componentbacklinks_pagefedex_integration_process_limit10