WholeCell's WooCommerce integration automates listing quantity updating, order management and fulfillment, and shipment information exporting between WholeCell and WooCommerce.
This integration syncs:
Listings (WooCommerce → WholeCell)
Listing Quantities (WholeCell → WooCommerce)
Orders (WooCommerce → WholeCell)
Shipments (WholeCell → WooCommerce) *shipment tracking required
RMAs (WooCommerce → WholeCell)
Enabling the Integration
This guide assumes that you've already set up your WordPress website and installed WooCommerce.
You can turn on the WooCommerce integration in WholeCell from Settings > WooCommerce:
First, enter your store website's root URL. Don't link to the "/shop" URL because it will not work. To look for the store's URL, go to WooCommerce Settings, then click on "General", then look for the "Site Address (URL)".
Next, generate your API Key from your WooCommerce Settings. Go to your WordPress admin page then Settings > Advanced > Rest API:
Now click Add key:
Create a key and make sure to choose "Read/Write" permissions:
Copy your "Consumer Key" and "Consumer Secret" and paste these into your WooCommerce Settings page in WholeCell.
Configuring the Integration
Order Import
Enabling Order Import will automatically import any new orders from your WooCommerce store. These imports run every 10-20 minutes.
Listings Import
This will automatically import new listings (called 'Products' in WooCommerce) that you create in your WooCommerce shop.
Order Statuses
You need to map WooCommerce's order statuses to your WholeCell order statuses for orders to be imported. If you need to create new order statuses in WholeCell for this, follow the instructions in this article to do so: Managing Sales Order Statuses.
Inventory Quantity Sync
When you enable Inventory Quantity Sync WholeCell will begin to update the quantities of your WooCommerce listings every 10-20 minutes based on the calculated quantities of associated Product Variations or SKUs in WholeCell.
This will update your WooCommerce listings immediately so make sure you have the correct inventory quantities in your WholeCell account before you enable this for the first time.
The stock quantities that will sync with your listings will be the calculated quantity of connected products, which is defined here:
Inventory Statuses
With Inventory Quantity Sync enabled, choose the inventory statuses which should count towards your total calculated quantity of available inventory to update your WooCommerce listings with.
Warehouses
With Inventory Quantity Sync enabled, choose which warehouse(s)' inventory should count towards your total calculated quantity of available inventory to update your WooCommerce listings with.
Importing Your WooCommerce Listings
Once the integration is enabled you can import your WooCommerce listings to WholeCell from the Listings tab by clicking on 'Sync Listings':
This button will import new WooCommerce listings and import updated quantities from existing listings that WholeCell had already imported previously. It will not sync current listing quantities from WholeCell to WooCommerce.
Mapping your WooCommerce Listings
Once you import your WooCommerce listings you'll see which have imported with a recognized SKU that has automatically connected and which listings are unrecognized:
Clicking on any listing title will take you to a page where you can see if the listing is mapped correctly to a Product Variation or SKU. This listing imported with a SKU that exists in our WholeCell product catalog in this demo account, so it was automatically recognized and linked.
You can choose to manually connect listings to a single SKU, multiple SKUs, or specific Product Variations if you're not using SKUs.
Syncing Orders and Shipments
As you receive orders on WooCommerce they will automatically import to WholeCell.
If you are also using the ShipStation integration and you create a shipment in ShipStation, the tracking number will be automatically imported to WholeCell and then to WooCommerce:
**If you have not created the sales channel's name in WholeCell yet, you can do that here. WholeCell will not be able to sync orders to ShipStation if your sales channels don't exactly match (case sensitive) the channel names that the integration uses -- like "WooCommerce", in this case. Changing these channel names will prevent the sync from working. After creating the channel name, put a check in the box here if you want to sync orders with ShipStation:
Important Notes or Reminders
When you enable 'Order Import' and receive orders with unknown SKUs, you won't be able to map different SKUs for the order item (e.g. mapping a WholeCell SKU to the channel's listing's SKU settings page in WholeCell). Even if you map the WholeCell SKU for that listing in WholeCell, the order item will still show "Unknown SKU". The only way to make those SKUs be recognized is to add them to the WholeCell product catalog. To proceed, you can either do a 'Direct Commit', or delete the order item and just commit whatever item you want to fulfill the channel order.
Troubleshooting WooCommerce Sync Issues
The /shop URL for your WooCommerce store will not work in the WholeCell settings.
If you have a caching setup, that may cause your server to return the same results (when importing orders) for multiple days.
The listing quantities are not being updated
Has the listing been imported to WholeCell?
Is the listing connected?
Does the listing show active or ended?
Is the 'Enable Inventory Sync' box checked?
Is the warehouse set on the inventory items you want to sync?
If an order comes in and shows "Unknown SKU", check:
Are there matching SKUs in both WooCommerce and WholeCell?
Have all of your listings been imported to WholeCell?
If your orders are not coming into WholeCell, check:
Is the 'Enable Order Import' box checked?
Multi-variation listing quantities are not synced
Does each listing have matching SKUs in WooCommerce and WholeCell? Are they all showing 'Connected'?
The outstanding count on the listing is incorrect
Check which sales order statuses are supposed to count toward open orders
Check if the 'Shipped' and 'Canceled' order statuses are set to count toward open orders
Are your listings being set to out-of-stock even though WholeCell is actively syncing non-zero quantities? Check to see if you have other eCommerce software connected to the channel.
If you can't find the listing on the channel's settings page in WholeCell, make sure to search using the listing ID and not the SKU.