Shipping Stamps.com
This feature is part of the Shipping Add-On, which is an additional module that enables ODBC-capable programs, such as Excel or Stamps.com Professional Shipper, to retrieve data from Big Business Server.
This Solution describes connecting from Stamps.com Professional Shipper. (6100)
The Shipping Add-On is an additional module that enables ODBC access to data in Big Business Server. This Solution describes using the ODBC capabilities of Stamps.com Professional Shipper to retrieve data from Big Business Server.
The prerequisites for this import are Registering the ODBC Add-On in Big Business Client, and creating a System DSN as described in earlier entries. Also, you must have the Professional Shipper version of the Stamps.com application (Stamps.com Enterprise, not Stamps.com Pro).
In the Stamps.com Enterprise application, create a new ODBC Profile:
1. From the Profile pull-down choose Manage Profiles
2. In the Manage Profiles window click New
3. On the Choose Datasource dialog choose ODBC and click Next
4. Name the new Profile (BB_Order) and click Next
5. Choose, Select an existing ODBC source, and click Next
6. Choose the ODBC Source (BB, created earlier)
7. Enter the Name and Password you assigned when Registering the ODBC Add-On and click Next
The Shipping Add-On is an additional module that enables ODBC access to data in Big Business Server. This Solution describes using the ODBC capabilities of Stamps.com Professional Shipper to retrieve data from Big Business Server.
This step follows, Step 1: Data Source, an earlier entry.
To Import data from the Sales Order in Big Business:
1. In the Database Table drop-down choose SO
2. On the Package tab, for Order ID choose SONo
3. On the Recipient tab, choose appropriate shipping fields, like ShipAddr1
4. When complete click Next
You can return to Edit your Profile later to add fields that you are unsure of now.
The Shipping Add-On is an additional module that enables ODBC access to data in Big Business Server. This Solution describes using the ODBC capabilities of Stamps.com Professional Shipper to post data back to Big Business Server.
This step follows, Step 2: Import Mapping, an earlier entry.
To Export data to the Sales Order in Big Business:
1. In the Post Back dialog choose, Same data source, and click Next
2. In the Database Table drop-down choose, SHIPINFO
3. On the Package tab, for Order ID choose, SO_Number
4. Choose target fields as appropriate and click Next
5. Enter Profile details and click Done
Refer to Fields for Writing, a later entry, for details on the available fields. It appears that Stamps.com only allows one target field for each, but again, you may return to Edit this profile later as needed.
Once complete, choose your new entry in the Profile drop-down, key a Sales Order number into the Order ID field, and click Get Order. When you Print postage, the Sales Order in Big Business will be updated.
Related: