Zen Cart

From Fishbowl

Jump to: navigation, search

Icon.Zen Cart.png The Zen Cart module, located in the Integrations group, is an add-on module that can be installed from the Small.Plugin.png Plugin module. After installing the plugin, a new module is added that integrates with one or more Zen Cart shopping carts.


Zen Cart.png

Jump to top of page

  1. In any Fishbowl Client, open the Small.Plugin.png Plugin module, located in the Integrations module group.
  2. Select the plugin and click Install Now.
  3. Completely close all Fishbowl Clients.
  4. Exit the Fishbowl Server by right-clicking the Fishbowl Server tray icon and selecting Exit.
  5. After re-opening the Fishbowl Server, the admin user can access the Small.Zen Cart.png Zen Cart module from any Fishbowl Client by opening the Integrations module group.
  6. To grant access to additional users, open the Small.User Group.png User Group module and assign the Zen Cart-View right to the appropriate groups as explained here.

Jump to top of page

To connect to Zen Cart, Fishbowl uses the default MySQL port (3306). Follow the steps below to establish the Zen Cart connection.

  1. Enter the Zen Cart store URL into the Small.Zen Cart.png Zen Cart module, for example carts.mycompany.com
  2. Enter the database username and password, as well as the database name.
  3. Click the Test Connection button in the Small.Zen Cart.png Zen Cart module to verify that the connection is valid and then click Save.

Multiple carts can be configured by clicking the New Button.png New button, which will add another Zen Cart tab.

Jump to top of page

The table below shows how data transfers between Zen Cart and Fishbowl.

Zen Cart Fishbowl
Zen Cart order
Sales order
Complete order
Fulfilled sales order
Available for sale inventory (only inventory that has changed since the last export will be updated)
Product name
Product number
Product description
Product description
Product model
Product ID
Zen Cart Product ID on Custom tab of the Small.Product.png Product module
Zen Cart order number
Customer PO field, Custom tab of the Small.Sales Order.png Sales Order module, sales order number (optional)
Order date
Fulfillment date
Customer name & address
Bill To and Ship To
Creates a new customer or uses the generic customer specified on the Schedule Import Order tab.
All taxes are combined into the tax item specified on the Schedule Import Order tab.
Email field of the Details tab of the Small.Sales Order.png Sales Order module


Jump to top of page

Zen Cart Settings Tab.png

Schedule Import Order
Jump to top of page

Zen Cart Schedule Import Order Tab.png

Schedule Export Order
Jump to top of page

Zen Cart Schedule Export Order Tab.png

Fishbowl can update the order in the shopping cart after items are fulfilled in Fishbowl. The shipment tracking number will also be exported to the shopping cart.

Schedule Products
Jump to top of page

Zen Cart Schedule Products Tab.png

Fishbowl only pulls products from Zen Cart. Products are not pushed from Fishbowl to Zen Cart. When pulling products to Fishbowl, the product sync should usually be scheduled to run before the order import. This will avoid any errors caused by new products that need to be imported before the order can be created in Fishbowl.

After installing the Zen Cart plugin, each product will have a Zen Cart Product ID custom field. When pulling products into Fishbowl, the product ID will be set automatically for products with matching SKUs. The correct product ID is required to successfully synchronize with Zen Cart.

Schedule Inventory
Jump to top of page

Zen Cart Schedule Inventory Tab.png


Release Notes

Version 3.0

Features and Fixes

Version 2.5

Features and Fixes

Version 2.4

Features and Fixes

Version 2.3

Released on 3/15/2017 - For Fishbowl version 2017.2 and higher

Version 2.2

Released on 2/9/2017

  • Resolution: The bill to address is now pulling with the order sync.

Version 2.1

Released on 8/11/2016

  • Resolution: Password now saves to utilize encryption key correctly.
Personal tools
Other Pages