Shipping Integration archive

From Fishbowl
Jump to: navigation, search

The following information is for Fishbowl 2016.14 or earlier. For Fishbowl 2017 or later, click here.

The Small.Advanced ShipStation.png Advanced ShipStation module integrates with nearly all carriers and Fishbowl has a built-in Small.UPS Ready.png UPS Ready module. Fishbowl can also integrate with FedEx, UPS WorldShip, and Endicia by utilizing a technology called Open Database Connectivity or ODBC.

ODBC setup

Fishbowl runs on a database management system called Firebird. Firebird has an ODBC Driver (Open Database Connectivity) that allows other programs like FedEx, WorldShip, and Endicia to connect with the Fishbowl database. To set up the ODBC connection, complete the steps below on each computer that will be using a shipping application.

NOTE: On 64-bit computers, the ODBC can be configured using either the 32-bit or 64-bit driver. Because some third-party applications are only compatible with the 32-bit driver, the steps below outline the process for using the 32-bit driver.

  1. Locate the Firebird ODBC installer found inside the Fishbowl installation directory. Take note of the file location and the last two numbers of the filename which indicate whether you have a 32-bit or a 64-bit system.
    • 32-bit computer: Default location is C:\Program Files\Fishbowl\odbc\Firebird_ODBC_Win32.exe
    • 64-bit computer: Default location is C:\Program Files\Fishbowl\odbc\Firebird_ODBC_x64.exe
  2. Run the Firebird ODBC installer and complete the installation using the default settings.
  3. Open the ODBC Data Source Administrator window. If you are on a 64-bit system (you ran the 64-bit installer in step 1) it is important that you open the file referenced below, instead of the Control Panel.
    • 32-bit computer: Open the Control Panel, go to Administrative Tools, and then click Data Sources (ODBC)
    • 64-bit computer: Open C:\Windows\SysWOW64\odbcad32.exe
  4. Click the System DSN tab and then click the Add button.
  5. Select the Firebird/Interbase driver and then click Finish.
  6. A new Firebird ODBC Setup window will appear. Enter the following information in the appropriate fields. The fields are case-sensitive.
    Firebird ODBC setup.png
    • Data Source Name (DSN): Fishbowl
    • Database: This is the location of your company's Fishbowl database.
      • If you are setting up the ODBC on a Fishbowl Client computer, the path must include the computer name or IP address of the Fishbowl Server computer, for example: 192.168.1.10:C:\Program Files\Fishbowl\database\data\MYCOMPANY.FDB
      • When connecting to a Mac server, the file path will be slightly different. For example: 192.168.1.10:/Applications/Fishbowl/database/data/MYCOMPANY.FDB
      • If you are unable to establish on ODBC connection, you may need to open port 3050 on the server computer.
    • Client: Browse to the odbc folder inside the Fishbowl installation directory and select fbclient32.dll
      • 64-bit computer: If you do not have fbclient32.dll, you may download it here and then paste it in the odbc folder. You may also copy the file from the Fishbowl\database\odbc directory on the Server computer.
    • Database Account: GONE
    • Password: fishing
    • All other fields: No change necessary
  7. Click the Test Connection button to ensure you can connect to your database and then Click OK.

Click here for ODBC troubleshooting information.

FedEx integration

Follow the steps below to complete the FedEx Integration:

  1. Complete the ODBC setup.
  2. Install the latest version of FedEx Ship Manager. The installer can be downloaded by completing this form.
  3. Turn on the ability to show hidden files. (Windows 7 instructions)
  4. Download the .xml files for FedEx by clicking here. To download individual .xml files or to read an explanation of each file, see FedEx Ship Manager Mapping Files.
  5. Paste the .xml files into the FedEx Profiles folder. The location of the Profiles folder varies with different versions, but is typically in one of the following locations.
    • C:\ProgramData\FedEx\Integration\Profiles
    • C:\Documents and Settings\All Users\Application Data\FedEx\Integration\Profiles
  6. Open FedEx Ship Manager.
  7. Click the Integration menu and select FishbowlSingle.
  8. The Lookup Value window will appear. If not, ensure the ODBC driver is installed correctly. Enter the sales order number and click OK.
    FedEx Lookup Value.png
    • NOTE: The sales order must be in the Shipping module to show up in FedEx and the order number must be entered exactly as it appears in Fishbowl.
  9. The order should have now pulled in. If the carton weight was set in Fishbowl, this will pull into FedEx. Otherwise, the weight can be added in FedEx. Once the information is correct, click Ship. This will print a label and send the tracking number, cost, and updated weight back into Fishbowl to finish.

