Fishbowl Integration
You can connect Fishbowl with your B2B Wave account to update your product inventory from Fishbowl, send B2B Wave orders to Fishbowl as sales orders, automatically create missing parts and products in Fishbowl when sending orders, and bring shipment tracking numbers and shipping statuses back into B2B Wave. To use this integration, your Fishbowl Server REST API must be accessible over the internet, and you need a Fishbowl user account with access rights to the Customer, Part, Product, Inventory, Location Group, Sales Order, Discount, Shipping, Vendor, User, and Data modules.
Connecting Fishbowl with B2B Wave
To set up the Fishbowl integration, follow these steps:
Step 1. Contact our support team to enable the Fishbowl integration for your account. Once enabled, a Fishbowl menu appears on your Admin Panel sidebar.
Step 2. Go to Fishbowl >Configuration and fill in the fields under the “Connection Details” section:
| IP or URL | Enter the public IP address or URL of your Fishbowl server, including http:// or https:// (for example, https://fishbowl.yourcompany.com), without a trailing slash or port number. |
| Port | Enter the port number for your Fishbowl REST API (for example, “2456” for the default Fishbowl API port, or “443” if your server is behind an HTTPS proxy). |
| App Name | Enter the application name that will identify B2B Wave in Fishbowl (for example, “B2B Wave”). |
| App Description | Enter a short description of the integration to display in Fishbowl. |
| App ID | Enter a unique numeric identifier for the application in Fishbowl (for example, “100”). |
| Username | Enter the username of the Fishbowl user account that B2B Wave will use to log in. Usernames are case-sensitive. |
| Password | Enter the password for the Fishbowl user account. Passwords are case-sensitive. |

Step 3. Click “Test Connection.” The first time B2B Wave attempts to log in with a new “App Name” and “App ID,” Fishbowl registers the application in a pending state and requires an administrator to approve it in Fishbowl. You should see the following message: "A new integrated application has been added to Fishbowl. Please contact the Fishbowl administrator to approve this integrated application."

Step 4. Log in to Fishbowl as an administrator, navigate to Setup >Settings, approve the B2B Wave application matching your “App Name”. If the app doesn't show up in the list, try clicking "Refresh".

Step 5. Return to Fishbowl >Configuration on your B2B Wave Admin Panel and click “Test Connection” again. Once you see “Success: connection made,” configure your settings under “Options” and click “Save Configuration.”
NOTE: Clicking “Test Connection” verifies your login and stores an active session token, but you must also click “Save Configuration” at the bottom of the page to save your connection details. Once you approve the app in Fishbowl, do not change the “App Name” or “App ID,” as doing so registers a new unapproved application in Fishbowl. In addition, make sure multi-factor authentication (MFA) is turned off for the Fishbowl user account used by the integration.
Configuring Integration Options
Under the “Options” section on Fishbowl >Configuration, you can customize how B2B Wave syncs inventory, checks products, creates sales orders, and updates tracking details:
| Auto-update inventory | Check this box to automatically update your product quantities in B2B Wave from Fishbowl every hour. |
| Product quantity | Select which Fishbowl stock figure B2B Wave should use when updating product quantities: “Available quantity (quantity on hand - quantity allocated)” or “Quantity on hand.” |
| Product checking when creating an order | Select how B2B Wave handles products before sending an order to Fishbowl: “Do not create order in Fishbowl if all products do not already exist,” “Automatically create product if product does not exist,” or “Create order without any checks or imports.” |
| Sales order status when creating an order | Select the initial status assigned to sales orders created in Fishbowl: “Estimate” or “Issued.” |
| Update tracking numbers and shipping status | Check this box to have B2B Wave check Fishbowl every hour for tracking numbers and shipment statuses on orders sent to Fishbowl. Saving this option also adds Fishbowl >Update tracking numbers to your Admin Panel sidebar. |
| Use customer invoice email on sales orders | Check this box to send the customer’s “Email for receiving invoices” (or the parent customer’s invoice email for sub-customers) on Fishbowl sales orders instead of the customer’s login email. If the invoice email is blank, B2B Wave falls back to the customer’s login email. |

Mapping Product Fields for Automatic Creation
When you select “Automatically create product if product does not exist” under “Product checking when creating an order,” the “Fishbowl / B2B Wave Field Mapping” table appears. When you save your configuration after switching to this option, B2B Wave checks your Fishbowl parts list in the background and links any matching products in B2B Wave. Then, whenever you send an order to Fishbowl, B2B Wave checks whether any products on the order are still missing in Fishbowl and creates the missing parts and products in Fishbowl before creating the sales order.
| PartNumber (required) | Select the B2B Wave product field used for the Fishbowl part number, product number, and product SKU: “Code,” “Name,” “Description,” “UPC Code,” “Barcode,” or a product extra field. |
| PartDescription (required) | Select the field used for the Fishbowl part description: “Name,” “Description,” or a product extra field. |
| PartDetails (optional) | Select “Description” or a product extra field to populate the part details in Fishbowl. |
| UOM (required) | Select “Measurement Unit” or a product extra field to set the part’s unit of measure in Fishbowl. |
| UPC (optional) | Select “UPC Code” or a product extra field to populate the product’s UPC in Fishbowl. |
| PartType (required) | Select the Fishbowl part type assigned to newly created parts: “Inventory,” “Service,” or “Non-Inventory.” |
| Weight (optional) | Select “Weight” or a product extra field to send the product’s weight. |
| WeightUOM (optional) | Select a product extra field holding the weight unit of measure (for example, “lbs” or “kg”). |
| Width (optional) | Select “Width” or a product extra field to send the product’s width. |
| Height (optional) | Select “Height” or a product extra field to send the product’s height. |
| Length (optional) | Select “Length” or a product extra field to send the product’s length. |
| SizeUOM (optional) | Select “Dimension Measurement Unit” or a product extra field to set the dimensions’ unit of measure. |
| POItemType (required) | Select “Purchase” or “Out Sourced.” |
| Price (optional) | Automatically taken from the product’s price on your default price list in B2B Wave. If none of the products being created have a price on the default price list, this field is omitted. |
| Vendor (optional) | Automatically taken from the product’s brand/manufacturer in B2B Wave whenever a manufacturer is assigned or any vendor field below is mapped. |
| VendorPartNumber (optional) | Select a product extra field holding the vendor’s part number. |
| Cost (optional) | Select a product extra field holding the vendor cost. If the extra field is empty on the products being created, this field is omitted. |
| VendorUOM (optional) | Select a product extra field holding the vendor’s unit of measure. |
TIP: Map “PartNumber” to “Code” so that newly created Fishbowl products use the same product code that B2B Wave sends on sales order line items. If a product in B2B Wave was previously linked to a Fishbowl part that you have since deleted or replaced in Fishbowl, go to Products >Products, open the product, and click “Unlink from integrations” so B2B Wave can link or create it again on the next order.
Updating Inventory from Fishbowl
When “Auto-update inventory” is checked on Fishbowl >Configuration, B2B Wave updates your product quantities every hour. You can also run an inventory update manually at any time:
Step 1. Go to Fishbowl >Update inventory on your Admin Panel.
Step 2. Click “Update” and confirm the prompt. You’ll see the message “Updating inventory from Fishbowl scheduled.”

During each update, B2B Wave sums the stock across all of your Fishbowl location groups for each Fishbowl product using the option selected under “Product quantity” (“Available quantity (quantity on hand - quantity allocated)” or “Quantity on hand”). Each Fishbowl product number is matched to the product’s “Code” in B2B Wave, and B2B Wave updates the product’s quantity accordingly.
Only the main product’s quantity is updated—product names, descriptions, prices, and product variants are not changed, and B2B Wave products that do not match a product in Fishbowl are left untouched.
TIP: You can review the results of each inventory sync under Tools >Import Log, where Fishbowl updates appear with the file type “Fishbowl.”
NOTE: If your products in Fishbowl match your B2B Wave products by product name or by a “Product Code” extra field rather than by the product’s “Code,” contact our support team to configure this matching rule for your account.
Sending Orders to Fishbowl
Orders are not sent to Fishbowl automatically when placed. You can send orders to Fishbowl individually from an order’s page or in bulk from the Orders list.
To send a single order to Fishbowl:
Step 1. Go to the Orders menu and click on the order you want to send.
Step 2. Scroll to the bottom of the “Products” section and click “Create Fishbowl order.”

