DHL DB Connect Integration

Contents of this Topic: ShowHide

Overview

• Before you can ship packages via DHL with OMS you must install the DB Connect software, map Minimum Advertised Price; applies to Consumer Goods categories and listed on Amazon Seller Central Market the database fields between OMS and DB Connect, and lastly, create the export map.

• Contact DHL to obtain the DB Connect software.

• After performing the tasks below you will be able to do a Keyed Import via the "Search For" field for orders that are Approved.

Install DB Connect

1.  Locate DB Connect in the c:\dhl\DBConnect\DbConnectSetup.msi directory.

2. Double-click on DBConnect.exe to launch the installation program.

3.  Right-click on Customer Database and click Add New Customer Database.

4.  Select to "left-click" the mouse on an object, usually a row in a table, in the context of Monsoon OMS documentation the DSN Data Source Name - associates a specific SQL Server, driver, and database together in a connection string used to access the data. that points to the OMS data file. See the Knowledge Base topic, Creating ODBC Connections for more information.

5. Under Actions, expand Read From Customer Database, then click Read Shipment.

6.  In the drop-down list under Customer Database, select the New Customer Database that you created previously.

7.  Click Next.

Map the Database Fields

1.  Click on the icon next to your customer database name.

2.  Select WorldShipOrders.

3.  Click on the plus (+) sign to expand WorldShipOrders.

4.  Select OrderNumber in the left hand column and CustomerShipmentId in the right-hand column.  Make foreign key. Then click the >> button.  Repeat this until all of the fields listed below are mapped:

·         WorldShipOrders.Shipping                        Service/1/ServiceType !!!needs shipping letter instead of name

·         WorldShipOrders.UPSCompanyorName    Consignee/CompanyName

·         WorldShipOrders.UPSAddr1                     Consignee/AddressLine/1

·         WorldShipOrders.UPSAddr2                     Consignee/AddressLine/2

·         WorldShipOrders.UPSCity                        Consignee/City

·         WorldShipOrders.UPSState                      Consignee/DivisionCode

·         WorldShipOrders.UPSZip                         Consignee/PostalCode

·         WorldShipOrders.UPSWeight                   ShipmentDetails/Weight

·         WorldShipOrders.UPSPhone                    Consignee/Contact/PhoneNumber

·         WorldShipOrders.UPSattention                 Consignee/Contact/personname

5.  Click Next.

6. Click Finish.

Create the Export Map

1. Click on Write Back Shipment.

2. In the drop down list under Customer Database, select the New Customer Database that you created above.

3. Click on the Magnifying Glass icon next to the database name and select Tracking.

4. Click OK.

5. Click Next.

6. Right-click Tracking. Choose Insert.

7. Click on the plus (+) sign to expand Tracking. Select Cost in the left hand column and ShippingCharge in the right-hand column. Then click the >> button. Repeat this until all of the fields listed below are mapped:

1. Tracking.OrderNum -- CustomerShipmentId

   Tracking.TrackingID -- ShipmentDetails/Pieces/Piece/AirwayBillNumber

   Tracking.Cost -- ShippingCharge

Note: If you don’t see the fields, click on the Magnifying Glass icon next to DHL Fields.

8. On the far right panel, check Search Key next to the Tracking.OrderNumber field.

9. Click Finish.

10. Click Save and Export on the File menu.

Turn on DB Connect via the .cfg File

1.  Locate the DB Connect configuration file, possibly at c:\dhl\client\cfg\dhlclient.cfg. If not found there, search for dhlclient.cfg.

2. Open the configuration file in Notepad or another text editor and locate the line:

  <Module name ="CustomerDB">

3. Make sure the properties shown in the image below are set to "on".

Turn on "Search For"

1. Select shipment and enter Order Number in "Search For" field

2. Go to Settings > User Preferences > Shipments > Apply Default Values to Imported Data.

3. Set Boolean Value to Yes.

4. Click Save.

5. Select Default Find Shipment By.
6. Set Choice to Shipment.
7. Click Save.

Additional Information

Creating ODBC Connections

Created:

Revised: 11/4/14

Published: 04/14/16