All Collections
Integrations
Overview: How the WholeCell-eCommerce Integrations Work
Overview: How the WholeCell-eCommerce Integrations Work
Mike Banting avatar
Written by Mike Banting
Updated over a week ago

The WholeCell-eCommerce integrations work mostly the same way where the following are synced:

  • Inventory quantities (WholeCell β†’ eCommerce)

  • Listings (eCommerce β†’ WholeCell)

  • Orders (eCommerce β†’ WholeCell)

  • Shipments (WholeCell β†’ eCommerce)

There are some differences in how the integration works for these channels which you will find just by looking at the respective eCommerce settings pages and reading the Help articles, but the ones above are common to the integrations.

Note: we only mention Swappa, eBay, and Back Market here as these were the first three channels we built integrations with. However, the concepts explained in this article apply to all channel integrations.

Enable the Integration and Import Listings to WholeCell

If you have the same SKUs for your product listings in eCommerce channels like Swappa (as an Enterprise Seller), eBay, and Back Market, etc., those SKUs just need to be uploaded in WholeCell (your inventory too, of course). Then, enable the integration for Swappa, eBay, and Back Market, etc., import your listings from the channels to their respective settings pages in WholeCell.

Set Up Product Variation and SKUs in WholeCell

It's necessary that your eCommerce SKUs are also uploaded onto your WholeCell product catalog so that it will know which SKU you have an order for when one comes in and what listing to send quantity updates on.

Operation: Order Import and Listing Quantity Updates

Because you have the SKUs from the eCommerce channels in WholeCell and have now connected these systems, WholeCell can import the order from the channel and update the listing quantity, for example, the listing for iPhone X Silver 64GB Unlocked. If you had ten of these before, and now you have an open order for one piece (outstanding quantity) from Swappa showing on your WholeCell sales orders page, it will reduce the stock level/calculated quantity* to nine, which will also update the other channels. As soon as an order comes in, your calculated quantities get updated even without you getting to the order to fulfill it (scanning the stock to the order).

*Here's how the calculated quantity/stock level is computed.

Step-by-Step Process

Generally, the best way to start getting the integration working for you is by:

1) Uploading your eCommerce SKUs in WholeCell

2) Uploading your inventory in WholeCell

3) Enabling the eCommerce integrations and importing your listings to WholeCell.

Since the eCommerce SKUs are already uploaded in WholeCell, as soon as the listings are imported to WholeCell, they will be automatically connected to your WholeCell product variation SKUs.

See the following articles:

4) Enabling the ShipStation integration if you are using it to ship orders so that your shipment tracking number can be imported to WholeCell, and then WholeCell will send that to the E-commerce channel. Note that this does not apply to the Amazon integration.

See: ShipStation - Syncing with ShipStation

Here's an illustration of how the order creation and fulfillment flow for an E-commerce integration with WholeCell, in this example, Swappa (the same thing happens for the other channels).

5) Fulfill the orders as they come by committing the inventory on that order.

When an order comes in and it shows "Unknown SKU" instead of the product's name from the listing, that means that SKU was not in WholeCell when the order came in. So you need to make sure all your SKUs are in WholeCell so that listing quantities can get updated. To correct this, upload your SKU and then hit 'Refresh' under "Unknown SKU" or you can edit it by connecting that unknown SKU to a product variation in WholeCell. If you commit an inventory to this order without uploading the SKU, WholeCell will not connect that committed inventory to this order item and it will create another line below the original order item. Because the inventory that you committed to the order is not associated with the listing's SKU, the updated quantity for that inventory will not be synced to the channel.

Tips

  • Best to have the same SKUs across all E-commerce channels

  • When a new listing is created in the channel, make sure to upload the new SKU in WholeCell and then import that listing in WholeCell (click the 'Sync Listings' button on the Listings tab of the channel's settings page in WholeCell)

  • If you have variation listings, upload all the SKUs connected to that listing in WholeCell and add them to the channel's listing settings (see the example below)

Did this answer your question?