Version 5.9
In this Topic: Show
The UPS WorldShip Setup task found on the Shipping & Fulfillment tab of the Maintenance Menu performs several basic steps that must be completed before an external ODBC shipping software solution can be configured to directly exchange shipping and tracking information with the Order Manager. There is no user interface, the process is immediately started when the function is double-clicked.
While the name states it is for UPS WorldShip, this function must also be run prior to configuring FedEx ShipManager, DHL's DBConnect, or any other ODBC external shipping application that wants to directly exchange shipping and tracking information with the Order Manager.
The process involves the creation of an ODBC definition and the copying of queries that are required to map fields from the external shipping application to the appropriate Order Manager fields.
Enterprise users that have implemented SQL databases as their store data files must take additional action to properly implement the exchange of data with an external shipping application. Please refer to the Knowledge Base topic, for the specific shipping software that is being used, for more information. They are listed at the bottom of this article.
Users of 64-bit processors should read Knowledge Base topic, Windows 64-Bit Operating System Considerations, for more information about how that affects this process.
If a 64-bit processor is being used, refer to Knowledge Base topic, Windows 64-Bit Operating System Considerations, for more information about how that affects this process.
Click the [UPS WorldShip Setup] function on the Shipping & Fulfillment tab or Setup Functions tab of the Maintenance Menu.
Enter a Name for the System DSN and click [OK].
Figure 1: Prompt to enter name of new ODBC connection
The program will create an ODBC definition on the current workstation, in the background, using the name that was provided; there is no user interface.
The program will also copy a group of queries from the program file to the store data file; if they already exist, the program will replace them with the copies from the program file.
When the process is completed, the program will display a message box stating the name of the ODBC connection that was just created, the store data file that it represents, and the fact that the shipping queries were copied to the store data file, as well.
Figure 2: Order Manager's results message
Click [OK] to close the message box.
To see the ODBC connection that was created, go to Administrative Tools section of the Control Panel of the operating system and look for Data Sources (ODBC). refer to the Windows Help for more information.
This process should be repeated on each workstation that may be used to print shipping labels from external shipping applications that will also attempt to directly exchange data with the Order Manager (as opposed to exporting shipping information or importing tracking information from a text file).
Proceed with the remainder of the steps for setting up the external shipping application (import and export maps). See the appropriate Knowledge Base page for the shipping application in use.
If problems are encountered during this process and the ODBC connection was created, but the queries were not copied successfully, execute the Copy Shipping Queries function, which is also found on the Shipping & Fulfillment tab of the Maintenance Menu.
Setting_Up_and_Using_FedEx_Ship_Manager.htm
UPS_WorldShip_Setup_with_the_Enterprise_Edition.htm
UPS_WorldShip_Setup_Full_Documentation.htm
Created: 4/4/11
Modified: 4/30/13
Go to Top