When the order is sent, you’ll see the message “Fishbowl order created successfully. Integration ID will be updated shortly.” The button changes to “Order creation in progress” while B2B Wave retrieves the new sales order’s ID from Fishbowl (about one minute), and then displays “Fishbowl order ID: <ID>.”
TIP: To filter orders by whether they have been sent to Fishbowl, go to the Orders menu, open the search filters, and set “Has Fishbowl order?” to “Yes” or “No.”

Sending Orders to Fishbowl in Bulk
If you want to send multiple orders to Fishbowl at once, contact our support team to enable bulk sales order creation for your account. Once enabled:
Step 1. Go to the Orders menu and select the checkboxes next to the orders you want to send.
Step 2. Click the actions drop-down arrow at the top of the order list and select “Create Sales Orders.”
B2B Wave schedules the selected orders and sends them to Fishbowl one at a time in the background.
What B2B Wave Sends to Fishbowl
When creating a sales order in Fishbowl, B2B Wave sends the following information:
| Order Number (SONum) | Formatted as “B2B-” followed by the 6-digit zero-padded B2B Wave order ID (for example, order 42 becomes “B2B-000042”). If your account has an order admin extra field named “Fishbowl_OrderNumber” with a value on the order, that value is used instead. |
| Status | Set to “Estimate” (10) or “Issued” (20) according to your “Sales order status when creating an order” setting. |
| Customer | B2B Wave sends the customer’s “Company” name as the Fishbowl customer name, along with their contact name, phone number, and email address (or invoice email, if enabled). If a customer with that name (case-insensitive) does not exist in Fishbowl yet, Fishbowl creates the customer automatically when importing the sales order. If the customer already exists in Fishbowl as a sub-customer (with a parent customer), B2B Wave formats the name as “Parent:Sub.” |
| Billing and Shipping Addresses | Billing address fields are populated from the customer’s billing address in B2B Wave, and shipping address fields are populated from the order’s shipping address. |
| Order Details | Includes the customer’s “Order reference code” as the PO number (PONum), the order creation date (MM/DD/YYYY), the customer’s order comments as the note, “Delivery” as the carrier name, “Prepaid & Billed” as the shipping terms, and “None” / “NON” (non-taxable) for tax fields. |
| Salesperson (Salesman) | If a sales rep is assigned to the order in B2B Wave, B2B Wave checks your Fishbowl users and matches the first assigned sales rep’s full name (case-insensitive) to a Fishbowl user’s first and last name. When a match is found, B2B Wave sends that user’s Fishbowl username; otherwise, it sends the sales rep’s name. |
| Payment Terms | Uses the name of the order’s payment option in B2B Wave. If the order has no payment option, B2B Wave uses the matched customer’s default payment terms in Fishbowl, then a customer admin extra field named “Fishbowl_PaymentTerms” if present, and otherwise defaults to “NET 30.” |
| Products | Each line item includes the product’s (or variant’s) code/SKU, name, ordered quantity, final unit price, and unit of measure mapped to Fishbowl’s UOM abbreviation (such as “ea,” “kg,” “lbs,” “ft,” “in,” “cm,” “m,” “L,” “mL,” “gal,” “oz,” “floz,” “g,” “mg,” “mm,” “km,” “yd,” “ton,” “hr,” or “U,” defaulting to “ea” if unmapped). |
| Discounts | If the order has an order discount percentage greater than 0%, B2B Wave creates or updates a percentage discount in Fishbowl named “<percentage>% Discount” (for example, “10% Discount”) and adds a subtotal line and a discount line to the sales order. |
| Shipping | If the order has a shipping cost greater than 0 or a shipping option name, B2B Wave adds a shipping line item using the part number “Shipping & Handling” (with the shipping service or shipping option name as the description) and the order’s shipping cost. |
NOTE: If you use parent and sub-customers in Fishbowl or rely on a customer’s default payment terms in Fishbowl, make sure the customer already exists in Fishbowl with a name matching their “Company” name in B2B Wave before sending an order. In addition, once an order has been sent to Fishbowl, the “Create Fishbowl order” button on the order’s page is replaced by the Fishbowl order ID, so subsequent edits to the order cannot be re-sent from the order page.
Updating Tracking Numbers and Shipping Status
When “Update tracking numbers and shipping status” is checked on Fishbowl >Configuration, B2B Wave checks Fishbowl every hour for shipment updates on orders that were sent to Fishbowl (have a stored Fishbowl order ID) and do not yet have a tracking number in B2B Wave.
You can also run this check manually at any time:
Step 1. Go to Fishbowl >Update tracking numbers on your Admin Panel.
Step 2. Click “Update” and confirm the prompt. You’ll see the message “Updating tracking numbers and shipping status from Fishbowl scheduled.”