Click here for FedEx troubleshooting information.

UPS integration

Fishbowl includes a Small.UPS Ready.png UPS Ready module which means that UPS features are built into Fishbowl and directly accessible with no additional software required. The instructions below are for integrating with UPS WorldShip which does require additional software and configuration.

Follow the steps below to complete the UPS WorldShip Integration:

  1. Complete the ODBC setup.
  2. Install the latest version of UPS WorldShip. The installer can be downloaded by completing this form.
  3. To download the .dat files for Fishbowl 2015 or later, click here. To download individual .dat files, older .dat files, or to read an explanation of each file, see UPS WorldShip Mapping Files.
  4. Paste the .dat files into the UPS Shipment folder. The location of the Shipment folder varies with different versions, but is typically in one of the following locations.
    • C:\UPS\WSTD\ImpExp\Shipment
    • C:\UPS\UOWS\ImpExp\Shipment
    • C:\ProgramData\UPS\WSTD\ImpExp\Shipment
  5. Open UPS WorldShip.
  6. Click the Import/Export Data menu, click Automatic Export After Processing Shipment, and then click More.
  7. Select Fishbowl Export from the list and click Export.
  8. Click on Import/Export Data menu, click Automatic Export During End of Day, and then click More.
  9. Select Fishbowl Export from the list and click Export.
  10. Click on Import/Export Data menu, click Keyed Import, and then click More.
  11. Select FishbowlSO, FishbowlPO, or FishbowlXO (Sales Order, Purchase Order, or Transfer Order) from the list and click Import.
  12. The Enter Import Key window will appear. If not, ensure the ODBC driver is installed correctly. Enter the sales order number and press Enter on the keyboard.
    UPS Enter Import Key.png
    • NOTE: The sales order must be in the Shipping module to show up in UPS and the order number must be entered exactly as it appears in Fishbowl.
  13. The order should have now pulled in. If the carton weight was set in Fishbowl, this will pull into UPS. Otherwise, the weight can be added in UPS. Once the information is correct, click Process Shipment. This will print a label and send the tracking number, cost, and updated weight back into Fishbowl to finish.

Click here for UPS troubleshooting information.

Endicia integration

Follow the steps below to complete the Endicia integration. Fishbowl 2013.4 or later is recommended for use with Endicia.

