Skip to main content

WooCommerce Module

This page documents how the Fishbowl WooCommerce module is installed, configured, and operated for Scottsdale Mint workflows.

Source: Fishbowl Advanced - WooCommerce

What It Does​

The WooCommerce module is an integration add-on in Fishbowl that syncs commerce operations between WooCommerce and Fishbowl, including:

  • Order import
  • Fulfillment export
  • Product import/export
  • Inventory updates

Install​

  1. In Fishbowl Client, open Plugin in the Integrations group.
  2. Select WooCommerce and click Install.
  3. Close all Fishbowl Clients.
  4. Exit and restart Fishbowl Server.
  5. Open the WooCommerce module from Integrations.
  6. Grant access rights (WooCommerce-View) in User Group for additional users.

Initial Setup​

WordPress/WooCommerce Side​

  1. In WordPress admin, go to Settings -> Permalinks.
  2. Set Common Settings to Post name.
  3. Verify Product permalink base is Default (or custom base product/).
  4. In WooCommerce -> Settings -> Advanced -> REST API, create API keys.
  5. Generate a Read/Write key for an admin-level WooCommerce user (required for metadata access).
  6. Copy Store URL, Consumer Key, and Consumer Secret.

Fishbowl Side​

  1. Open WooCommerce module settings.
  2. Paste Store URL, Consumer Key, and Consumer Secret.
  3. Use Test Connection.
  4. Open Advanced Settings when needed:
    • Enable Meta Data Mapping
    • Pull Meta Data (from recent orders/customers/products)
    • Enable specific metadata groups (order, order item, customer, product, variant)
  5. Save settings.

Module Tabs and Operational Use​

Manually Running Sync Tasks​

To manually run WooCommerce sync tasks in Fishbowl:

  1. Open Integrations -> WooCommerce.
  2. Select the tab you want to run:
  • Order Import
  • Product Import
  1. Review or update sync settings on that tab.
  2. Click the green Run Task button to execute the selected task immediately.

Notes:

  • Use Order Import when you want to immediately pull eligible WooCommerce orders into Fishbowl.
  • Use Product Import when you want to immediately pull WooCommerce product data into Fishbowl.
  • The selected tab's current settings (including mapping and Last Sync behavior) control the run.

Order Import​

Primary purpose: bring eligible WooCommerce orders into Fishbowl based on status mapping and field mapping.

How Last Sync Filtering Works​

For Order Import, Fishbowl uses the WooCommerce REST API V2 with the after parameter to request only orders created after the Last Sync timestamp (using Fishbowl time).

Important behavior:

  • The pull window is based on the WordPress post created date.
  • The pull is not based on the WordPress modified date.

Practical impact:

  • If an older order is edited in WooCommerce, Order Import may not pull it if its original created date is before Last Sync.
  • To force a broader pull, set Last Sync to an older date and run Order Import again.

Example URL:

https://dealers.scottsdalemint.com/wp-json/wc/v2/orders?page=1&per_page=100&status=processing&after=2026-07-06T23:45:01&consumer_key=REDACTED&consumer_secret=REDACTED

Key areas:

  • Order Settings: order header mapping, defaults (salesperson/class/terms/priority), optional prefix
  • Order Item Settings: item mapping, shipping item behavior, product linking logic
  • Order Status Settings: only mapped statuses are imported; Historical status imports without inventory/accounting impact
  • Location Group Settings: route by default, ship-to state, or carrier; supports metadata-based mapping
  • Customer Settings: default customer model vs unique customer import, including wholesale/retail behavior
  • Address Settings: bill-to/ship-to mapping, coalescing, missing states, residential flag
  • Carrier Settings: default carrier or carrier mapping
  • Payment Settings: payment creation/mapping options and adjustments
  • Tax Settings: import tax lines, tax item mapping, Fishbowl tax options
  • International options: extra tax behavior for Canada/Australia/international workflows

Scheduling notes:

  • Tasks can run on schedule or manually via Run task
  • Last Sync controls the change window used for synchronization

Fulfillment Export​

Primary purpose: send shipment/fulfillment updates from Fishbowl back to WooCommerce.

Key options:

  • Update order status on fulfilled shipments
  • Check order status before exporting to avoid duplicate fulfillment attempts
  • Optional shipment carrier + tracking sync (requires WooCommerce Shipment Tracking extension)

Product Import​

Primary purpose: pull products from WooCommerce into Fishbowl and create links by WooCommerce product ID.

How Last Sync Filtering Works​

For Product Import, Fishbowl uses the WooCommerce REST API V2 with the after parameter to request only products created after the Last Sync timestamp (using Fishbowl time).

Important behavior:

  • The pull window is based on the WordPress post created date.
  • The pull is not based on the WordPress modified date.

Practical impact:

  • If an older product is edited in WooCommerce, Product Import may not pull it if its original created date is before Last Sync.
  • To force a broader pull, set Last Sync to an older date and run Product Import again.

Example URL:

https://dealers.scottsdalemint.com/wp-json/wc/v2/products?page=1&per_page=100&after=2026-07-07T00:30:04

Key options:

  • Link Existing Products by mapped fields
  • Import Products for new product creation in Fishbowl

Initial load tip:

  • Set Last Sync to a very old date (for example, year 2000) to include full catalog on first import.

Product Export​

Primary purpose: publish Fishbowl product data to WooCommerce.

Key options:

  • Export New Products (create flow)
  • Update Linked Products (update flow)
  • Product Tree Filter to scope export set
  • Weight/size UOM conversion during export when configured

Inventory Update​

Primary purpose: push inventory quantities from Fishbowl to WooCommerce.

Key options:

  • Company-wide vs selected location groups
  • Inventory type selection:
    • Available For Sale
    • Inventory On Hand
    • Available To Pick
    • Available To Kit (kit quantity behavior)
  • Product tree filter
  • Min/Max quantity overrides
  • Include quantities available to build (can increase oversell risk in some scenarios)

Initial load tip:

  • For first-time setup, backdate Last Sync to include all relevant products.

Troubleshooting and Monitoring​

  • Use API Logs in the WooCommerce module to inspect API calls/errors
  • Plugin logs are also available in C:\Program Files\Fishbowl\logs\plugins
  • Scheduled tasks are visible in Schedule module (run manually, review history, configure notifications)
  • Use Data -> Server Log for recent detailed errors
  • For Scottsdale Mint server-side diagnostics, review Server Administration
  • Check the fbserver log at C:\Program Files\Fishbowl\logs for request and process-level errors during import/export runs
  • Verify only one WooCommerce plugin JAR version exists in Fishbowl plugins directory
  • If upgrade-related scheduled task failures occur, reinstall plugin and re-enter settings

Known behavior notes:

  • Only new orders are imported; imported orders are not updated later
  • Returns/refunds are not imported
  • Plugin support is documented for WooCommerce REST API V2