How to enable inventory sync from Skubana OMS

How to enable inventory sync from Skubana OMS

The following instructions explain how to properly configure and enable inventory sync from your Skubana account to your connected CartRover order sources using the CartRover Merchant account. 

Inventory Sync Workflow


The red arrows in the workflow above represent inventory levels passing from Skubana to CartRover and then from CartRover to each order source individually. The frequency of communication is set per workflow step (per arrow). The blue order source icons represent your connected "carts" such as WooCommerce, Groupon, Ebay, Magento, Wayfair, etc. 




How to Enable Inventory Sync


Step 1: Enable the inventory sync between Skubana and CartRover. (Workflow step 1 above)

  • Go to the Merchant tab → click Edit Setup → under the "Synchronization with WMS" section → change the "Inventory" field to the frequency in which you would like to sync inventory to CartRover.

Step 2: Wait for a sync to complete. To speed up this process, you can contact CartRover support to run an on-demand inventory sync.

  • The most frequent inventory sync can be set to run is once every hour. The very first sync may take hours to complete, depending on how many skus you have in Skubana. 

Step 3: Confirm the sync has completed 

  • Go to the Merchant tab and review the WMS Interface status for the last Inventory Run. If "success", the inventory sync has completed. If "N/A" and a timestamp are displayed, the inventory sync is currently in progress.


Step 4: Configure and enable the sync from CartRover to each individual order source (repeat per order source) (Workflow step 2 above)

  • The two questions you need to answer before enabling inventory sync to your order sources are: 
    1. Do the skus in the order source system/shopping cart match the Skubana Master SKU or do they match a particular Skubana Listing SKU?
    2. Should inventory from all Skubana warehouses be synced to the order source or only inventory from one Skubana warehouse?
  • Under the Carts tab → select the cart/order source you would like to enable inventory sync for → click Edit Setup → based on your answers to the two questions, please set the following fields:
    1. Sync Inventory Alias
    2. Sync Inventory With Warehouse
  • On the same page, under the Services section, set the "Inventory Upload" field to the frequency in which you would like inventory to sync from CartRover to the order source. Inventory sync is now enabled. 


How to view inventory sync data in CartRover

The most recent inventory sync data can be viewed in CartRover under the (Merchant tab > Products section). All data in this section is updated automatically. The information you can find in this section includes:

  1. A list of all Skubana products (master skus) and their corresponding aliases (listing skus).
  2. The most recently synced on-hand and available quantity from Skubana for each sku, broken down per Skubana warehouse and also totaled in a separate list.
  3. Select product details from Skubana (Description, weight, etc.)






Special Notes

Bundles

In order for bundle SKU inventory to sync from Skubana to your shopping carts, you must create a Stock entry for them in Skubana. Even if they will not be pre-assembled and the assembled quantity will be 0, there needs to be an inventory record for them so CartRover can see it. CartRover will then calculate the bundle quantity by adding up the pre-assembled quantity and the component quantity.

To setup a stock record for a bundle item:

  1. Go to the Skubana Inventory tab
  2. Click on the bundle item. Then on the right side of the Page (Stock Details), click on the desired warehouse.
  3. Click on + Create Stock button or + New Stock button, and type in 0 as On Hand. (You must type in 0 here. CartRover will perform calculation to figure out the actual bundle qty based on the components)

 Inventory Sync Mode

CartRover supports loading inventory data from Skubana in two different ways, per Sales Channel or Per Warehouse. You will find this setting in the Merchants > Edit Setup page of CartRover under "Inventory Sync Mode".

Inventory by Sales Channel

This is an abstraction of the warehouse inventory. Instead of CartRover seeing the warehouses you have set up, we see what inventory should be provided to each of your sales channels separately.
This is the more flexible option. It allows you to define in Skubana exactly what combination of inventory levels should be loaded into CartRover. In the simplest setup you can define a sales channel in Skubana and then tell it to use the inventory from the desired warehouses. You do this once per sales channel. In CartRover you will see those sales channel names displayed as "Warehouses." In the Cart settings of CartRover you must select the matching Skubana Sales Channel instead of using the default "Combine All Locations" option.

The main reasons to choose this method are:
  1. It's much more flexible. You can split inventory across the channels instead of sending the entire inventory to all channels. It also allows merging multiple warehouses in a fine-grained way that CartRover can not.
  2. It is more efficient. With this setting we can sync inventory faster. This starts becoming an issue when you get into the high thousands or tens of thousands of products.
  3. It works just like sales channels natively connected to Skubana.
The main disadvantage are:
  • It requires a little more set up to define the sales channel in Skubana and then also select it in CartRover.
  • If your sales channel requires a warehouse level breakdown, this method won't work. Very few sales channels require this however. Generally only EDI.

Inventory by Warehouse

This is the more straight-forward solution. CartRover receives the list of warehouses in Skubana and loads the inventory for each one. Then for each cart in CartRover you can have us sync your total combined inventory across all warehouses, or just a single specific warehouse. Additionally, when combining inventory you can disable some warehouses so that we don't include them when combining inventory (For example, an Amazon FBA warehouse). Read More.

The main reasons to choose this method are:
  1. There is less setup required
  2. This supports EDI channels that require warehouse level inventory breakdowns
The main disadvantage are:
  • With a large number of SKUs CartRover may have to slow down your inventory sync frequency less than hourly.
  • You can not setup fine grained inventory configurations that Skubana supports but CartRover does not.

Summary

Most merchants can use either method to get their desired setup working. In most cases one method is not required over the other. However, we generally recommend syncing per sales channel because it allows you to see and define what inventory is going to each sales channel in Skubana the same way you would for any sales channels you have natively connected to Skubana, not going through CartRover. The performance improvements in syncing by sales channel are drastic and can become a bottleneck for large merchants with high SKU counts.

    • Related Articles

    • Setting Up Skubana OMS

      Integration Specs: Supported functions: Order Send Inventory Sync Pickup Multi-Warehouse Support Product Detail Pickup Cancel Order in WMS Product Alias Pickup Shipment Confirmation Pickup - Detailed Required Parameters Skubana Username Skubana ...
    • Skubana OMS - Cannot acknowledge inventory for non-manual sales channels

      Problem CartRover displays the following alert when loading inventory from skubana oms Unable to download inventory adjustment from Skubana. SalesChannelID: xxxx. Invalid salesChannel type. Cannot acknowledge inventory for non-manual sales channels. ...
    • Skubana OMS Inventory Not Syncing (Sync Per Skubana Sales Channel Mode)

      Problem Products inventory levels in CartRover do not match with quantities in Skubana. CartRover is not pulling proper inventory levels from Skubana. Solution Note: Skubana only provides product updates to CartRover when inventory levels actually ...
    • Skubana OMS Settings

      This page details some of the various options available in your Skubana OMS connection. Inventory Settings Settings Description Default Other Options Inventory Sync Mode Defines how CartRover should assign inventory levels. i.e. assign by Sales ...
    • Joor to Skubana Integration

      CartRover integrates the Joor and Skubana systems very tightly for a seamless data flow keeping both systems in sync. With this setup: Joor acts as the frontend sales system that can be used to manage your linesheets. Skubana acts as the backend ...