UPS worldship interface - abcsoftware/abc-docs GitHub Wiki

Setting up interface betwen UPS Worldship and ABC

Contact dealer to install the UPS addon module.

These instructions are for ABC version 13 and later.

  1. Run ABC Client; on B,C,E,J,N,R, or V screen hit Alt+U to create C:\Documents\My ABC Files\UPS.csv
  2. Start UPS Worldship, click "Import-Export," click "Tools," and then click "Connection assistant."
  3. Choose "Create a new map for import," and then click "Next."
  4. Choose type of import data as "Shipment," and then click "Next."
  5. Click "By File," and then "Browse," and then choose files of type text files (*.txt, *.csv). Browse until you find Documents\My ABC Files\UPS.csv, and then click "Open."
  6. On lower part of screen choose "Microsoft text driver for txt/csv."
  7. Type "ABC" for the DSN. Click "Next."
  8. Select "New map," set name to "ABC," and click "Next" and then "Finish."
  9. On "ODBC text setup," click "OK." and then on "Edit import map screen" change Worldship fields header to "SHIPTO" on right-hand column. The left column should be set to "UPS.CSV" with fields filled in.
  10. Select "Code" on left and "Customer ID" on right and click both the button for "Define primary key for import" and then "Connect."
  11. Select remaining matching fields on each column and click "Connect."
  12. All fields on "UPS.CSV" column should be matched with exception of "File," "PO" and "Reference."
  13. Next set right-hand column to "PACKAGE" and connect "Reference" in the left column with "Reference 1" in the right column.
  14. Next connect "PO" in the left column with "Reference 2" in the right column.
  15. Click "OK," and answer "No" to the "Batch import now."
  16. Go to "Import-Export," click "Keyed import," and click on "More," and then choose the ABC map and click on "Import." Click Close.
  17. Verify that "ABC" is listed under "Keyed import 1."
  18. Under the Tools > System preferences > Shipping tab, verify that "Always update address book" is unchecked.
  19. Under the Tools > System preferences > System Settings tab, uncheck "Show Help Topic at Startup."
  20. On the main shipment screen, uncheck "Update Address Book."

Exports

  1. Choose "Import-Export," then "Automatic Export," then "Export After Shipment Processing," and then "More."
  2. Click "Create/Edit map."
  3. Check "Export CSV."
  4. In the dropdown, choose "Shipment."
  5. Type "UPStoABC" in the name, and then click "Create."
  6. In the shipment pane, choose the "Package" tab.
  7. Click "20 Reference 1" and then click "Add."
  8. In the shipment pane, choose the "Shipment Information" tab.
  9. Click "231 Total Shipment and Handling Reference Charges," and then click "Add."
  10. In the shipment pane, choose the "Package" tab.
  11. Click "17 Tracking Number," and then click "Add."
  12. Click "21 Reference 2," and then click "Add."
  13. Click "Define CSV file name."
  14. Browse to C:\Documents\My ABC Files\UPStoABC.csv, and then click "Save."
  15. Make sure append to existing file is chosen, not overwrite existing file.
  16. Click OK, and then click Close.
  17. In the "Select map from list for export" window, choose UPStoABC, and then click "Export."

Notes on upgrading from a prior version

  1. Configure ODBC (these notes are for Windows XP).
  2. Click Control Panel > Administrative Tools > Data Sources (ODBC).
  3. Select ABC2UPS, click "Configure," click "Select directory." Navigate to "My Documents" and select "My ABC Files," and then click "OK," "OK."
  4. Select UPS2ABC click "Configure," click "Select directory,"; navigate to "My Documents" and select "My ABC Files," and then click "OK," "OK."
  5. From ABC, do an Alt+U to create My Documents/My ABC Files/UPS.csv.
  6. Update UPS Worldship import.
  7. Click Import/Export data > Keyed Import > More > Create/Edit Map.
  8. Select ABC2UPS, click "Edit."
  9. Connect "Email" on the left to "Ship To/Email Address" on the right.
  10. Connect "PO" on the left to "Package/Reference 2" on the right.
  11. Click "OK," "OK," and then close the window.
  12. Update UPS Worldship export.
  13. Click Import/Export data > Automatic export after processing shipment > More > Create/edit map.
  14. Select UPS2ABC, click "Edit."
  15. Click "Define CSV file name," navigate to My Documents/My ABC Files, select UPStoABC.csv, then click "Save."
  16. Click "OK," "OK," and then close the window.

NOTE: May need to restart UPS Worldship.