Fishbowl Integration

The Fishbowl integration connects WizCommerce with Fishbowl Inventory using the Fishbowl REST API, so that products, customers, inventory, orders, and payments stay in sync between the two systems automatically.

This article explains how the connection works, what data flows in which direction, and how to handle the most common day-to-day scenarios.

Table of Contents

Before You Begin

1. Confirm with WizCommerce team which Fishbowl version you run and whether Fishbowl is on-premise or hosted.
2. Create a dedicated Fishbowl user for the integration and grant the read/write permissions WizCommerce team specifies.
3. If you want customers in WizCommerce mapped to Fishbowl pricelists, create the WizPricingScheme custom field in Fishbowl. This is required for accurate pricelist mapping between the two systems.
4. Note your Fishbowl server URL — the IP/domain and port. The default Fishbowl API port is 28192.

A. How Fishbowl Connection Works

WizCommerce team configures the WizCommerce-side integration with the Fishbowl credentials and server URL you provide. WizCommerce connects to Fishbowl using the Fishbowl REST API. Once configured, the first sync downloads products, customers, and inventory into WizCommerce, and the integration runs on an ongoing basis from there.

To complete setup, share the following with WizCommerce team through a secure channel:

• Fishbowl username (the dedicated integration user).
• Password for that user.
• Server URL (for example, http://192.168.1.100:28192/api/)

B. What Data Syncs Between Fishbowl and WizCommerce

The integration between Fishbowl and WizCommerce keeps your data in sync across both platforms. Below is a quick overview of the entities that sync, the direction of the data flow, and what each covers.

Product images and category images are not synced from Fishbowl, they must be uploaded manually in WizCommerce using the import service. Shipping charges are also not pushed to Fishbowl through the order push.

» Address mapping

Fishbowl supports multiple address types (Main Office, Bill-To, Ship-To):

• Default Main Office in Fishbowl → Default Billing Address in WizCommerce.
• Default Shipping in Fishbowl → Default Shipping Address in WizCommerce.
• Default Billing in WizCommerce → Main Office in Fishbowl.
• Non-default billing in WizCommerce → Bill-To in Fishbowl.
• All shipping addresses in WizCommerce → Ship-To in Fishbowl.

» Contact mapping

Fishbowl doesn't store contacts as a separate entity, contact details sit at the address level. Only Contact Name, Mobile, Email, and Main (Phone) are supported. Home, Fax, Pager, Web, and Other fields are not synced.

C. Sync Timing and the Sync Now Button

Payments and confirmed orders push to Fishbowl in real time. Other entities (inventory, customers, products) pull on an ongoing basis.

Click Sync now in WizCommerce to refresh orders and customers manually when you need the latest data without waiting for the next scheduled sync. For manual refreshes of inventory or products, contact WizCommerce team. 

D. Troubleshooting and Common Issues

» Orders aren't pushing because the Fishbowl login limit is reached

Fishbowl enforces a concurrent-user login limit on its database. If your team is using all available sessions, WizCommerce cannot push orders until a session frees up.

See the published FAQ How do I push an order when the Fishbowl login limit has been reached?.

» Order push failed with a duplicate order number error

Typical error: "CSV import do not have the correct format or contain incompatible data... Duplicate Order Number: WC_<number> Line Number: 3".

What to do: Confirm whether the order has already been imported into Fishbowl. If yes, the duplicate push can be safely ignored. If no, contact help@wizcommerce.com with the order ID, duplicate-number errors are usually a sequence/configuration issue.

» Order push failed because a product isn't in Fishbowl

If a product on the order line exists in WizCommerce but not in Fishbowl, the order will not push until the product is properly mapped. First, add the product in Fishbowl. Then choose one of these:

• Wait for the next sync. The product will automatically come into WizCommerce. Once it shows up, open the order, add the product, and push it again.
• Don't want to wait? Go to the product in WizCommerce and enter the reference ID from Fishbowl yourself. Then push the order again.

» Inventory in WizCommerce doesn't match Fishbowl

The available quantity shown in WizCommerce is calculated from your Fishbowl inventory using a formula (for e.g., qty_onhand − qty_allocated) that can be customised to match how your business tracks stock.

WizCommerce does not push inventory changes back to Fishbowl, so any manual edit made on the WizCommerce side will be overwritten on the next sync. Always make stock corrections in Fishbowl and let the integration carry them through to WizCommerce..

» Customer pricelist isn't being applied

Customers are mapped to WizCommerce pricelists through the WizPricingScheme custom field in Fishbowl. If a customer's pricelist isn't carrying through, confirm WizPricingScheme is created and populated correctly on the Fishbowl side.

» A customer's address fields are mapped to the "wrong" type

See the address mapping table in Section C, Fishbowl's address types (Main Office, Bill-To, Ship-To) translate to WizCommerce's Billing/Shipping addresses according to a fixed mapping. If you need a different mapping, contact WizCommerce team.

» I edited a confirmed order in WizCommerce but the change didn't reach Fishbowl

Once an order is confirmed in WizCommerce, it pushes to Fishbowl as an Estimate SO. No further edits are allowed on the order from the WizCommerce side, edits must be made in Fishbowl directly.

FAQs

1. Are product images synced from Fishbowl?

A. No. Product and category images must be uploaded manually in WizCommerce using the import service.

2. Can I push inventory changes from WizCommerce to Fishbowl?

A. No. Inventory only flows one way → Fishbowl to WizCommerce. Make stock corrections in Fishbowl.

3. What happens to orders if Fishbowl runs out of available logins?

A. The push fails until a session frees up. See the published FAQ on the Fishbowl login limit for the resolution.

4. Can I create an invoice in WizCommerce for a Fishbowl-integrated account?

A. No. Invoices are not created from WizCommerce for Fishbowl integrations.