<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

UPS Shipping Automation with Worldship

Published on
14,245 Points
11,045 Views
2 Endorsements
Last Modified:
If you are a UPS customer making use of the label software 'WorldShip', you may not be aware of functionality available to automate your shipping.  This can be setup in the form of a live link to your ordering system, where you key, for example, an order number and automatically populate the ship to address (and potential other pertinent data) into WorldShip.  Alternatively, if you don't have direct access for integration but can export your shipment data into a comma separated file (e.g. .csv) or to XML, WorldShip can process shipments from files automatically also.

The idea is that all the shipment data has already been collected and stored in your order management system and your picking/packing staff are duplicating this work by key-entering this into the shipping software, consuming time and leaving room for human error.  The method that works best for you will depend on how configurable your system is and how much shipment data it stores.  For example if you have an off the shelf ordering system that only holds a delivery address, then we may be able to map fields to the database and pull this detail when processing shipments so users can finalize other detail like shipment options; if your system holds data like weight, no. of cartons to ship on an order, etc., then it may be possible to fully automate your label printing.


If you are interested in looking further into this...
 

1. Automation Methods available with UPS WorldShip

Based on your order management / ERP system's capabilities, the below methods can be used to automate labels.
 
ODBC
If your database management / ERP system has an ODBC link (such as Sage
Accounts), WorldShip can connect via this link and use a connection wizard that
will allow us to create a field mapping between the systems. We can then
nominate a unique identifier so by entering an order number the address will
populate directly into the WorldShip screen.

XML
If your system can write XML files containing order information,
WorldShip can be set to poll a directory, pick up any XML files written at any
time and process the shipments automatically. The only WorldShip operation would
be to start the software up and close it down.

Below is an example XML file that will process a UPS label automatically:


File Import
WorldShip can be mapped to CSV headers (or other separated
files) containing address and/or shipment information and a user can then select
the mapping and choose to import as shipments. This can then be processed in
bulk as a batch import, one by one by use of primary key, or by monitoring the
file for new entries and then process the shipments when they are added.

Example CSV Import file:
csvimport.csv
 

2. Automation Process Options

The following are options within the UPS WorldShip software that make use of the above automation methods.
Keyed Import
Mapping to a data source so a shipment record can be pulled by unique identifier
and populate on the shipping screen. This allows for further amendments, e.g.
weight / service level etc. to be finalized before processing the shipment.

Batch Import
Mapping to a data source and importing all records 'on batch' to either a
history folder for reconciliation or, if all shipment data is present, to print
all labels upon the import request.

Hands Off Shipping
Mapping to a data source that will be continuously monitored, shipments will be
processed automatically when new records are written.

XML Auto Import
WorldShip is set to poll a directory and automatically processes new shipments
when their XML files are written to this location.


Customer Technology Sales Support technicians employed by UPS are responsible for implementing these solutions and will be available via your sales representatives so please request their presence should you wish to take automation further; for assistance but also because this process needs to be logged for future support requirements.  There is no extra cost involved with their assistance in discussing and implementing automations with WorldShip; however, there may be a development requirement for yourselves should you plan on adding functionality to export data from your system (e.g., via XML), if that function doesn't already exist.

On the other hand, most of the time an ODBC integration is fairly straight-forward, and, because no development work is needed on your side, there is no cost and normally can be setup same day fairly quickly.  Also note that your ERP software provider may have developed UPS automation functionality for some of their customers already; therefore, they are a good resource to be able to supply this function as a 'bolt on' for a lower cost than it would be to have it developed by yourself or a third-party.

Hopefully you found this helpful and enjoy your new found knowledge of WorldShip automation.


Disclaimer: the author is employed by UPS as a field based technical specialist implementing these solutions.  His comments are his own and are not to be considered as the official statements of UPS.


Related Information / References

Q&A (unofficial)
2
Author:Alex_W
4 Comments
LVL 1

Expert Comment

by:aknasinski
Author referred to a sample XML file which was not attached.  I have attached a sample WorldShip XML import file.

 openshipment.xml
0

Expert Comment

by:test test
We are using UPS XML auto import and we need to create multiple packages with different weight, height, width and length in 1 shipment.

How to Create Multiple packages in 1 shipment.

We have created one xml file but its not working.

Can anyone help us.

Thanks in advance,sample_xml.xml
0
LVL 8

Author Comment

by:Alex_W
Hi, please use the following guide:

https://www.ups.com/media/en/autoimportxml_quickstart.pdf

Check your XML files against the schema stored in the installation directory:

..\UPS\WSTD\OpenShipments.xdr

If you're still stuck you can always contact your sales rep or the call center who can put you in touch with an integrations technician for assistance.
0

Expert Comment

by:test test
..\UPS\WSTD\OpenShipments.xdr

This already installed.

We are using UPS XML auto import. We need to create multiple packages with different weight, height, width and length in 1 shipment.

e.g. If I am sending 2 boxes for 1 order# 1234 using different weight, height, weight and length as given below,

============================================
Package# | weight | Height | Width | Length |
============================================
    1    |    1   |    2   |   3   |   4    |
    2    |    5   |    6   |   7   |   8    |
============================================

So can you please suggest/help us, how to create multiple packages in 1 shipment with different tracking numbers.

We have created one .xml file but its not working properly.

Please see the attached our sample_xml.xml file for more information.

Thanks and Regards,
0

Featured Post

The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month