UPS

If you search old posts, I have posted a very effective connection method using the import/export features of WorldShip and adding a table to the RMS database..

You could also try ShipRush for UPS by

it has all the funtionality as WorldShip but integrates directly into RMS. They have a video demo of the product here: $195 a fair price as well. Rob

root,

Easy on 'em, I can't find your post either, if it had WorldShip or UPS in the text.

Mind re-posting?

i'll be..

I will re-post later today. sorry bout that.

You must first create a Datasource pointing to your RMS database. UPS Online WorldShip will use this datasource to connect to your RMS database to Import and Export shipment data based on your RMS Transaction Number.

Then you will need to connect to your RMS database using the Store Operation Administrator and run the following SQL statement which will create a table named TrackingNumbers and create a trigger in that table. This table is where the WorldShip information gets sent to. When you do an Export in WorldShip the table gets populated with the tracking information and the trigger will send it to the Shipping table and mark the shipment as processed

CREATE TABLE TrackingNumbers (TransactionNumber BIGINT, TrackingNumber NVARCHAR(255), NetShipCost FLOAT, DateProcessed DateTime DEFAULT CURRENT_TIMESTAMP);

CREATE TRIGGER update_tracking_trigger On dbo.TrackingNumbers For Insert, Update AS UPDATE Shipping SET Shipping.TrackingNumber = TrackingNumbers.TrackingNumber, Shipping.Status = '1', Shipping.DateProcessed TrackingNumbers.DateProcessed, Shipping.NetShipCost TrackingNumbers.NetShipCost FROM Shipping INNER JOIN TrackingNumbers ON Shipping.TransactionNumber TrackingNumbers.TransactionNumber; DELETE FROM TrackingNumbers

Now you must start WorldShip and create a new import map using the newly created datasource. Map type = shipment. There is ample information in WorldShip describing the procedure so I will keep this part short. Once you have connected to your RMS database you will need to match the fields and define the TransacionNumber as the Key Field. This is a basic configuration:

ODBC Tables: WorldShip fields: Shipping:Zip ShipTo:Postal/Zip Code Shipping:TransactionNumber Package:Reference 1 Shipping:TotalWeight Package:Weight Shipping:State Ship To:State Shipping:ServiceName Shipment Information:Service Type Shipping:PhoneNumber Ship To:Telephone Shipping:Name Ship To:Company or Name Shipping:Country Ship To:Country Shipping:Company Ship To:Attention Shipping:City Ship To:City Shipping:Address Ship To:Street Address Shipping:Address2 Ship To:Room/Floor/Address 2

Now you must create a new export map using the same datasource. Map Type shipment. Use the following configuration:

WorldShip fields: ODBC tables: Shipment Information:Total Shipper Charge TrackingNumbers:NetShipCost Package:Tracking Number TrackingNumbers:TrackingNumber Package:Reference 1 TrackingNumbers:TransactionNumber

You are done! Unless I forgot something :)

To use:

1. Exit and Re-Start WorldShip
2. Set your default export setting by going to the UPS OnLine Connect menu and choosing one of the options (during end of day, or after each shipment) and selecting your newly created export map. You may have to click ...more...to see it.
3. Select UPS OnLine Connect | Keyed Import | name of your import map
4. This will bring up a box that say Enter Import Key. Enter the Transaction Number of the order you would like to ship.
5. Process your package......
6. After all packages are processed, do an UPS End of Day
7. Your shipment info should be automatically sent to RMS and ready to track..

I always seem to forget something when I post.. If you are comfortable with these types of procedures, all of this will fall into place as you proceed. If you are skeptical and unsure, you can post some follow questions, but please note I will be away from the computer quite often for the next several weeks...