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.
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
Enabling Order Import will automatically import any new orders from your WooCommerce store. These imports run every 10-20 minutes.
This will automatically import new listings (called 'Products' in WooCommerce) that you create in your WooCommerce shop.
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:
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.
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:
**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.
Troubleshooting WooCommerce Sync Issues
The /shop URL for your WooCommerce store will not work in the WholeCell settings.