Order Lookup

  1. Complete the ODBC setup.
  2. Create a Professional account on Endicia.com and download the Endicia Professional Suite. Run the installer and install Dazzle and Endicia Professional.
  3. Open Endicia Professional, click the Edit menu, choose Preferences, click on the Data Source and Post-Back tab, and then click the Configure button next to Order Lookup (or click here for Batch Print instructions).
    Endicia Edit Order Lookup Data Map.png
  4. Click the New button in the Data Source area.
    Endicia New Data Source.png
  5. Click Next, choose the ODBC data source option, and then click Next.
    Endicia Create ODBC Step.png
  6. Select Fishbowl from the dropdown. Leave the User Name and Password fields blank, and then click Next and OK to complete the wizard.
    Endicia ODBC Data Source.png
  7. If the Create a SELECT Statement window pops up, click Cancel to dismiss it.
    Endicia Select Statement Wizard.png
  8. Click the Advanced Editor button in the SELECT Statement area.
    Endicia Advanced Editor.png
  9. Paste the following query into SQL Editor window and then click OK.

    SELECT so.num AS ordernumber, shipcarton.id as groupcode, so.cost, shipcarton.freightweight as weight, so.customercontact as name, so.shiptoname AS company, so.shiptoaddress as address1, so.shiptocity as city, stateconst.code as state, so.shiptozip as postalcode, countryconst.abbreviation as country, carrier.name as carrier, shipcarton.cartonnum, customercontactview.contactnum as phone, CASE WHEN (SELECT FIRST 1 SKIP 0 contact.datus FROM contact JOIN address ON contact.accountid=address.accountid WHERE address.address=so.shiptoaddress AND contact.accountid=account.id AND contact.defaultflag=1 AND contact.typeid=60) IS NOT NULL THEN (SELECT FIRST 1 SKIP 0 contact.datus FROM contact JOIN address ON contact.accountid=address.accountid WHERE address.address=so.shiptoaddress AND contact.accountid=account.id AND contact.defaultflag=1 AND contact.typeid=60) WHEN (SELECT FIRST 1 SKIP 0 contact.datus FROM contact WHERE contact.accountid=account.id AND contact.defaultflag=1 AND contact.typeid=60) IS NOT NULL THEN (SELECT FIRST 1 SKIP 0 contact.datus FROM contact WHERE contact.accountid=account.id AND contact.defaultflag=1 AND contact.typeid=60) WHEN (SELECT FIRST 1 SKIP 0 contact.datus FROM contact JOIN address ON contact.accountid=address.accountid WHERE address.address=so.shiptoaddress AND contact.accountid=account.id AND contact.typeid=60) IS NOT NULL THEN (SELECT FIRST 1 SKIP 0 contact.datus FROM contact JOIN address ON contact.accountid=address.accountid WHERE address.address=so.shiptoaddress AND contact.accountid=account.id AND contact.typeid=60) WHEN (SELECT FIRST 1 SKIP 0 contact.datus FROM contact WHERE contact.accountid=account.id AND contact.typeid=60) IS NOT NULL THEN (SELECT FIRST 1 SKIP 0 contact.datus FROM contact WHERE contact.accountid=account.id AND contact.typeid=60) ELSE NULL END AS customeremail FROM so LEFT JOIN countryconst ON so.shiptocountryid=countryconst.id LEFT JOIN stateconst ON so.shiptostateid=stateconst.id LEFT JOIN carrier ON so.carrierid=carrier.id LEFT JOIN shipcarton ON so.id=shipcarton.orderid LEFT JOIN customercontactview ON so.customerid=customercontactview.custid JOIN customer ON so.customerid=customer.id JOIN account ON customer.accountid=account.id WHERE so.num='$ORDERNUMBER' AND ordertypeid=20

    Endicia Query.png
  10. Select the following fields in the Connected Fields area:
    Endicia Connected Fields.png
    • Select the following fields on the Package Details tab:
      Order Number -> ORDERNUMBER, Mail Class -> CARRIER, Group Code -> GROUPCODE, Value -> COST, Weight -> WEIGHT
      Make sure to check the Weight is in pounds checkbox.
    • If desired, the shipping carrier selected on the Fishbowl order can be imported and mapped to Endicia's mail class. If this step is skipped, Endicia will not import the carrier from Fishbowl and will instead use whatever service is currently selected in Endicia's Mail Class field. The mail class can always be changed prior to printing the label. To import the carrier that is selected on the Fishbowl order, click the Edit Mail Class Codes button. In the textbox, enter the name of the carrier in Fishbowl. In the dropdown, select the Endicia Mail Class that corresponds to the Fishbowl carrier and then click the + button. Additional Fishbowl carriers can be created in the Small.Carrier.png Carrier module.
      Edit Mail Class Code.png
    • Select the following fields on the Recipient Address tab:
      Name -> CUSTOMERCONTACT, Company -> SHIPTONAME, Address 1 -> SHIPTOADDRESS, City -> SHIPTOCITY, State -> CODE, Postal Code -> SHIPTOZIP, Country -> ABBREVIATION, Phone -> CONTACTNUM
    • Select the following fields on the Rubber Stamps tab:
      Rubber Stamp 1 -> SHIPCARTONID
    • OPTIONAL: Select CUSTOMEREMAIL in the Email field on the Recipient Address tab to automatically send emails via Dazzle.
    • OPTIONAL: Select the BILLTO fields on the Return Addresses tab to bring in a different return address.
  11. Click OK to close the Order Lookup Data Map window, then click the Configure button in the Post-Back Data section.
    Endicia Edit Order Lookup Data Map.png
  12. Click the New Data Map button in the top-left corner of the Post Back Data Map window.
    Endicia New Data Map.png
  13. Click Next, choose the ODBC data source option, and then click Next.
    Endicia Create ODBC Step.png
  14. Select Fishbowl from the dropdown. Leave the User Name and Password fields blank, and then click Next and OK to complete the wizard.
    Endicia ODBC Data Source.png
  15. Click the Select button to the right of the table field and choose the SHIPPINGIMPORT table.
    Endicia Table Select.png
  16. Select the following fields on the Package Details tab. If the IGNORE field is not available, it may be necessary to upgrade to Fishbowl 2013.4 or later, or contact support to have the field added.
    Order Number -> IGNORE, Postage Amount -> CARTONCOST, Tracking Number -> TRACKINGNUM, Transaction ID -> ID, Group Code -> SHIPCARTONID, Actual Weight -> CARTONWEIGHT
    Make sure to check the Weight is in pounds checkbox.
  17. Click OK to close the Post Back Data Map window and then click OK to close the Preferences window.
  18. Click the Tools menu, select Postback Data, and then click Options in the top-left corner.
    Endicia Postback Options.png
  19. Place a checkmark next to Automatically post back data, click OK, and then click the X in the top-right corner to close the Post-Back window.
    Endicia Automatically Post Back Data.png
  20. Click the Order Lookup tab in the main window, enter a sales order number, and then click the Retrieve Order button to retrieve the order from Fishbowl.
    Endicia Order Lookup.png

