The purpose of the UPS Shipping Interface is to send information about a mail order that has been shipped via a UPS shipping method in PrismCore to a computer running the UPS WorldShip software, and to receive a UPS tracking number in return. The interface is run as a service in WPServer. Unlike many services in WPServer, the UPS Shipping Interface does NOT use FTP. Instead, WorldShip and PrismCore share information using a shared directory.
When this service is running, PrismCore periodically creates an export file that contains basic information about the mail order shipment (e.g. receipt number, customer's account number, shipping address information, total weight, transaction total, shipping charge, date) and puts it in a designated shared directory. This file is picked up from the directory by the UPS WorldShip software. This enables the user to print a UPS shipping label through WorldShip with all the appropriate information on it. The UPS WorldShip program then creates a file with the receipt number and UPS tracking number, which it puts in the directory. From there it is imported by WPServer into PrismCore.
'MAILORDER', Mail Order Number
'FILLER', Unused
'CUSTOMER', Customer Account Number
'SHIPNAME1', Customer Name
'SHIPNAME2', Customer Name
'SHIPADDRESS1', Customer Address
'SHIPADDRESS2', Customer Address
'SHIPCITY', Customer City
'SHIPSTATE', Customer State
'SHIPZIP', Customer Zip Code
'SHIPCOUNTRY', Customer Country
'SHIPPHONE', Customer Phone
'SHIPMETHOD', Shipping Code Description
'SHIPWEIGHT', Total Shipping Weight
'SHIPTOTAL', Transaction Total
'FILLER', Unused
'Y', Always Y
'SHIPCOMMENT', Shipping Comment
'EMAIL', Always EMAIL
'EMAILYN', Y/N if email included
'EMAILADDRESS', Customer Email Address
'NUMBEROFSHIPMENT',Number of Items in Shipment
'TODAY', Current Date MM/DD/YYYY
'FILLER', Unused
'FILLER', Unused
'FILLER' Unused
'MAILORDER', Mail Order Number
'TRACKNUMBER', UPS Tracking Number
'SECNUM', ???
'FILLER', Unused
'METHOD', Shipping Method
'WEIGHT' Total Shipping Weight
Sample field mapping | |||||||
External File from Win Prism (Description) | UPS WorldShip Maping | ||||||
Import | Column # | PrismCore File Layout | Description from PrismCore | WorldShip Table | Column# | WorldShip Mapped Fields | Translations |
1 | Mailorder | Mail Order Number | ShipTo | 1 | Customer ID | ||
Mailorder | Mail Order Number | Package | 5 | Reference 1 | |||
2 | Filler | Unused | NOT USED | ||||
3 | Customer | Customer Account Number | ShipTo | 11 | Telephone | ||
4 | ShipName1 | Customer Name | ShipTo | 2 | Company or Name | ||
5 | ShipName2 | Customer Name | ShipTo | 5 | Room / Floor / Address2 | ||
6 | ShipAddress1 | Customer Address | ShipTo | 4 | Street Address | ||
7 | ShipAddress2 | Customer Address | ShipTo | 3 | Attention | ||
8 | ShipCity | Customer City | ShipTo | 9 | City | ||
9 | ShipState | Customer State | ShipTo | 10 | State / Prov | ||
10 | ShipZip | Customer Zip Code | ShipTo | 8 | Postal / Zip Code | ||
11 | ShipCountry | Customer Country | ShipTo | 7 | Country | ||
12 | ShipPhone | Customer Phone | ShipTo | NOT USED | |||
13 | ShipMethod | Shipping Code Description | ShipmentInformation | 2 | Service Type | You will have to use translations. | |
14 | ShipWeight | Total Shipping Weight | NOT USED | ||||
15 | ShipTotal | Transaction Total | NOT USED | ||||
16 | Filler | Unused | NOT USED | ||||
17 | Y | Always Y | NOT USED | ||||
18 | ShipComment | Shipping Comment | NOT USED | ||||
19 | Always EMAIL | ShipmentInformation | 22 | QVN Recipient 1 Type (Fax / Email) | |||
20 | EmailYN | Y/N if email included | ShipmentInformation | 19 | QVN Ship Notification 1 Option | ||
21 | EmailAddress | Customer Email Address | ShipmentInformation | 26 | QVN Recipient 1 Fax or Email | ||
22 | NumberOfShipment | Number of Items in Shipment | NOT USED | ||||
23 | Today | Current Date MM/DD/YYYY | NOT USED | ||||
24 | Filler | Unused | NOT USED | ||||
| Filler | Unused | NOT USED | ||||
26 | Filler | Unused | NOT USED |