ShipStation

From Fishbowl
Jump to: navigation, search

Icon.ShipStation.png The ShipStation module, located in the Sales group, is an add-on module that can be installed from the Small.Plugin.png Plugin module. After installing the plugin, a new module is added that integrates with ShipStation's eCommerce shipping software. After an order has been picked in Fishbowl, the order information will be sent to ShipStation. After the order has been processed in ShipStation, the tracking number and carton costs will be sent back to Fishbowl. The Small.ShipStation.png ShipStation module also provides a browser view to access the ShipStation interface from within the Fishbowl Client.

ShipStation.png

Video

The documentation on this page is for the most recent version of the ShipStation plugin. To update, see Update Fishbowl.

Install

  1. In any Fishbowl Client, open the Small.Plugin.png Plugin module, located in the Integrations group.
  2. Select the ShipStation plugin and click Install Now.
  3. Completely close all Fishbowl Clients.
  4. Exit the Fishbowl Server by right-clicking the Fishbowl Server tray icon and selecting Exit.
  5. After re-opening the Fishbowl Server, the admin user can access the Small.ShipStation.png ShipStation module from any Fishbowl Client by opening the Sales module group.
  6. To grant access to additional users, open the Small.User Group.png User Group module and assign the ShipStation-View right to the appropriate groups as explained here.

Setup

  1. Opening the Small.ShipStation.png ShipStation module will begin the setup process, or click the Mapping Button.png Settings button to modify settings.
  2. Click the link on the Integration tab and log into ShipStation. This will open the ShipStation API Settings page.
    ShipStation API Info.png
  3. Scroll to the bottom of the page to find the API Key and API Secret. Place the windows side by side and use Ctrl + c to copy the values and Ctrl + v to paste them into Fishbowl.
    ShipStation API Credentials.png
  4. On the ShipStation website, click the Settings icon. Click Selling Channels, select Store Setup, and then click Edit next to the store name.
    ShipStation API Settings.png
  5. Click the Products tab and then select Create a new product record so that details can be configured. Then click Save Changes.
  6. To change the order sync schedule, click the drop-down arrow on the right side of the Orders button in Fishbowl.
    Orders Button Settings.png
    Activate a schedule and then click Save.
    ShipStation Orders Tab.png
  7. To change the shipment sync schedule, click the drop-down arrow on the right side of the Shipments button in Fishbowl.
    Shipments Button Settings.png
    Activate a schedule and then click Save.
    ShipStation Shipments Tab.png

Sync

  • After activating a schedule, click the Orders Button.png Orders button or the Shipments Button.png Shipments button to sync immediately.
  • To import carriers from ShipStation, click the Carriers Button.png Carriers button.
  • After an order has been picked in Fishbowl, the order information will be sent to ShipStation during the next sync.
  • After the order has been processed in ShipStation, the tracking number and carton costs will be sent back to Fishbowl during the next sync.
  • The tracking number and costs will be added to the first carton in Fishbowl. If there is more than one package, ShipStation generates a tracking number that will track the combination of packages.
  • The Ship Num in Fishbowl is used to connect orders. If an order is split in ShipStation, it will be assigned a new order number and only the original order will be tied to the Fishbowl shipment.
  • Upon sync, the order will be fulfilled in Fishbowl.

Quotes

To get shipping rates, click the ShipStation Ship Quote Button.png Ship Quote button in the Small.Sales Order.png Sales Order module.

Shipping Rates.png

Module Options

Some aspects of the Small.ShipStation.png ShipStation module can be customized by opening the module, clicking the Tools menu, and then selecting Module Options.

  • The Small.ShipStation.png ShipStation module includes a browser view to access the ShipStation interface from within the Fishbowl Client. The Back Button.png Back button and Forward Button.png Forward button can be used to control the browser. To have the browser log in automatically, each Fishbowl user can enter their ShipStation Username and Password.
    ShipStation Module Options.png
  • Address - Select the default ship from address. This is required for accurate rate quotes.
  • Use shipment number prefix 'S' on ShipStation orders - When selected, ShipStation will display the 'S' prefix for shipments from Fishbowl sales orders.
  • Use product number for SKU - When selected, the Fishbowl product number will be sent as the ShipStation order item SKU.
  • Use residential address for quotes - When selected, rate quotes will be for residential addresses.
  • Fail if missing state code - When selected, orders missing a state code will not be exported to ShipStation.

Mapping

The table below shows how data transfers between ShipStation and Fishbowl.

ShipStation Fishbowl
ShipStation order
Entered or Packed shipment (SO or PO)
Tracking and Rate
Tracking # and cost on first carton
Item Name
Product number
Item SKU
SKU or product number
Item quantity
Item quantity
Weight
Total item weight
Order date
Order issue date
Order number
Ship Number
Ship To & Bill To
Ship To address