Batch Print

The steps for batch print are identical to those listed for Order Lookup, with the following changes:

  • For Step 3, click the Configure button next to Batch Print.
  • For Step 9, use the query listed below.

SELECT so.id, so.num AS ordernumber, so.customercontact AS name, so.shiptoname AS company, so.shiptoaddress AS address1, so.shiptocity AS city, so.cost, stateconst.code AS state, countryconst.abbreviation AS country, so.shiptozip AS postalcode, carrier.name AS carrier, shipcarton.freightweight AS weight, shipcarton.id as groupcode, shipcarton.cartonnum FROM so LEFT JOIN ship ON ship.soid=so.id LEFT JOIN countryconst ON so.shiptocountryid=countryconst.id LEFT JOIN stateconst ON so.shiptostateid=stateconst.id LEFT JOIN shipcarton ON ship.id=shipcarton.shipid LEFT JOIN carrier ON so.carrierid=carrier.id WHERE carrier.name='USPS' AND ship.statusid=20 AND shipcarton.ordertypeid=20

Click here for Endicia troubleshooting information.

TROUBLESHOOTING

ODBC troubleshooting

Below is some troubleshooting information for the ODBC setup.

32bit/64bit

  • Make sure to follow the appropriate 32-bit or 64-bit instructions found here.
  • Also, make sure that the ODBC connection, named Fishbowl, is only set up in one of the two available places. You can set up other connections to the Fishbowl database for other purposes but DO NOT name them Fishbowl.
  • Using the ODBC connection for something other than UPS/FedEx, such as Microsoft Access.
    • When running a 64-bit computer and Microsoft Access, the ODBC needs to be set up in Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN tab.
    • Use the fbclient64.dll file.
    • Make sure to not name it Fishbowl if you use UPS/FedEx/Endicia. If you don't, it doesn't matter what you name it.
    • The rest of the setup of that ODBC is the same as for UPS/FedEx/Endicia.
  • Sometimes, if the Test Connection keeps erroring out and everything looks correct, you can click Ok > then click Add > re-add all the information and click Test Connection and it will connect. Random, but it's worked a lot for me.

