Mailing List Archive: Interchange: users

UPS Worldship Integration

Index | Next | Previous | View Threaded

icdev at mrlock

Apr 28, 2008, 9:01 AM

Post #1 of 7 (228 views)
Permalink

UPS Worldship Integration

Has anyone integrated IC with UPS Worldship?

Steve

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ron at endpoint

Apr 28, 2008, 9:14 AM

Post #2 of 7 (218 views)
Permalink

Re: UPS Worldship Integration [In reply to]

Steve Graham wrote:
> Has anyone integrated IC with UPS Worldship?
>
> Steve
>
>

Hello Steve,

I've implemented UPS Worldship integration with 2 of my clients, 1 through the use of the import/export files mechanism, the other using ODBC talking directly to the database.

In the first scenario orders are marked as ready to ship, an export is run and all of the relevant info is exported. This file is then downloaded and imported into the Worldship application. The orders are processed as they are packaged. Worldship then spits out a file with order numbers and tracking numbers which we import back into the Interchange database. The import/export on the Interchange side uses perl to read/write those files. The importing of tracking numbers also kicks off a shipped email to the user and changes the status to shipped.

In the second scenario orders are marked as ready to ship, an import is ran on the Worldship side that contacts the database over ODBC and gets a list of orders and the relevant information. The orders are processed as they are packaged. Worldship then contacts the Interchange database over ODBC and writes the tracking numbers. The updating of tracking numbers kicks off the same shipped email.

The key to doing these integrations is setting statuses to control what gets exported and then decide what to do once a tracking number is imported. If you have a choice between the methods I would choose scenario 2, it's less steps and seems like a more "cleaner" process.

Thanks,

--
Ron Phipps
End Point Corporation
ron[at]endpoint.com

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

richard at endpoint

Apr 28, 2008, 9:24 AM

Post #3 of 7 (217 views)
Permalink

Re: UPS Worldship Integration [In reply to]

Steve Graham wrote:
> Has anyone integrated IC with UPS Worldship?
>
> Steve
>
>
>
>
Steve,

I've done an integration to UPS Worldship. You can setup Worldship to
connect to a remote database through an ODBC connection to get it's
shipping information for an order. You can then setup a simple route to
log the information into a database table for the ODBC connection to
read from.

Richard Templet
End Point Corp.

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

marty at dripdepot

Apr 28, 2008, 9:35 AM

Post #4 of 7 (219 views)
Permalink

Re: UPS Worldship Integration [In reply to]

Steve Graham wrote:
> Has anyone integrated IC with UPS Worldship?
>
> Steve
>
>
Yep. We use the ODBC capabilities of Worldship and setup and
import/export map. We created an abstraction layer that loads all the
pending orders into a special database table with all the information
needed by Worldship, most of the logic happens at this stage. Then we
use the keyed import field via Code 128 barcode printed on each packing
slip and scan that into worldship. Worldship then reads the table
information and loads all of the necessary fields. All the operator has
to do is enter box dimensions and hit F10 to process.

It works pretty good. And we use that same table to load Fedex
Shipmanager and also Endicia galaxy ship info. So we can process USPS,
UPS and Fedex with very little operator interaction.

Marty Tennison
dripdepot.com

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

icdev at mrlock

Apr 28, 2008, 9:44 AM

Post #5 of 7 (220 views)
Permalink

Re: UPS Worldship Integration [In reply to]

>
>In the second scenario orders are marked as ready to ship, an import
>is ran on the Worldship side that contacts the database over ODBC
>and gets a list of orders and the relevant information. The orders
>are processed as they are packaged. Worldship then contacts the
>Interchange database over ODBC and writes the tracking numbers. The
>updating of tracking numbers kicks off the same shipped email.
>
>The key to doing these integrations is setting statuses to control
>what gets exported and then decide what to do once a tracking number
>is imported. If you have a choice between the methods I would
>choose scenario 2, it's less steps and seems like a more "cleaner" process.

Thanks for both Endpoint replies.

I was just reviewing the connection/import feature within worldship,
and I think it will be better having worldship talk through and ODBC
connection to the MySql database. I'll try to document this as I go.

regards,
Steve

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

icdev at mrlock

Apr 28, 2008, 10:49 AM

Post #6 of 7 (217 views)
Permalink

Re: UPS Worldship Integration [In reply to]

>Yep. We use the ODBC capabilities of Worldship and setup and
>import/export map. We created an abstraction layer that loads all the
>pending orders into a special database table with all the information
>needed by Worldship, most of the logic happens at this stage. Then we
>use the keyed import field via Code 128 barcode printed on each packing
>slip and scan that into worldship. Worldship then reads the table
>information and loads all of the necessary fields. All the operator has
>to do is enter box dimensions and hit F10 to process.
>
>It works pretty good. And we use that same table to load Fedex
>Shipmanager and also Endicia galaxy ship info. So we can process USPS,
>UPS and Fedex with very little operator interaction.
>
>Marty Tennison
>dripdepot.com

Thanks Marty,

Sounds nice.

Hooking Worldship to the Mysql database was easy enough. I just need
to create a new table for Worldship to talk to and I should be good to go.

-Steve

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

icdev at mrlock

May 6, 2008, 9:50 AM

Post #7 of 7 (189 views)
Permalink

Re: UPS Worldship Integration [In reply to]

>
>I was just reviewing the connection/import feature within worldship,
>and I think it will be better having worldship talk through and ODBC
>connection to the MySql database. I'll try to document this as I go.

For some reason UPS Worldship doesn't like talking to the MySQL
server using ODBC Connector 5.1.4. I didn't try any other versions.

I created a MS Access table/database to temporarily copy order
information, UPS Worldship can read this access file - some of the
back office php programs can read the MySql database and write to the
Access file using odbtp ODBC connector for MS Windows.

Not as clean as I would like, but it works.... now to get rid of some
of those php programs.....

Steve

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com