Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: buckworks
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.
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?
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.
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.
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,