Troubleshooting

Integrating Fishbowl AND your seller site (i.e. WooCommerce, Shopify) directly to ShipStation can cause issues with processing shipments in Fishbowl. De-activate any direct integration between ShipStation and your seller site to avoid these issues. This is done in the ShipStation>Selling Channels settings. Fishbowl will push any shipment/tracking updates directly to the site.

  • To view the ShipStation scheduled tasks, open the Small.Schedule.png Schedule module.
  • The scheduled tasks can be edited to add an email address for error notifications.
  • A scheduled task can be run manually by double-clicking the task.
  • To view the history of a schedule task, including the result/error, click the History Icon Button.png History button in the Small.Schedule.png Schedule module.
  • More details about recent errors can be viewed by opening the Small.Data.png Data module and clicking the Server Log Button.png Server Log button.
  • Click the Reset Button.png Reset button to reset the last sync date. This can be used to force a more complete sync, instead of just syncing items that have changed since the last sync.

Release Notes

3.1 - 7/12/2018 - Fishbowl 2018.7
  • Bug Fixes
2.8 - 5/11/2018 - Fishbowl 2018.5
  • Transfer orders now export to Shipstation.
2.7 - 3/8/2018 - Fishbowl 2018.3

Please Read - Before updating to version 2.7 you will need to cancel all open shipments in Shipstation before running a sync. Failure to do so will cause orders to duplicate. You can then re-push those orders. This is not applicable if you are connecting Fishbowl to Shipstation for the first time.

  • Orders with no state will now export without error to Shipstation unless the newly created option “Fail if missing state code” is selected. If the box is checked, all orders with states will export even if there are orders missing states. The error message in that case will indicate which orders failed.
  • Price from ship type sales order items is now sent up to Shipstation. It goes towards the shipping paid in the order summary section.
  • Performance enhancements on import.
  • The integration now looks at the residential flag on the ship to address on the sales order when requesting a quote. If the residential box is checked it will provide a residential quote.
  • Fixed a bug where decimals on weights were being truncated.
  • Added option to use the Fishbowl product number as the SKU in Shipstation. The product description will be mapped to item name if selected.
2.2 - 12/13/2017 - Fishbowl 2017.11
  • Fixed a bug where the "S" prefix wasn't being added to the Sales Order number when that option is selected.
2.1- 12/5/2017 - Fishbowl 2017.11
  • Fixed a bug where duplicate orders were being created in ShipStation.
2.0 - 11/16/2017 - Fishbowl 2017.11
  • Enhancement to import orders into Fishbowl from ShipStation with statuses of fulfilled and shipped.
1.12 - 6/28/2017 - Fishbowl 2017.5
  • Added option to select default shipping item used for Ship Quote feature
  • Improved error messaging
  • Fixed bug creating duplicate orders in Shipstation when multiple cartons exist in FB Shipment
  • Added a scroll bar to the rate quote window
  • Fixed bug when fulfilling sales orders with shipping items added to the order from using the Ship Quote feature
1.11 - 6/12/2017 - Fishbowl 2017.4
  • We now send the phone number when sending shipments to ShipStation
1.10 - 5/25/2017 - Fishbowl 2017.4
  • Improved error message when running order sync and carrier from ShipStation is not found in Fishbowl
  • Added error message when using the quote feature and weight limits are exceeded for the carrier and no quote can be completed
  • Fixed bug when no sales order is loaded and trying to use the quote button caused the client to freeze
  • Added option to remove the shipment number prefix "S" for syncing orders
1.9 - 4/13/2017 - Fishbowl 2017.3
  • Compatibility fixes for 2017.3 version of Fishbowl
  • Fixed tax functionality for Australia and Canada versions of Fishbowl
1.8 - 4/6/2017 - Fishbowl 2017.2
  • Fixed issue with international orders requiring a state
  • Fixed issue creating duplicate shipments in ShipStation with partially shipped orders
  • Fixed issue with partial orders not sending over all line items to Shipstation
1.7 - 2/9/2017 - Fishbowl 2017.1
  • Push Carrier and Carrier Method (when selected) from FB SO to Shipstation Order
  • Added reset last sync button
  • Push Carton Dimensions (when defined) from FB to Shipstation
  • Push product price from FB to Shipstation
  • Orders synced to SS will push over the customer email address
  • Issue: Transfer orders don't import to ShipStation
  • Resolution: Transfer orders are now included in the shipment sync to ShipStation.
  • Issue: syncing orders can create duplicate data when the order of operations isn't carried out correctly.
  • Resolution: Sync to and from Fishbowl have been combined into a single button