UPS WorldShip

Overview

In this article we will provide an overview describing xTuple ERP's support for "UPS WorldShip" integration. "UPS WorldShip" is a Windows-based, shipping software application for UPS customers who have high-volume shipping needs. When UPS WorldShip and xTuple ERP are integrated, you have the ability to export key UPS information—that is, tracking numbers and freight charges—directly into xTuple ERP. 

Basic Requirements

The requirements for setting up UPS WorldShip to communicate with xTuple ERP include the following:

• Install UPS WorldShip software on a networked workstation

• Download and install ODBC driver for PostgreSQL

• Configure UPS WorldShip to auto-export using the PostgreSQL ODBC driver

• Create user-defined field for entering xTuple ERP sales order numbers and shipment numbers

• Define export mapping to associate UPS WorldShip data fields with corresponding xTuple ERP data fields

UPS WorldShip supports both import and export maps. However, for integration with xTuple ERP, you only need an export map since the communication is one-way. The following screenshot shows a sample export map created using the UPS WorldShip mapping utility:

Export Map in UPS WorldShip

In our example, we have created a map called "export." The map type is "Shipment," which indicates the data export will occur when the shipment is shipped using UPS WorldShip, and the ODBC driver used to export the data to the xTuple ERP database is called "openmfg."

The following screenshot shows the utility you would use to edit your export map within UPS WorldShip:

WorldShip Utility for Editing Export Map

Your primary goal when creating an export map is to match UPS WorldShip tables and fields with the corresponding xTuple ERP database tables and fields. The following table provides you with the information you will need to successfully map the tables and fields from one system to the other.