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 in 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.

RMA Import

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 want to create new order statuses in WholeCell for this, you can do that on the Order Statuses Settings Page.

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:

Troubleshooting WooCommerce Sync Issues

  • The /shop URL for your WooCommerce store will not work in the WholeCell settings.

Did this answer your question?