UPS WorldShip 8.0 Sample Order Import 1 Map

Title: The End of Day process transmits your shipment information to UPS and prints the reports required by your UPS driver Author: Type Department...

34 downloads 699 Views 789KB Size
UPS WorldShip® 8.0 Sample Order Import 1 Map

Below is an example of how to import shipment information which resides in a .CSV file format using the Sample Order Import 1 map provided with WorldShip. In this example, you will need to have the fields listed below under “WorldShip CSV Fields” in your .CSV file with the field names as they are listed below (Please do not include spaces between text in a field name). You will need to place the .CSV in the C:\UPS\UOWS\impexp\AcctPkgs\Sample Order Import 1 folder and name your file worldship.csv. WorldShip CSV Fields ORDERID PACKAGE_DECLAREDVALUEAMOUNT PACKAGE_DECLAREDVALUEOPTION PACKAGE_PACKAGETYPE PACKAGE_REFERENCE1 PACKAGE_REFERENCE2 PACKAGE_REFERENCE3 PACKAGE_REFERENCE4 PACKAGE_REFERENCE5 PACKAGE_WEIGHT SHIPMENTINFORMATION_BILLINGOPTION SHIPMENTINFORMATION_NOTIFICATIONRECIPIENT1FAXOREMAIL SHIPMENTINFORMATION_NOTIFICATIONRECIPIENT1TYPE SHIPMENTINFORMATION_QVNOPTION SHIPMENTINFORMATION_QVNSHIPNOTIFICATION1OPTION SHIPMENTINFORMATION_SERVICETYPE SHIPTO_CITY SHIPTO_COMPANYORNAME SHIPTO_COUNTRY SHIPTO_LOCATIONID SHIPTO_RESIDENTIALINDICATOR SHIPTO_ROOMFLOORADDRESS2 SHIPTO_STATE SHIPTO_STREETADDRESS SHIPTO_TELEPHONE SHIPTO_ZIPCODE

© Copyright 2005, United Parcel Service of America, Inc. All rights reserved.

WorldShip Fields Customer ID Declared Value Amount Declared Value Option Package Type Reference 1 Reference 2 Reference 3 Reference 4 Reference 5 Weight Billing Option Notification Recipient 1 Fax or Email Notification Recipient 1 Type (fax or Email) QVN Option QVN Ship Notification 1 Option Service Type City Company or Name Country Location ID Residential Indicator Room/Floor/Address 2 State/Prov Street Address Telephone Postal/ZIP Code

1

UPS WorldShip® 8.0 Sample Order Import 1 Map

To import shipments using the Sample Order Import 1 map:

Step

Window (if available)

1. Select Batch Import from the drop down under UPS OnLine Connect

Note: You can also use the Sample Order Import 1 map while performing a Keyed Import. A Keyed Import imports a single record from the WorldShip.csv file by using a key field (e.g. Customer ID). The key field uniquely identifies a particular order that you would like to import to WorldShip. While importing via Keyed Import, WorldShip will prompt you to enter in the key for the order in which you would like to import.

2. The Batch Import Data window appears •

Select Sample Order Import 1 and then click Next

Note: During Batch Import, WorldShip provides the option to Process Shipments Automatically After Import. This method requires that all information (e.g. Weight, Service) needed to complete the shipment appear in the data being imported.

© Copyright 2005, United Parcel Service of America, Inc. All rights reserved.

2

UPS WorldShip® 8.0 Sample Order Import 1 Map

Step

Window (if available)

3. The Import/Export Preview window appears •

This window will display the total number of records which appear in your WorldShip.csv file



Click Next to begin the import process

4. WorldShip will begin to import the shipments •

Once the brown truck reaches 100% your import is complete

© Copyright 2005, United Parcel Service of America, Inc. All rights reserved.

3

UPS WorldShip® 8.0 Sample Order Import 1 Map

Step

Window (if available)

5. The Import/Export Summary window will provide you with a summary of the total number of records which were imported •

Click Save to complete the import process

6. To process your imported shipments, click on the Imported Shipments folder found in the Pickup Log

© Copyright 2005, United Parcel Service of America, Inc. All rights reserved.

4