PDA

View Full Version : Fields Reference for ShipRush for SQL Database



Justin80
03-14-2012, 09:05 AM
Hello all,

For ShipRush for SQL Database (both FedEx and UPS), I can't find which value need to be passed from our host to ShipRush to select collect “Service” and “PaymentType”. The document below doesn’t show which value ShipRush needs.

http://www.zfirm.com/Product_Documentation/ShipRush_v9-0_FedEx/Content/ShipRush_ADO__Fields_Reference.htm

For example, to select FedEx Standard Overnight, I don’t know if I need pass a value as “FedEx Standard Overnight”, “FedEx Standard Overnight®”, “Standard Overnight” or any other special code.

Is there any full list of values to select "Service" and "PaymentType"? I would like to get for both FedEx and UPS.

Thank you!

SYSOPS
03-14-2012, 09:29 AM
Here's the list of Service Names that SR is expecting:
http://www.zfirm.com/Product_Documentation/ShipRush_v9-0_FedEx/Content/Shipping_Service_Naming.htm
http://www.zfirm.com/Product_Documentation/ShipRush_v9-0_UPS/Content/Shipping_Service_Naming.htm

As far as PaymentType, your best option to seeing those values is to open a blank form for FedEx then UPS
Change the paymenttype
Click the little SR icon upper left, save current shipment to template
Save it to the desktop
Open that .zpk file in notepad
Locate this value: <ShipmentChgType>

That should be what ShipRush is expecting

HTH,
SYSOPS

Justin80
03-14-2012, 04:04 PM
Thank you for information. Shipping Service works well!

However, I'm still having a problem with "PaymentType". According to the template file, FEDEX Payment Types are as follows.
Sender = 'PRE'
Recipient = 'CBS'
Third Party = 'TPB'

If I pass 'CBS' to the ShipRush, I get the error message, "'CBS' is not a valid integer value. Please correct field "Payment Type" and retry."

It looks like I need pass a Integer. Do you know which number?

Thank you!

SYSOPS
03-15-2012, 06:34 AM
Let me see.

Sender = 0
Recipient = 1
Third Party = 3

If those work, please let me know so we can update the helpfile with valid options for that function.

SYSOPS

Justin80
03-15-2012, 09:26 AM
After my test, it looks like the followings.

0 = default (UPS:Prepaid, FedEx:Sender))
1 = Freigt Collect (UPS only. If I use it for FedEx it will be default (Sender))
2 = Recipient (FedEx only. If I use it for UPS it will be default (Prepaid))
3 = Third Party (UPS & FedEx)

Thank you for your advice!

SYSOPS
03-15-2012, 09:32 AM
Thank you for the update. I will try and get this added to the helpfile.

SYSOPS