How to Setup Galaxy Ship to Interface with the Order Manager

Overview

Galaxy Ship by Endicia can be used as a bridge between the Order Manager's database (data file) and DAZzle, Endicia's label and postage printing application. The merchant must have an Endicia Professional service plan to use Galaxy Ship.

This article assumes that Galaxy Ship has been installed on a workstation where the Order Manager is also installed. The installation of Galaxy Ship is outside the scope of this document. For more installation information, please refer to the vendor's documentation, http://endicia.com/endicia-usa/hot/galaxyusersguide.cfm.

Galaxy Ship reads shipping address data from the Order Manager database and allows the merchant to select the desired weight, mail class, and optional services. When the label is printed, Galaxy Ship passes the information to DAZzle, which processes the postage transaction via the Endicia servers.

The Order Manager is capable of interfacing with Endicia's DAZzle without the need for Galaxy Ship. Refer to the  Setup Wizard 5.9 or the Legacy Setup Wizard as well the knowledge base article about DAZzle.

Link to official Galaxy Ship Documentation

The instructions in this article for creating the Source Data Map and Post Back Data Map to transfer data between the Order Manager and Galaxy Ship show the minimal requirements for each map. The user can map additional fields as needed and may be able to exploit other features of Galaxy Ship that are not within the scope of this document. For more detailed information, please refer to the vendor's documentation, http://endicia.com/endicia-usa/hot/galaxyusersguide.cfm.

Create or Identify an Existing ODBC Connection to the Order Manager Data File

Creating an Intermediate Microsoft Access Database

Create the Source Data Map in Galaxy Ship

The Source Data Map is the connection between the Order Manager's data file and Galaxy Ship's fields.

 

  1. Open Galaxy Ship's Preferences dialog (File menu | Preferences). Click the Database tab.

  2. Click the Edit Source Data Map button. A new dialog opens where you can connect Galaxy Ship's fields to the fields in your database:

  3. First, click the Select button at the top, next to the ODBC Data Source box. On the dialog, select the DSN that connects to the Order Manager's data file. (It was identified or created in the previous section of this article.)

  4. Click OK to close the dialog.

  5. Next, click the Select button next to the Table box. Select WorldShipOrders

  6. Click OK to close the dialog.

  7. Click the Select button next to the Reference ID box:

  8. Select OrderNumber.

  9. Connect other fields as needed. Many of the fields are optional; the only required fields are Reference ID and the address fields. Refer to the vendor's documentation for more information.

 

The following two figures demonstrate an example of how to map some of Order Manager's address fields to some of Galaxy Ship's address fields that appear on the Package Details and Recipient Address tabs of the Source Data Map screen:

 

  1. Click OK when finished mapping fields, and then click OK on the Preferences dialog to close it. Proceed to the next section.

Test Galaxy Ship's ability to pull shipping addresses from the Order Manager Data File

Enter an order number on the main Galaxy Ship window in the Reference ID box. Hit the Enter key or click the Process button. If all is well, Galaxy Ship will pull the shipping address from the Order Manager's data file and ZIP+4 verify it. The verified address will appear in the Shipping Address box. Proceed with the next section.

Post-Back Database Map

The post-back feature updates the Order Manager's data file (database) with shipment data, such as tracking data. The post-back map controls which fields Galaxy Ship will write back to the Order Manager's data file after a shipping label has been printed.

Creating the Post-Back Database Map
  1. Click the Edit Post-Back Data Map button. The process for connecting the fields is similar to the Source Data Map above.

  2. Click the Select button at the top, next to the ODBC Data Source box. On the dialog, select the appropriate DSN for the Order Manager's data file.

  3. Click OK to close the dialog.

  4. Next, click the Select button next to the Table box. Select Tracking.

  5. Click OK to close the dialog.

  6. Click the Select button next to the Reference ID box:

  7. Select OrderNum.

  8. Connect other fields as needed. See the vendor's documentation for more information.

  9. Click OK when done, and then click OK on the Preferences dialog to close it.

 

Galaxy Ship field

Order Manager Field

Reference ID

OrderNum

Tracking Number

TrackingID

Postmark Date

PickupDate

Postage Amount

 

Cost

 

 

 

Test the Posting Back of Data

Verify the post-back feature by printing a test label and manually posting it back to the Order Manager's database.

Before verifying the post-back feature, do the following:

The following steps describe how to verify the Post-Back feature:

  1. Display a shipping address:

  1. On the Order Lookup tab, enter an order number in the Order Number field. The field that is to the left of the Retrieve Order button is the Order Number field.

  1. The order number can be an order number, invoice number, or something else, depending on which database field was connected to the Galaxy Ship Order Number field. The order number must be unique.

  1. Click the Retrieve Order button. The shipping address appears.

  1. Select File > Test Print Label.

  2. Open the Post-Back Data window by selecting Tools > Post-Back Data.

  3. Click the left edge of the grid to highlight a record, or click the Select All button.

  4. Click the Post Selected button.

Enable the automatic post-back feature

  1. Select Tools > Post Back Data.

  2. Select Options.

  3. The Post-Back Options dialog box appears.

  4. Select the Automatically post-back data check box.

  5. Click OK.

Link to official Galaxy Ship Documentation

The instructions in this article for creating the Source Data Map and Post Back Data Map to transfer data between the Order Manager and Galaxy Ship show the minimal requirements for each map. To map additional fields or for more detailed information about Galaxy Ship, please refer to the vendor's documentation, which can be found at http://endicia.com/endicia-usa/hot/galaxyusersguide.cfm.

 

Updated: 12/21/09

Modified 4/29/10