Using the wrong .dll file

  • When running a 32bit computer, you will never have this issue. This is most common with 64bit machines.
  • The fbclient64.dll cannot be used in the ODBC setup for the UPS/FedEx/Endicia integration.
  • Use the fbclient32.dll found here. If there are still connection issues, try grabbing the fbclient32.dll from the Fishbowl Server computer in the C:\Program Files\Fishbowl\database\odbc folder.

Firewall/Antivirus

  • The firewall is blocking port 3050. You can try placing 3050 in the server path to see if that allows the connection. An example of how this would look is here: (192.168.25.2:3050:C:\Program Files\Fishbowl\database\data\example.FDB) This will most likely still fail, but it's something I always try. So, now, follow these steps to dig deeper:
    • Open the command prompt and type: telnet ServerIPAddress 3050. An example of how this would look: telnet 192.168.25.2 3050.
  • If you receive an error that telnet is not a recognized command follow these instructions. Choose Telnet Client and Telnet Server.
    • If the command prompt screen goes blank, that means you have a connection and there is not an issue with this port being blocked. In this case, go back and triple check the settings above. (You can continue on and open ports and see if that makes a difference if you want but it more than likely something that was configured incorrectly.)
    • If you receive an error about it failing to connect, you more than likely have a firewall problem. So, you will need to open the ports. Here is how.
  • (WARNING: Opening firewall ports can potentially be a security risk. For more information, we recommend consulting with your IT professional.) On the Fishbowl Server computer, go to Control Panel, System and Security, Windows Firewall. Click on Advanced Settings on the left hand side and this will open a screen where you can set up rules to unblock port 3050. Click on Inbound Rules and then click New Rule on the right hand side. Choose Port, then choose TCP (you will repeat this same process for UDP) and enter 3050 as the specific port. Choose Allow the Connection in the next screen and choose all in the next screen and then name is Fishbowl 3050 TCP (or Fishbowl 3050 UDP). Click Finish and you are done, after you have created both. Now go back to the client computer and click test connection and it will connect.

Random Troubleshooting Setup

  • If you are setting up the ODBC and it just keeps failing over and over and everything looks correct, you can try one more thing. Click OK to close that connection you were working on and click Add to add a new connection and just enter all of the settings again. Surprisingly, this will frequently connect and you can then just delete the other connection. Odd, but it works.

FedEx troubleshooting

Below is some troubleshooting information for the FedEx integration.

Very slow import

  • This is caused by the phone number customer contact mapping. This is mapped to the CUSTOMERCONTACTVIEW table in the database and if there is a lot of information stored there, it can take a long time to run. The way to fix this is to disconnect the phone number mapping or use the FishbowlSingleFast mapping file that is already built without that mapping. (Click here for that file).

Mapping Files not showing up under Integration

  • The ODBC is not named Fishbowl. Go rename the ODBC connection to Fishbowl, then retry.
  • The ODBC is not set up in the correct spot based on the machine being 32bit/64bit. (Refer to the ODBC section)
  • If there are multiple ODBC connections named Fishbowl, this can break the integration. Check to make sure the ODBC is only set up in one of the two spots based on the computer being 32bit/64bit. Also, check under the User DSN tabs to make sure it is not set up there either. Remove ALL instances of an ODBC connection named Fishbowl except for the connection that is set up in the correct spot. (If more than one connection to the Fishbowl database is needed, you can set it up, just DO NOT name it Fishbowl.)
  • Mapping files are not in the correct folder.
    • In the current FedEx Ship Manager version, the default folder for the mapping files is C:\ProgramData\FedEx\Integration\Profiles. The ProgramData folder is a hidden folder, so you will need to change you folder view options to Show hidden files, folders, and drives.
    • If the above file path does not exist, we recommend manually creating a simple mapping files named findme or something similar and then search you drive for that name. (Example: findme.xml) For steps on how to create a simple mapping file, click here.

