UPS WorldShip Setup

Contents of this Topic: ShowHide

Overview

The UPS WorldShip Setup task similar to a note but a task has an action assigned to a particular user. The security system must be enabled to use the task feature of Monsoon OMS. found at Main Menu > Settings > Shipping Functions 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 OMS . There is no user interface, the process is immediately started when the function is selected.  

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 OMS

The process involves the creation of an ODBC definition and the copying of queries that are required to map Minimum Advertised Price; applies to Consumer Goods categories and listed on Amazon Seller Central Market fields from the external shipping application to the appropriate OMS fields.

Enterprise users who 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.

Users of  64-bit processors should read Knowledge Base topic, Windows 64-Bit Operating System Considerations, for more information about how this process is affected by 64-bit environments.

Executing the UPS WorldShip Setup Function

Create an ODBC to the Store Data File for the Current Workstation and Copy Queries to Store Data File

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.  

1. Go to Main Menu > Settings > Shipping Functions > UPS WorldShip Setup.

2. Enter a name for the System DSN Data Source Name - associates a specific SQL Server, driver, and database together in a connection string used to access the data. and click OK. The name cannot contain any spaces.

3. The program creates an ODBC definition on the current workstation in the background, using the name that was provided; there is no user interface.

4. The program  also copies a group of queries from the program file The MS Access database that contains the Monsoon OMS application code. This database does not contain the user's order information, which is housed in the Store Data File. The program file name begins with SEOrdMan* and has the extension of .mdb. to the store data file the MS Access or SQL database that contains the users order information and program preferences. It does not contain Reports, which are housed in the Monsoon OMS program file (MS Access database).. Iff they already exist, the program replaces them with the copies from the program file.

5. When the process is completed, the program displays a message box stating the name of the ODBC connection abbreviation for Open Database Connectivity, which is the technology that allows applications to access data from a database, independent of the programming language of the application, or the operating system upon which it is run. For example, Monsoon OMS uses an ODBC Connection to share information with UPS WorldShip. that was created, the store data file that it represents, and the fact that the shipping queries were copied to the store data file.

6. Click OK to close the message box.

7. To see the ODBC connection that was created, go to the Administrative Tools section of the Control Panel section of the operating system and look for Data Sources (ODBC). Refer to the Windows Help for more information.

8. 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 OMS (as opposed to exporting shipping information or importing tracking information from a text file).

9. 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, found at Main Menu > Settings > Shipping Functions.

Additional Information

Windows 64-Bit Operating System Considerations

Created: 4/4/11

Revised: 8/1/12

Published: 04/14/16