Integration with UPS World Ship

You can buy shiprush from Z-firm and then you won't even have to install Worldship. They generate the UPS label.

Greg,

That may be a solution down the road, but for now, we really need to integrate these two programs. Shiprush looks like a great program as well as many of the items listed on the Z-firm website. I am a little leery of products listed online that you must call to get pricing information for.

-Erik

"Greg Williams" wrote:

Erik,

This can be done. Being the UPS World Ship export mapping does not allow for UPDATE (at least not that I know of) a new table must be created in the Store Operations database to export the data to. This new table must have a trigger that will update the records in the shipping table.

After this new table is created, you must create a datasource pointing to the Store Operations datatbase, and then create the import/export maps in UPS World Ship. The import map must get info from the shipping table (we use the Shipping.TransactionNumber as the Key field - this is the number you will enter in the import box to retreive the proper record in UPS World Ship when you are shipping) as well as any other pertinent fields that need to be filled, and the export map must export to the newly created table, which will in turn update the shipping table.

For this to work properly, the UPS shiping services you use in Store Operation must be named exactly as shown in the UPS World Ship software (ie.

Here is the SQL query to run on your database to create the table to export to called TrackingNumbers (backup and/or try this on a sample database first):

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

If you have questions, hit me back... If there is an better method I hope someone will share it.

Thanks Root,

Apparently my email notification of this board stopped working. This is exactly what we did. Works like a champ.

We also created an export in WS back to the table which puts the tracking numbers in the shipping table on RMS. How can we get the tracking numbers from the field to the URL for one-click tracking?

-Erik

"root" wrote:

Erik,

If you are referring to the Ctrl+Shft - F9 option in the POS, you will first have to go into the manager application and go to Database | Shipping Carriers and go to the properties for UPS. In the General tab in the Tracking URL box enter the following:

When you go to the POS application do a Shft+Ctrl -F9 and select an order to track, click the track button and a browser window will load. after the window loads, click the autofill button on the top left. This will populate the tracking number box. Then click the blue track button.

ta da

Root,

We tried your solution, but cannot get the Auto-Fill button to function in the internal browser. Is there a setting somewhere to activate this functionality?

-Erik

"root" wrote:

That is the only way that I know of to have it populate without typing it. (according to the SO help file) The only other way I can think of would be to use a variable for the tracking number in the URL, but I doubt that is supported by Store Ops.

You could always copy it from the shipment details and paste it into the tracking number box on the UPS site :(

Is the rest of the workflow working properly?? like the import, export, marking the shipment as processed, shipping method etc...? There must be a tracking number for the order in order for it to populate.

TrackingNumber