Mapping Files disappearing after FedEx restart

  • This is caused by a FedEx process remaining open. Close FedEx and then open the Task Manager and go to the processes tab. Look for IASE.exe and end all instances of it. Then reopen FedEx and the mapping will show up.
  • If the above step does not fix the problem, it is more than likely an install issue. Try reinstalling FedEx Ship Manager.

Order Not Found Import error

  • ODBC – Wrong database
    • You may have already checked the ODBC setup and the Test Connection was successful, but it could be pointed to the wrong Fishbowl database. Double check the IP Address for the Fishbowl Server and the local database path to the Fishbowl database and then fix the ODBC setup.
  • Address Issues
    • First, check to make sure there is a country listed on the address. This is the number one reason the import will fail.
    • Second, check to make sure the rest of the address is in its proper place. I have noticed orders where all of the street, city, state, zip and country are all listed in the Street address field in the Small.Sales Order.png Sales Order module. So, when looking at the sales order, it all looks fine, but if you click edit to edit the address, everything is listed in the street field.
    • If, by chance, you never assign countries to addresses in Fishbowl, you can disconnect the Country mapping in the FedEx mapping file so that it's not required. To do this, follow these steps listed here.
  • Order #
    • FedEx only allows numeric order numbers. Alpha-numeric order numbers will not import into FedEx.

Cannot export tracking information

  • If you receive an error that FedEx cannot export the tracking information back to Fishbowl, or the information just doesn't show up in Fishbowl after shipping the order in UPS or FedEx, check the following things:
    • In Fishbowl, reopen the sales order number in question from the search pane on the left of the Shipping Module. This will refresh the order and show any changes that were made to the order, like the tracking information being exported.
    • If you're using UPS, make sure that "Fishbowl Export" is selected under the Import/Export Data > Automatic Export After Processing Shipment menu.
    • If you still have issues after checking those things, contact technical support.

Freight

  • We currently do not offer any LTL Freight mappings.

Two Fishbowl Databases – One FedEx Ship Manager install.

  • Follow these steps to set up the second database connection/mapping:
    • First, set up a second ODBC connection by following the same ODBC set up steps listed here. Instead of naming it Fishbowl, name it Fishbowl1.
    • After that is set up, you will have two mapping files that you will switch between under Integration: FishbowlSingle and FishbowlSingle_1. (Download the FishbowlSingle_1 file here.)
    • Unlike UPS and Endicia, the mapping file contains both the import and export so you do not have to worry about changing both the import and export files to the company connection you want.
Create a new FedEx mapping

Follow the steps below to create a new FedEx mapping.

  1. Go to Integration
  2. Choose FedEx Integration Assistant
  3. Click Continue twice
  4. Choose Create a new profile
  5. Click Continue
  6. Choose Import
  7. Click Continue
  8. Choose ODBC and choose Fishbowl from the list
  9. Choose Single Edit
  10. Click Continue and click Continue again
  11. Click on Recipient and check the checkbox for Address 1. Click Ok.
  12. Click Continue
  13. Under the Table dropdown, choose ACCOUNT. Under the Field dropdown choose ID.
  14. Click Continue
  15. A box will pop up asking for a key index. Highlight ID under ACCOUNT and then click on the Lookup dialog box box. A colored line will be created. Click Ok.
  16. Click Continue and Continue again.
  17. Click Finish
  18. Choose to save the file and name it FINDME. Now you can go search for that file.
Remove FedEx country mapping

Follow the steps below to remove the country mapping from FedEx.

  1. Go to Integration
  2. Choose FedEx Integration Assistant
  3. Click Continue twice
  4. Choose the mapping file you want to modify (Fishbowl Single)
  5. Click Continue
  6. Click Import at the top of the screen
    FedEx 1.png
  7. Then choose Information
    FedEx 2.png
  8. Click on Recipient and uncheck the checkbox for Country. Click OK.
    FedEx 3.png
  9. Click on the Finish tab at the top of the screen and then click Continue and finally click Finish. You will be prompted to save. Choose Yes and finish that out. You can now go try the import again.

