WebshipLink ODBC Bridge

After configuring WebshipLink with a Get Orders Query and an Update Shipment Status Query, it is possible to synchronize order and shipment information between Webship and an ODBC data source.

  1. Log in to Webship and select the gear icon to access the settings screen
    • Gear Icon
  2. Click eCommerce Integrations
    • Settings Menu Item
  3. At this page you can view and modify previous integrations. Since we are adding a new one, select Add eCommerce Integration
    • Add Ecommerce Button
  4. Click Webship ODBC
    • ODBC Integration Button
  5. Click Save New Integration
    • Save New Button
  6. Click Download WebshipLink Installer
  7. Install WebshipLink
  8. Copy the WebshipLink ODBC Token from the Webship ODBC Integration
    • Copy the ODBC Token
  9. Paste the WebshipLink ODBC Token into WebshipLink
    • Paste the ODBC Token
  10. Click Add ODBC in WebshipLink
    • Add ODBC Button

Composing Your ODBC Queries

WebshipLink is configured with two SQL queries. The first query is for loading orders into Webship from your ODBC data source and the second query is for updating your ODBC data source whenever new shipments are created from within Webship.

Authenticating with Microsoft SQL Server

If you are using Microsoft SQL Server and you are unable to authenticate, fill the ODBC Name field with the following format:

[ODBC connection name];Uid=[user id];Pwd=[password]

Example: WebShip2;Uid=123;Pwd=123

For more info see: Microsoft SQL Documentation