When B2B Wave finds shipment carton tracking numbers for an order in Fishbowl:
- The tracking number (or multiple carton tracking numbers separated by a comma) is saved to the order’s “Shipping tracking number” field.
- The order’s shipping option is updated to match the carrier name from Fishbowl. If no shipping option with that name exists in B2B Wave, B2B Wave creates one automatically.
- The order’s status is updated to match the shipment status in Fishbowl. If no order status with that name exists in B2B Wave, B2B Wave creates one automatically under Settings >Order Statuses.
- B2B Wave sends an order status update notification email to the customer.
Once an order has a tracking number in B2B Wave, it is no longer checked during future tracking updates.
Troubleshooting Error Messages
You may encounter an error message when testing your connection or sending an order to Fishbowl. Below are the most common messages and how to resolve them:
| Failed: Unknown username or password. NOTE: Usernames and Passwords are case-sensitive. | Verify that the “Username” and “Password” entered on Fishbowl >Configuration match an active Fishbowl user account with the exact capitalization, then click “Test Connection” again. |
| Failed: Timed out connecting to server or Fishbowl Error: Fishbowl: Request failed: Connection timed out. | B2B Wave could not reach your Fishbowl server. Check that “IP or URL” includes http:// or https:// without a trailing slash, that “Port” matches your Fishbowl REST API port, and that your firewall or router allows incoming connections to that port. |
| Fishbowl Error: Fishbowl order not created: the following products do not exist in Fishbowl: <list of codes> | “Product checking when creating an order” is set to “Do not create order in Fishbowl if all products do not already exist,” and one or more products on the order could not be found in Fishbowl. Either create those products in Fishbowl with matching product numbers, or switch “Product checking when creating an order” to “Automatically create product if product does not exist” and complete the field mapping. |
| Fishbowl Error: Fishbowl updatePPP import failed with status <code>: <details> | B2B Wave tried to create a missing part and product in Fishbowl before sending the order, and Fishbowl rejected the import. Check that all required fields in the “Fishbowl / B2B Wave Field Mapping” table are mapped and populated on the order’s products, and that any mapped units of measure or vendor names are valid in Fishbowl. |
| Fishbowl Error: Fishbowl: Request failed: <details> or Could not create Fishbowl order for order <ID> | Fishbowl rejected the sales order import. Make sure the customer’s “Company” name in B2B Wave exactly matches an existing customer in Fishbowl, the payment terms exist in Fishbowl, and the “Shipping & Handling” product exists in Fishbowl if the order includes shipping costs. |
| Fishbowl Error: Fishbowl: Login failed after 3 retries: <details> | B2B Wave’s stored session token expired and re-logging in failed three times. Go to Fishbowl >Configuration, verify your credentials and that the app is still approved in Fishbowl, and click “Test Connection.” |
NOTE: If you see any other error message or need help with custom UOM mappings, shipping part numbers, or product matching settings, please don’t hesitate to contact our support team.