UPS troubleshooting

Below is some troubleshooting information for the UPS integration.

Mapping files not showing up under Keyed Import

  • The ODBC is not named Fishbowl.
  • The ODBC is not set up in the correct spot based on the machine being 32bit/64bit. (Refer to the ODBC section)
  • There are multiple ODBC connections named Fishbowl. Check to make sure the ODBC is only set up in one of the two spots based on the computer being 32bit/64bit. Also, check under the User DSN tabs to make sure it is not set up there either. Remove ALL instances of an ODBC connection named Fishbowl except for the connection that is set up in the correct spot. (If more than one connection to the Fishbowl database is needed, you can set it up, just DO NOT name it Fishbowl.)
  • Another reason the mapping files will be missing is because the \ImpExp\Shipment folder doesn't exist in the regular spot. Creating this file path manually will not resolve the issue. During the UPS install a different file path was designated for the mapping files storage location. To find this location, go to C:\Windows and scroll to the bottom of the folder list. Open wstdUPSWSHIP with Notepad, and then look at the Netpath listing. This will tell you where to browse and place the mapping files.

Order Not Found Import error

  • ODBC – Wrong database
    • You may have already checked the ODBC setup and the Test Connection was successful, but it could be pointed to the wrong database. Double check the IP Address for the Fishbowl Server and the local database path to the Fishbowl database and then fix the ODBC setup.
  • Address Issues
    • First, check to make sure there is a country listed on the address. This is the number one reason the import will fail.
    • Second, check to make sure the rest of the address is in its proper place. I have noticed orders where all of the street, city, state, zip and country are all listed in the Street address field in the Small.Sales Order.png Sales Order module. So, when looking at the sales order, it all looks fine, but if you click edit to edit the address, everything is listed in the street field.
    • If, by chance, you never assign countries to addresses in Fishbowl, you can disconnect the Country mapping in the UPS mapping file so that it's not required. To do this, follow these steps.
      1. In UPS WorldShip, click on Import/Export Date and choose Create/Edit Map.
      2. Select FishbowlSO from the list and click Edit. (Or the mapping file you use)
      3. At the bottom of the screen you will see a list of mappings. Highlight COUNTRYCONST::ABBREVIATION ---Ship To::Country/Territory and click Disconnect.
      4. Click OK, restart UPS and import that order. Tada!

Found multiple records

  • In the event that UPS has "found multiple records", you will need to manually edit the package information after importing and before processing labels. UPS will only import the original shipment, and will therefore export carton tracking number(s), cost(s) and weight(s) back to that shipment rather than the current one. This occurs even if the original shipment has already been fulfilled, possibly weeks prior. Follow these steps to avoid this potential problem:
  1. Delete all values from the Ref 2 field in WorldShip. These numbers refer to the specific cartons, which are from to the original shipment. The correct Ref 2 codes cannot be imported.
  2. Correct the shipping service class and package weight(s), if necessary
  3. Process the shipment, and manually copy the resulting tracking number and cost into Fishbowl.

Cannot export tracking information

  • If you receive an error that UPS cannot export the tracking information back to Fishbowl, or the information just doesn't show up in Fishbowl after shipping the order in UPS or FedEx, check the following things:
    • In Fishbowl, reopen the sales order number in question from the search pane on the left of the Shipping Module. This will refresh the order and show any changes that were made to the order, like the tracking information being exported.
    • If you're using UPS, make sure that "Fishbowl Export" is selected under the Import/Export Data > Automatic Export After Processing Shipment menu.
    • If you still have issues after checking those things, contact technical support.

Mail Innovations Shipments

  • The Fishbowl UPS WorldShip integration is not set up to work with Mail Innovations at this point in time. You can still use the FishbowlSO.dat import to import order information from Fishbowl to UPS but you cannot use the Fishbowl Export to export tracking numbers, cost and weight back to Fishbowl from UPS for these type orders.

