Fishbowl as a Source
Summary
Fishbowl can act as a source in Flxpoint, not just an accounting integration. Two source operations are supported: Get Inventory & Products, a delta feed that pulls product and quantity data (quantity already net of sales order allocations) from your Fishbowl server, and Get Shipments, which brings tracking and carrier back against fulfillment requests. Both reuse the accounting connection: an approved Flxpoint app on your Fishbowl server plus a dedicated API user. Get Shipments only picks up purchase orders whose Fishbowl status is Fully Processed or Acknowledged.
Fishbowl is most often set up as an accounting integration, but it can also act as a source in Flxpoint. Two source operations are supported.
Fishbowl as a Source uses the same connection details as the Fishbowl accounting integration: an approved Flxpoint app on your Fishbowl server plus a dedicated API user. If you have already connected Fishbowl for accounting, the same values apply here. Create a source for Fishbowl, start a Get Inventory & Products job, then choose Connect an Integration and select Fishbowl. Enter the connection details, click Test Connection, then Save Connection.
| Field | What to enter |
|---|---|
Connection NameSetting | A friendly label for this connection, for example Fishbowl Source. |
API URLRequired | The URL of your Fishbowl API server. |
Server PortRequired | The port your Fishbowl API listens on. |
App NameRequired | Must match the app name used to approve the Flxpoint app in Fishbowl. |
App IDRequired | Must match the App ID used to approve the Flxpoint app in Fishbowl. |
User NameRequired | Your dedicated Fishbowl API user. Case-sensitive. |
PasswordRequired | The password for that API user. Case-sensitive. |
Prepare the API user before you connect
Create a dedicated Fishbowl API user and user group with Customer, Product, Data, Purchase Order, Sales Order and Vendor permissions. The same user serves both the accounting and the source operations.
Get Inventory & Products is a delta feed
Each run brings across what has changed rather than re-reading your whole Fishbowl catalog, and products are retrieved in pages so large catalogs do not arrive in a single request. Only active Fishbowl products are included.
Quantity already accounts for sales order allocations
The quantity Flxpoint imports is quantity on hand minus quantity allocated to Fishbowl sales orders. It is the quantity genuinely available to sell, so you do not need a workflow rule to subtract allocations yourself.
Get Shipments needs the order in Fishbowl first
The run finds the matching Fishbowl purchase order using the reference stored on the fulfillment request, falling back to the external accounting ID. In practice orders must have gone to Fishbowl through Send Accounting Orders first, and a PO is only eligible once its status is Fully Processed or Acknowledged: a PO still In Processing returns nothing, even with a tracking number filled in. This is the most common reason a run looks empty.
These are the Fishbowl fields exposed on the GIP mapping template. Map at minimum a SKU field and quantity.
| Fishbowl field | What it holds | Notes |
|---|---|---|
| productNum | Product number | The Fishbowl product number. Common choice for SKU / Master SKU. |
| partNum | Part number | The underlying part number. Use this for SKU instead if your team keys off parts. |
| productId | Product identifier | Fishbowl’s internal product identifier, useful as a stable reference. |
| productDescription | Title / description | Maps to the product Title or Description. |
| productUpc | UPC | Barcode where present. Usable as a secondary match key. |
| availableQty | Quantity | Quantity available, already net of quantity allocated to sales orders. |
| avgCost | Cost | Wholesale cost. Maps to your Cost field. |
| List Price | List price | Retail / list price from your Fishbowl product record. Added January 2026. |
| partQty | Units per product | How many base units make up one product, for products sold in a unit of measure other than each. |
| uomName | Unit of measure | The unit of measure name, for example Each or Case. |
productNum and partNum are both available and they are not always the same value in Fishbowl. Whichever you map as the Master SKU is what Flxpoint uses to link this source’s inventory to your channel listings, so decide once and keep it consistent.Shipment lines are matched back to fulfillment request items by SKU, with the shipped quantity applied per line.
| Fishbowl field | Maps to | Notes |
|---|---|---|
| Tracking number | Tracking Number | The tracking number recorded on the Fishbowl shipment. |
| Carrier | Carrier | The carrier name from Fishbowl. |
| SKU | SKU | Used to match each shipment line back to the right fulfillment request item. |
| Quantity | Quantity | Units shipped on the line, so partial quantities land on the right item. |
Shipping cost, invoice information and shipment custom fields are not part of this operation. For anything beyond the fields above, contact support@flxpoint.com.
Test Connection returns 401
Get Inventory & Products returns nothing or misses items
Get Shipments brings back no tracking
- Check the Fishbowl PO status. Anything other than Fully Processed or Acknowledged will not be picked up.
- Confirm the order was sent to Fishbowl via Send Accounting Orders, which is what stores the reference used for matching.
- Confirm the shipment actually exists in Fishbowl. Get Shipments only retrieves what is already recorded there.
Shipment came in without a carrier
Which operations does Fishbowl support?
Do I need a second connection for the source operations?
Can Flxpoint send orders to Fishbowl through this source?
Does GIP import images, categories or weights and dimensions?
Which field should I use as the Master SKU?
productNum or partNum your team already treats as the item identifier. It has to be unique per item and match what your channel listings use, since linking is by SKU.