Welcome to WebmasterWorld Guest from

Forum Moderators: buckworks

Message Too Old, No Replies

UPS - Automate Order Processing with UPS WorldShip

Continuation of this thread



12:19 pm on Nov 8, 2007 (gmt 0)

5+ Year Member

Hi all,

The thread asking about OsCommerce has been closed so I have had to start a new thread to reply.

I'm the UPS CTSS technician for the South West and have been directed to this thread by an account manager.

I'm afraid I'm not too familiar with OsCommerce but there are many ways to integrate with Worldship 9.

* ODBC *
With an ODBC link a field mapping can be created between Worldship and the DBMS, e.g. Sage Accounts. A unique identifier is chosen, e.g. order number and an entry box appears when selected. Once setup (can take about 10 minutes if all goes well) the user would enter their search reference into the box and the field contents will populate directly into the Worldship fields based on the mapping. The shipment is then processed once weight/service etc is added on the screen.

ODBC can also be used to batch export data mainly used to write back subsequent tracking numbers etc. to a table which can then be interrogated back into a DBMS if matched up with order numbers for example.

* XML Auto Import *
I noticed a few people had this setup on the closed thread. Worldship can be set to poll a directory of your choice, as soon as an .XML file is written (by your system, normally at the order process stage) to this location Worldship automatically reads and processes churning out a label. This is a completely automated solution as the only Worldship user interaction would be to set it running in the morning. Worldship then renames the .XML file to .#*$! and creates an .OUT file containing the original code and a process message with either the tracking number(s) or a field specific error message.

* Batch Import/Export *
A field mapping can be created much the same way with ODBC but from or to a file, for example, .CSV. If importing shipment data you can set to print the labels upon importation if all mandatory fields are imported (have a blue field title in Worldship) otherwise you can still import if you only have an address but will have to go into the 'History' tab and reconcile them from an 'Imported Shipments' folder to manually add the remaining shipment data before processing. The batch import/export can be set to initiate manually or automatically after processing each shipment or at the end of day.

If anyone who ships with UPS would like assistance with doing this please contact your UPS Account Manager, otherwise I will be monitoring this thread if you wish to add anything.



7:29 pm on Nov 8, 2007 (gmt 0)

5+ Year Member

Thank you for posting!

I'm drooling at the idea of XML Auto-Import, I had tried to setup .csv batch importing a while back but unfortunately not all account managers are created equal and I have gotten more information out of your one post then in 4 years from my account manager.

Where can I get a list of the XML parameters, particularly what is the minimum for a shipment and optional?



7:47 pm on Nov 8, 2007 (gmt 0)

5+ Year Member

If you can supply an email address I will send you the Document Type Definition XML schema (this is automatically copied to the XML Auto Import folder you designate by Worldship. Its called openshipments.xdr. I can also send you a sample .XML file ready to go using the minimum fields. You'll find having a profile set in Worldship will cover some defaults you wish to keep the same.

With regards to OsCommerce (and others alike), I hear it has a UPS shipping module built in. In this case it is more than likely to be a tool we call XML Shipping. This is where there is no need for Worldship because the DBMS uses the UPS shipping module then sends an XML message to UPS's back-end, then UPS sends an XML reply with code creating the subsequent label. This is most useful to large scale operations who want to completely use their systems in the shipping process with communication on the back end.

Other online tools include Tracking, Rates & Services, Time in Transit. These are available to display this data from a 3rd parties website and therefore not directing web traffic away from your website, not to mention making things look more professional.

In the original thread I read that someone had been told XML Auto Import may be discontinued as a function. This wont happen simply because its such a popular and effective way to completely automate the shipping process.

Any other questions welcome.



9:16 pm on Nov 8, 2007 (gmt 0)

5+ Year Member

Thanks Alex, I have sent you a private message with my email address.

I have already integrated the online tools into our website and have all of that working fine. Online orders are only a portion of our shipping so importing online orders, either automatically or via a batch, into our WorldShip is the most logical answer.



4:56 am on Apr 29, 2008 (gmt 0)

5+ Year Member

Hi Alex,

I was just reading your post.

I have one query regarding this.

Basically i am also using UPS Worldship Software version 10 for my shipments.

After generating tracking number i want to run a php or any other script which export a "CSV" file from UPS after end of the day about the details of all Tracking numbers for the same day.

and it will upload the file on our server.

Currently, i am exporting the .csv file after click on "End of the Day" button and through script i am uploading this CSV file to my server, but if anybody click two times on "End of the Day" link in a same day then it will overwriting the existing file with new one.

And when my script upload the file to server then it will contain only partial information.

So that is there any solution that i could batch export the "CSV" file automaticaly for the complete day with help of auto run of any script like schedule a script for a particular time and it will export the information from UPS Worldship Software and save a "CSV" file.

Waiting for your reply.

Thanks in advance,


12:36 am on May 10, 2008 (gmt 0)

5+ Year Member

Please use task scheduler under the Tolls menu. You can schedule to export the entire previous day of shipping. Post here if you still have problems.


10:08 am on Jul 24, 2008 (gmt 0)

10+ Year Member

is there any indication as to whether ups will be partnering with shipworks.com to provide a I'm solution. Shipworks is amazing for ebay sellers and also integrates with zen cartxand oscommerce. But they do not support the uk....bummer. This would be all my dreams come true!

Featured Threads

Hot Threads This Week

Hot Threads This Month