UPS WorldShip Mapping Files

From Fishbowl

Jump to: navigation, search

Click here to download all of the mapping files for Fishbowl 2017 or later.

Click here to download all of the mapping files for Fishbowl 2015 to 2016.14.

Click here to download all of the mapping files for Fishbowl 2014.1 or earlier.

Instructions for integrating with UPS WorldShip can be found here. The Small.ShipExpress.png ShipExpress module and the Small.ShipStation.png ShipStation module integrate with nearly all carriers. Fishbowl also has a built-in Small.UPS Ready.png UPS Ready module.

NOTE: The descriptions below are for Fishbowl 2016.14 or older. The files for Fishbowl 2017.1 or later may have minor differences.

Contents

IMPORTS

FishbowlSO.dat

This is the standard mapping file used when importing orders from Fishbowl into UPS WorldShip. This file requires that each customer have a street address, state and country set up on the ship to address(es), otherwise the import will fail. All other fields are optional and will be pulled in if they exist on the Sales Order in Fishbowl.

Mappings Contained:


FishbowlSO-CustomerPO.dat

This mapping has all of the same requirements as the standard FishbowlSO.dat mapping file. In addition to those mappings, this import can pull in the Customer PO number from the Sales Order.

Mappings Contained:


FishbowlSO-NoCountryNoPhone.dat

This mapping has all of the same requirements as the standard FishbowlSO.dat mapping file except that is does not require the order to have a country on the address and it does not import the customer phone number. Use this mapping file if you customer addresses do not contain a country and if imports are slow.

Mappings Contained:


FishbowlSO-NoPhone.dat

This mapping has all of the same requirements as the standard FishbowlSO.dat mapping file except the phone number mapping is disconnected. Use this mapping if importing orders takes a long time.

Mappings Contained:


FishbowlSO-NoCountry.dat

This mapping has all of the same requirements as the standard FishbowlSO.dat mapping file except that is does not require the order to have a country on the address. Use this mapping file if your customer addresses do not contain a country.

Mappings Contained:


FishbowlE-SO.dat

This mapping has all of the same mappings as the standard FishbowlSO.dat mapping file with an addition of the customer email. The email addresses can be set up under the Main Office or Ship To but if an email address is set up on each, the Main Office email address trumps all. The email address contact on the customer also does not need to be set as default but it’s a good idea to set it as default. This mapping does require additional setup via tech support. To have this set up, call 1-800-774-7085 x3.

Mappings Contained:


FishbowlPO.dat

This mapping allows you to import Purchase Orders that have credit return line items on them, meaning you are sending something back to the vendor. This file requires that each vendor have a street address, state and country set up on the ship to address(es) otherwise the import will fail. All other fields are optional and will be pulled in if they exist on the Purchase Order in Fishbowl.

Mappings Contained:


FishbowlXO.dat

This mapping allows you to import Ship type Transfer Orders into UPS. This file requires that each To address have a street address, state and country set up on the ship to address(es) otherwise the import will fail. The From address just requires what Fishbowl requires. All other fields are optional and will be pulled in if they exist on the Transfer Order in Fishbowl.

Mappings Contained:


FishbowlSO-ShipNum.dat

This mapping file is basically the standard FishbowlSO.dat mapping file, except for one change. It is designed to accommodate partial shipments. Currently, if you ship out part of an order and then go to import the second half of the order, UPS will tell you that multiple records have been found and it will import both. This mapping file eliminates that problem. The one major difference is that when typing in the order number to import you need to use a capital S then the number and then the proceeding -01 or -02. (e.g. S50079-01).

Mappings Contained:


Fishbowl Batch.dat

This mapping file is designed to allow you to mass import Sales Orders from Fishbowl into UPS WorldShip. Notice, this import DOES NOT allow you to batch process orders in WorldShip, it only allows for batch import. You will then process the orders one by one.

To be imported with this import, orders must be in a Packed status and the Carrier must be set to UPS. Follow the steps below to use this file in WorldShip.

  1. Go to Import/Export Data
  2. Select Batch Import
  3. Select Fishbowl Batch.dat
  4. DO NOT check the checkbox for Process shipments automatically after import
  5. Continue through the wizard then go to History and these orders will show under Imported Shipments

Mappings Contained:

EXPORTS

Fishbowl Export.dat

This is the standard mapping file used to export tracking numbers, cost and weight back to the Fishbowl ship carton.

Mappings Contained:


Fishbowl Export-NoCost.dat

This export mapping file is used when you do not want the UPS shipping cost to come back to Fishbowl from UPS WorldShip. The tracking number will transfer to the Small.Sales Order.png Sales Order module and export to QuickBooks as long as carton based shipping is turned on.

Mappings Contained:


Fishbowl Export-Total.dat

This export mapping is used to send total shipment costs back to Fishbowl. This mapping is designed for single carton shipments only. It can be used with multiple carton shipments but it sends the total shipment cost back to each carton, thus doubling, tripling, etc… the cost of the shipment. In order to correct this, you will go into the Ship module of Fishbowl and edit the cost for all but one carton down to $0.

Mappings Contained:

Personal tools
Namespaces
Variants
Actions
Navigation
Other Pages
Toolbox
Print/export
Translate