UPS

 
Help Importing Batch Shipping Files
Batch File Shipping Help
Batch File Shipping enables you to create up to 250 shipments using a .csv (comma separated value) or.ssv (semicolon separated value) file format. The origin address must be the same for all the shipments but the destination addresses can be different.

The table below contains a sample file for your reference.
File Name
File Format
Date Created
Download
Sample File
Text File
08/19/2013


Batch File Import Format
Note: The import file uses a comma/semicolon as the field delimiter. The import file must include the comma/semicolon delimiter, even for optional fields. Column headers should not be included.

If a particular record fails validation during the import, the system will create an error file with the records that the system could not import. Review the report and make any corrections necessary. Once the errors have been resolved, try the import process again.

Batch File Import Format
The Batch File Import format contains a .csv/.ssv extension.
Field Name
Field Type
Maximum Field Length
Required
Valid Values
Contact Name
Alphanumeric
35
Yes (for an international movement or a UPS Next Day Air Early AM service)
Name of recipient (# entered in front of the first field results in an error)
Company or Name
Alphanumeric
35
Yes
Company or name of recipient
Country
Alphanumeric
2
Yes
Recipient's country. See Country Code table for valid codes.
Address 1
Alphanumeric
35
Yes
Address 1 for recipient (required)
Address 2
Alphanumeric
35
No
Address 2 for recipient (optional)
Address 3
Alphanumeric
35
No
Address 3 for recipient (optional)
City
Alphanumeric
30
Yes
Recipient's city
State/Province/Other
Alphanumeric
30
Conditional
Required for certain destination countries. See State/Province code table for valid codes.
Postal Code
Alphanumeric
10
Conditional
Required for certain destination countries.
Telephone
Alphanumeric
15
Conditional
Required for international destinations and UPS Next Day Air Early A.M. service.
Extension
Alphanumeric
5
No
Recipient's telephone extension
Residential Indicator
0/1
1
No
1=Residential; 0=Commercial
E-mail address
Alphanumeric
50
No
Recipient's e-mail address
Packaging Type
Alphanumeric
2
Yes
See Packaging Type table for valid codes.
Customs Value
Numeric
15
Conditional
Required from US to CA and US to PR movements. Currency defaults to USD. Decimals allowed.
Weight
Numeric
5
Conditional
Required for a packaging type of Other Packaging = 2. Weights are accepted optionally for a packaging type of Letter/Envelope. Use commas in numeric fields, such as weights (10,0) they would have to encase that field in double - quotation marks.
Length
Numeric
4
No
Defaults to inches for US/PR; centimeters everywhere else. CA has choice between inches and centimeters.
Width
Numeric
4
No
Defaults to inches for US/PR; centimeters everywhere else. CA has choice between inches and centimeters.
Height
Numeric
4
No
Defaults to inches for US/PR; centimeters everywhere else. CA has choice between inches and centimeters.
Unit of Measure
LB/KG
2
Defaults to pounds/lbs. (US/PR) or kilograms/kgs. CA has choice between lbs./kgs.
Description of Goods
Alphanumeric
35
Conditional
Conditionally required when Ship To/Ship From countries are not the same.
Documents of No Commercial Value
0/1
1
No
Indicates the shipment does not contain any dutiable items.
GNIFC (Goods not in Free Circulation)
0/1
1
Conditional
Required for movements within the EU when the goods are dutiable.
Declared Value
Numeric
7
No
Must be less than 1000 USD or local equivalent if entered. Denominaton will default to the currency of the shipment origin country. UPS's liability for loss or damage to a package. No decimals allowed.
Service
Numeric
2
Yes
See Service table for valid values.
Delivery Confirmation
Alphanumeric
1
No
See Delivery Confirmation table for valid values.
Shipper Release/Deliver Wthout Signature
0/1
1
No
A shipper may request to UPS release a package on the first delivery attempt without a signature. UPS will not be liable to shippers or third parties for any damages arising from the release of the package. (Not supported outside of US)
Return of Document
0/1
1
No
Only used for Poland to Poland movements.
Deliver on Saturday
0/1
1
No
Available with select services. Refer to service guide for additional information.
UPS Carbon Neutral
0/1
1
No
Request the option to offset the climate impact of your shipment.
Large Package
0/1
1
No
Applied when length plus girth (2 * width) + (2* height) combined exceeds 130 inches, but is less than 165 inches. Surcharge accessed. (Outside of US, large package limit is 419cms.)
Additional Handling
Numeric
4
No
For US: Applied when an article is encased in an outside shipping container made of metal or wood, packages exceed 70 lbs. or 32 kg., longest side exceeds 150cm. Refer to service guide for additional information. Outside of US: If weight exceeds 32 kg. or the longest side exceeds 150cm then additional handling will be automatically supplied.
Reference 1
Alphanumeric
35
No
Used to record information about a package.
Reference 2
Alphanumeric
35
No
Used to record information about a package.
Reference 3
Alphanumeric
35
No
Only used in UPS CampusShip package level packaging (US, PR, and CA).
E-mail Notification 1 - Address
Alphanumeric
50
No
E-mail address that will receive the specified notification (ship, exception, or delivery).
E-mail Notification 1 - Ship
0/1
1
No
E-mail notification sent when the package is shipped.
E-mail Notification 1 - Exception
0/1
1
No
E-mail notification sent when there has been an exception in delivering the package.
E-mail Notification 1 - Delivery
0/1
1
No
E-mail notification sent upon package delivery.
E-mail Notification 2 - Address
Alphanumeric
50
No
E-mail address that will receive the specified notification (ship, exception, or delivery).
E-mail Notification 2 - Ship
0/1
1
No
E-mail notification sent when the package is shipped.
E-mail Notification 2 - Exception
0/1
1
No
E-mail notification sent when there has been an exception in delivering the package.
E-mail Notification 2 - Delivery
0/1
1
No
E-mail notification sent upon package delivery.
E-mail Notification 3 - Address
Alphanumeric
50
No
E-mail address that will receive the specified notification (ship, exception, or delivery).
E-mail Notification 3 - Ship
0/1
1
No
E-mail notification sent when the package is shipped.
E-mail Notification 3 - Exception
0/1
1
No
E-mail notification sent when there has been an exception in delivering the package.
E-mail Notification 3 - Delivery
0/1
1
No
E-mail notification sent upon package delivery.
E-mail Notification 4 - Address
Alphanumeric
50
No
E-mail address that will receive the specified notification (ship, exception, or delivery).
E-mail Notification 4 - Ship
0/1
1
No
E-mail notification sent when the package is shipped.
E-mail Notification 4 - Exception
0/1
1
No
E-mail notification sent when there has been an exception in delivering the package.
E-mail Notification 4 - Delivery
0/1
1
No
E-mail notification sent upon package delivery.
E-mail Notification 5 - Address
Alphanumeric
50
No
E-mail address that will receive the specified notification (ship, exception, or delivery).
E-mail Notification 5 - Ship
0/1
1
No
E-mail notification sent when the package is shipped.
E-mail Notification 5 - Exception
0/1
1
No
E-mail notification sent when there has been an exception in delivering the package.
E-mail Notification 5 - Delivery
0/1
1
No
E-mail notification sent upon package delivery.
E-mail Message
Alphanumeric
150
No
Additional messaging or special instructions to be provided in the e-mail notification.
E-mail Failure Address
Alphanumeric
50
No
E-mail address that will receive a notification if the e-mail notification to the recipient failed delivery.
UPS Premium Care
0/1
1
No
Enjoy peace of mind knowing that your regulated and sensitive shipments are compliant and secure. Only used for Canada to Canada movements.
 Back to Top

The Import Batch File Processing format contains a field named Packaging Type. The valid codes for this field are:

Packaging Type Codes
1=UPS Letter/Envelope
4=UPS PAK
3=UPS Tube
S=UPS Express Box (Small)
M=UPS Express Box (Medium)
L=UPS Express Box (Large)
21=UPS Box
25=UPS 10 KG Box
24=UPS 25 KG Box
2=Other Packaging
30=Pallet (valid only for PL to PL)
The Import Batch File Processing format contains a field named Service. The valid 2-digit codes for this field are:

Service Type Codes
14=UPS Next Day Air Early A.M. (US/PR)
54=UPS Express Plus
01=UPS Next Day Air (US/PR)
07=UPS Express
13=UPS Next Day Air Saver (US/PR)
08=UPS Expedited
59=UPS 2nd Day Air A.M. (US/PR)
11=UPS Standard
02=UPS 2nd Day Air (US/PR)
65=UPS Express Saver
12=UPS 3 Day Select
03=UPS Ground Service (US/PR)
82=UPS Today Standard (PL to PL)
83=UPS Dedicated Courier (PL to PL)
85=UPS Today Express (PL to PL)
86=UPS Today Express Saver (PL to PL)
The Import Batch File Processing format contains a field named Delivery Confirmation. If you do not want delivery confirmation leave the field blank, otherwise enter a valid code. The valid codes for this field are:

Delivery Confirmation Codes
S=Signature Required
N=Delivery Confirmation with No Signature
A=Adult Signature Required
V=Verbal Confirmation

 Back to Top
Download, View, and Print
Adobe Reader
If you have not already installed and configured the Adobe Reader® or plug-in, select the Get Adobe icon for further instructions.


Get Adobe Reader
Adobe, Adobe Reader, and the Adobe logo are trademarks of Adobe Systems Incorporated.

Next Steps
View codes for U.S. States, Canadian Provinces, and countries worldwide.



Close Window


Copyright © 1994-2014 United Parcel Service of America, Inc. All rights reserved.