Common Fishbowl Client Tasks
Sync Product Data into Fishbowl
View Location: Integrations > WooCommerce - Product Import
Currently this is configured to be run as an automatic cron job from the Fishbowl server. This is configured to sync product data every 15 minutes.
To run a fresh import, click the "Run Task" button. This will add a job into the background queue for the server to request product data.
The Fishbowl API request to /wc/v2/products will pass an after parameter. This parameter comes from the 'Last Sync' field and modifies the API query for data that has not been synced since that datetime.
There are modifications in place that change this behavior, see: SDM Dealers Integration
Fix Fishbowl Product Mapping
Overview of the Problem
Fishbowl internally maps all data via the Product Num field, but still stores the WooCommerce product ID behind the scenes for its API communication. The product num field is mapped and created from the product SKU during the first import of the product's data.
Occasionally, Fishbowl will import incorrect or out-of-date product data. For example, a draft product before its SKU and appropriate data have been created. Once this incorrect product data is imported into Fishbowl all data will continue to be mapped to this incorrect SKU.
We have taken steps to prevent this issue from happening to begin with, see SDM Dealers Integration.
How to Fix
Real Example
There is a product in the fishbowl pulling a premature name and SKU. It appears as Scottsdale Dragon Stacker® 1 oz Silver Round (copy) SKU: SSTACK-DRAGON1SR-1. The correct version of the product that is being ordered in Woo is Scottsdale Dragon Stacker® 2 oz Silver Round SKU: SSTACK-DRAGON2SR. The team is not sure how to permanently update or change this, so when they print orders, it says the correct item.
View Location: Materials > Product
First, in WooCommerce, find the correct, updated product: "Scottsdale Dragon Stacker® 2 oz Silver Round." Note its ID in WooCommerce: #16659.
Second, in Fishbowl, find the product with the incorrect mapping. Since the SKUs were similar, both appear in the same search (1). Then, by double-clicking the product in the left side bar, the product details will load on the right (2).
Next, once you are viewing the incorrect product details (SSTACK-DRAGON1SR-1). Click on the WooCommerce button in the product view navigation. This will open the "Product Data" window, where you can see what WooCommerce ID is mapped to this product.
When you open the correctly imported product's details (SSTACK-DRAGON2SR), you will see that the same WooCommerce ID is mapped to both products. So both these products are mapped to the same Woo ID.
Note: From my understanding, once data is imported into the Fishbowl server, Fishbowl internally uses the Product Num field to match and control the data. But to communicate with the WooCommerce API and pull product information, it still needs to store the Woo ID.
So in this case, I believe the issue is that the same Woo ID is mapped to two products in the Fishbowl system. To resolve this, I opened the details for the incorrect product (SSTACK-DRAGON1SR-1), then opened the WooCommerce product data modal. And deleted the WooCommerce mapping entry.
The correct product (SSTACK-DRAGON2SR) still has the Woo ID mapped, but it is now the only product with this ID mapping in Fishbowl.