Phone 1-866-278-6243
Free Trial Free Trial Schedule a Demo Schedule a Demo

Using UPS World Ship with All Orders

Using UPS World Ship with All Orders

All Orders 4.X
All Orders 5.X

On the machine having your UPS World Ship please perform the following steps.

STEP 1 - CREATE ODBC SOURCE

  1. Click the Start Menu.

  2. Click Settings/Control Panel.

  3. Double click ODBC data sources icon (found under Administrative Tool in Windows XP) to open the ODBC Data Source Administrator.

  4. Click on the System DSN tab.

  5. Click the Add button.

  6. Select SQL Server from the list of drivers and click Finish.

  7. For Name enter AllOrders4 and Select the server that contains your All Orders 4 database e.g. SERVER\ALLORDERS then click Next>

  8. Click Next > to accept Windows NT authentication

  9. Change the default database from 'master' to the name of your MDF file and click Next >

  10. Click Finished

STEP 2 - CREATE IMPORT MAPPING

  1. Start UPS World Ship

  2. Click UPS Online Connect

  3. Select Create or Edit and import or export map

  4. Click Import from ODBC Database radio button

  5. Enter a Name

  6. Click Create

  7. Select the ODBC Source created in step 1 and press OK

  8. The All Orders tables are on the left and world ship tables are on the right.

  9. Click one from each side and click connect as follows:

 

All Orders

WorldShip

qryShippingAddresses :  Zip

Ship To:  Postal/ZIP Code

qryShippingAddresses :  Weight

Package : Weight

qryShippingAddresses :  State

Ship To:  State / Prov

qryShippingAddresses :  ShipMethod

Shipment Information: Service Type

qryShippingAddresses :  Phone

Ship To:  Phone

qryShippingAddresses :  NCRef *

Package : Reference 1

qryShippingAddresses :  Fax

Ship To:  Fax Number

qryShippingAddresses :  Country

Ship To:  Country

qryShippingAddresses :  Contact

Ship To:  Attention

qryShippingAddresses :  Company Name

Ship To:  Company or Name

qryShippingAddresses :  City

Ship To:  City

qryShippingAddresses :  Addr3

Ship To:  Room/Floor/Address 2

qryShippingAddresses :  Addr2

Ship To:  Street Address

* NCRef Must be mapped but not necessarily to Reference 1

STEP 3 - CREATE EXPORT MAPPING (optional)

If you want All Orders to update your ship doc with the Tracking # please create an export mapping as follows:

  1. Start UPS World Ship

  2. Click UPS Online Connect

  3. Select Create or Edit and import or export map

  4. Click Export data from WorldShip radio button

  5. Enter a Name

  6. Click Create

  7. Select the ODBC Source created in step 1 and press OK

  8. The All Orders tables are on the right and WorldShip tables are on the Left.

  9. Click one from each side and click connect as follows:

 

WorldShip

All Orders

Package : Weight

tblShippingPackages : Weight

Package : TrackingNumber

tblShippingPackages : TrackingNo

Package : Reference1

tblShippingPackages : NCRef

Package : Cost

tblShippingPackages : Cost

 

STEP 4 - USING KEY IMPORT (optional)

Using the keyed import is a great way to process shippment.

  1. Open UPS World Ship

  2. Select from the menu UPS Online Connect --> Keyed Import --> more...  then select the import map created above (you only have to do this the first time thereafter it will be part of the menu)

  3. When you select Keyed Import you will see a small box which you can type in the UPS Reference comprised of TranType and Doc No. For example:  Shipping-39893 (Hint: you can also bar code this field and scan it!)

  4. Press OK

  5. Process the shipment as usual

  6. Select from the menu UPS Online Connect --> Automatically Export After ...  --> more...  then select export map created above (you only have to do this the first time thereafter it will be part of the menu)

     

 

1/15/2007



Call Cruncher
More questions?

Call to speak with a NumberCruncher Solutions Consultant at:

call us