Freight Shipments

  • Because of the changes that UPS makes to the WorldShip program after you check the Freight checkbox for an order, the Fishbowl UPS WorldShip integration is unable to export tracking, cost, weight, etc… back to Fishbowl from UPS for freight shipments. You are able to use the FishbowlSO.dat import to import order information from Fishbowl into UPS.

Keyed Import box not showing up

  • Dual monitors can be a big hassle with this little box. My recommendation is that you always and only use UPS WorldShip on your primary monitor and then you shouldn't have any issues with finding this box.
  • Corrupt UPS install. Try uninstalling and reinstalling UPS WorldShip.
  • If all else fails, call UPS tech support. Where this is a WorldShip issue, you will want to contact them. When getting help, you will want to avoid mentioning the integration with Fishbowl or they will be tempted to pass you off and not help you. UPS can more efficiently help you if you speak with them only about WorldShip issues.

Export Failing after processing the shipment

  • This error means that there is a record stuck in the SHIPPINGIMPORT table of the database. Call into Fishbowl Support at 1-800-774-7085 x3 to have a tech remote in and fix this through the database and then the exports will start working again.
    ODBC Error.png

Two Fishbowl Databases – One UPS WorldShip install.

  • This is possible but needs careful attention so that something isn't missed. Honestly, it's better to have UPS WorldShip installed on two different computers and set up the mappings accordingly, one for each database.
  • But, if there can only be one shipping computer, follow these steps to set up the second database connection/mapping:
    • First, set up a second ODBC connection by following the same ODBC setup steps listed here. Instead of naming it Fishbowl, name it Fishbowl1.
    • Now the tricky and most vital part of all of this.
    • Depending on what database you want to work in, you have to change TWO settings EVERY TIME.
    • Go to Import/Export Data > Automatic Export After Processing Shipment and choose the export file you want to use: Fishbowl Export or Fishbowl1Export.
    • Next, go to Import/Export Data > Keyed Import and choose the Import file you want to use: FishbowlSO or Fishbowl1SO. (MAKE SURE THIS SELECTION MATCHES WHAT YOU CHOSE UNDER Automatically Export after processing a shipment.)
    • Click here to download the files.

Endicia troubleshooting

Below is some troubleshooting information for the Endicia integration.

Two Fishbowl Databases – One Endicia Account

  • This is possible but needs careful attention so that something isn't missed. Honestly, it's better to have Endicia installed on two different computers and set up the mappings accordingly, one for each database.
  • But, if there can only be one shipping computer, follow these steps to set up the second database connection/mapping:
  1. First, set up a second ODBC connection by following the same ODBC setup steps listed here. Instead of naming it Fishbowl, name it Fishbowl1. (or Fishbowl *other company name*. Ex: Fishbowl Apex)
  2. Once that is set up, follow the same Endicia setup steps listed here. Instead of choosing the Fishbowl connection, choose Fishbowl1. (Or whatever you named it)
  3. Now the tricky and most vital part of all of this.
  4. Depending on what database you want to work in, you have to change TWO settings EVERY TIME.
  5. Go to Edit > Preferences > Database tab.
  6. First, click on Edit Order Lookup Data Map.
  7. Under Data Source, choose the database you want to work in and click OK.
  8. Then, click on Edit Post-Back Map.
  9. Click on the folder button called, Open Data Map and choose the database you want to use and click OK. (MAKE SURE THIS SELECTION MATCHES WHAT YOU CHOSE UNDER Edit Order Lookup Data Map.)

Post back error (Error image below)

Endicia post back error.png

  • When you receive this error when processing a shipment it is because the order, in Fishbowl, has not reached the shipping module (has not been finished in picking). Here are the steps to take:
  1. Login to the Fishbowl Client and go to the Shipping module. Search for the order number, it will not be there.
  2. Go to the Picking module and pull up that order. Finish the pick and head back to the Shipping Module.
  3. Then go into Endicia and go to Tools > Post Back Data > and you will see that shipment record listed there. Highlight it and delete it.
  4. Then process the order through Endicia again.