Fishbowl Inventory + Orderwerks
Give your Fishbowl customers a branded B2B ordering portal with real-time inventory visibility
Full bidirectional sync - products, customers, inventory, sales orders, and shipments
Professional setup included with your Orderwerks subscription
.png&w=640&q=75)
Key Benefits
Bidirectional product sync - pull your entire Fishbowl product catalog including SKU, UPC, pricing, dimensions, weight, and units of measure
Real-time inventory visibility - customers see available quantity (on-hand minus allocated) per warehouse before they order
Customer sync with full address mapping - import customers with bill-to, ship-to, tax rates, payment terms, carrier preferences, and credit limits
Sales order push - orders from your portal or field reps create sales orders in Fishbowl automatically with line items, pricing, and PO numbers
Automatic shipment tracking - Orderwerks pulls shipments from Fishbowl, updates order status, and emails customers tracking information
Multi-warehouse support - filter products and inventory by Fishbowl location group for warehouse-specific catalogs
B2B Ordering Portal Features
More than just an integration - a complete B2B ordering portal for your customers
B2B Ordering Portal
Your customers get a branded portal to place orders 24/7 - backed by real-time Fishbowl inventory. No more overselling.
Customer-Specific Pricing
Set up pricing tiers managed in Orderwerks while customer records stay synced with Fishbowl. Each customer sees their negotiated rates.
Order History & Reordering
Customers view past orders and reorder with one click. Orders push to Fishbowl as sales orders automatically.
Real-Time Inventory Visibility
Inventory levels pull directly from Fishbowl's quantity available calculation - on-hand minus allocated minus unavailable. Multi-warehouse aware.
Mobile Ordering for Sales Reps
Sales reps enter orders from any device - works offline and syncs when back in range. Orders flow to Fishbowl the same as portal orders.
Shipment Tracking & Notifications
Orderwerks pulls shipment data from Fishbowl including carrier, tracking number, and ship date. Customers get automatic shipment emails.
Popular Industries Using This Integration
How It Works
Connect to Fishbowl
Configure your Fishbowl server host, port, and credentials in Orderwerks. We connect directly to your Fishbowl database via the Fishbowl API.
Sync Your Data
Pull products, inventory, and customers from Fishbowl. Choose which location group to sync. Map salesman assignments to Orderwerks rep groups.
Orders Flow Both Ways
Customers place orders through your portal. Orders push to Fishbowl as sales orders. Shipments pull back automatically with tracking info.
Detailed Features
Product & Catalog Synchronization
Pull your complete product catalog from Fishbowl including part number, SKU, UPC, description, pricing, units of measure, dimensions, and weight. Products are matched by SKU or Fishbowl product number to prevent duplicates. Active/inactive status syncs automatically.
Inventory Management
Inventory syncs using Fishbowl's own available quantity calculation - on-hand minus allocated minus unavailable plus dropship. Filter by location group for multi-warehouse operations. Catalog shows real-time stock levels to prevent overselling.
Sales Order Creation
Orders placed through your B2B portal or by field sales reps are pushed to Fishbowl as fully formed sales orders with line items, customer-specific pricing, bill-to and ship-to addresses, carrier information, payment terms, tax rates, PO numbers, and notes. Each sales order links back to the original Orderwerks order for easy cross-reference.
Shipment Synchronization
Orderwerks automatically pulls shipment data from Fishbowl including sales order number, tracking number, carrier name, carrier service, ship-to details, and shipment date. Shipment records are created in Orderwerks and linked to the original order. Order status updates to 'Shipped' automatically. Customers receive shipment notification emails with tracking information.
Setup Information
Requirements
- •Fishbowl Inventory installation
- •Fishbowl API access (host + port)
- •Fishbowl user credentials with API permissions
- •Orderwerks account
Timeline
30-60 minutes during onboarding
What's Included
- Server connection setup
- Product sync configuration
- Customer import
- Location group mapping
- Sales order workflow setup
- Shipment sync configuration
- Rep group / salesman mapping
- Ongoing sync monitoring
Frequently Asked Questions
Does Orderwerks connect directly to Fishbowl?
Yes. Orderwerks connects directly to your Fishbowl server via the Fishbowl API using your server host, port, and credentials. The connection is encrypted and managed securely - your Fishbowl credentials are never stored in plain text.
What data syncs between Fishbowl and Orderwerks?
Products, inventory levels, customers (with addresses, tax rates, payment terms, and carrier preferences), sales orders (with full line items and pricing), and shipments (with tracking numbers and carrier information). Product and customer sync is pull-from-Fishbowl. Sales orders push to Fishbowl. Shipments pull from Fishbowl.
Does the integration support multiple warehouses?
Yes. Orderwerks supports Fishbowl location groups. You can filter product and inventory sync by specific location groups, enabling warehouse-specific catalogs with accurate available inventory per location.
How do sales orders get created in Fishbowl?
When an order is confirmed in Orderwerks - whether placed by a customer on your portal or by a field rep on the mobile app - it pushes to Fishbowl as a sales order with all line items, customer-specific pricing, addresses, carrier information, payment terms, and PO numbers. The Fishbowl SO number links back to the Orderwerks order automatically.
Does Orderwerks pull shipment tracking from Fishbowl?
Yes. Orderwerks periodically queries Fishbowl for new shipments and automatically creates shipment records with tracking numbers, carrier information, and ship dates. The associated order status updates to 'Shipped' and customers receive an automatic email notification with tracking details.
Can I use Fishbowl and QuickBooks together with Orderwerks?
Fishbowl users typically use Fishbowl as their inventory and warehouse management system alongside QuickBooks for accounting. Orderwerks can integrate with Fishbowl for product, inventory, and order sync while your Fishbowl-to-QuickBooks connection handles the accounting side.
Ready to Connect Fishbowl Inventory?
Professional setup included with your Orderwerks subscription
Related Content
QuickBooks Online
AccountingIntuit Certified Integration for Seamless Order-to-Invoice Workflow
QuickBooks Desktop
AccountingGive your B2B customers a 24/7 ordering portal that syncs with QuickBooks Desktop and Enterprise
Fishbowl Inventory Getting Started
GuideStep-by-step guide to connecting Fishbowl Inventory with Orderwerks and configuring product, customer, and order sync.
