Fishbowl - Data Mapper Integration

Fishbowl Inventory Management

📘

Requires FTP/SFTP or DropBox installed on the Fishbowl Advanced server.

Fishbowl Support can help with the setup of the FTP Folder if you are using the Fishbowl Hosted Service.

🚧

Requires configuring of the Fishbowl "Scheduler" module for the data flows.

Click here for Fishbowl Advanced - Schedule guide.

Zoey can integrate with Fishbowl Inventory through automated CSV export and import jobs.

Fishbowl has a built-in FTP server that the Zoey Data Mapper can access to get files for import or to upload files exported from Zoey. Please contact Fishbowl Support for help in setting up their end.

A Zoey Data Mapper will need to be set up to complete the import/export job. Click here to learn about setting up a connection and mapper.

Order Export Data Mapper Configuration

Below is an example of an Order Items export to Fishbowl.

Your mapper settings do not need to be exactly the same. But the above can serve as a reference template.

Next you must configure the Field Mappings to determine the data and column headers on the CSV file being generated.

That file will be sent to the FTP server or Dropbox based on the selected connection.

👍

You can export the export in Fishbowl by clicking Preview to download it and then manually uploading it to Fishbowl.

Zoey Export Orders to Fishbowl Field Mapping

Click here for Fishbowl CSV Field Mapping Template

Sync Inventory to Zoey from Fishbowl

Zoey can automatically pull in InventoryQTY exports from Fishbowl Scheduler via DropBox/FTP to ensure Zoey has accurate inventory available to sell.

Click here for Product Data Mappers. A mapper can automate the Product Import to update available stock quantity from the scheduled export in Fishbowl.

Create Shipments in Zoey from Fishbowl

Zoey can automatically pull ShipmentEDIExport data from Fishbowl Scheduler via DropBox/FTP. This will allow Zoey to send customers Shipping/Tracking details, as well as to automate the Invoicing/Payment Collection process.

Click here for Shipment import through Data Mapper.