All Collections
Integrations
Shopify
Import initial stock levels from Shopify to Katana
Import initial stock levels from Shopify to Katana

How to import initial stock levels from Shopify to Katana

Dayvid Lorbiecke avatar
Written by Dayvid Lorbiecke
Updated over a week ago

During the initial connection of Katana x Shopify integration, you can choose whether to import stock levels for products from Shopify to Katana.

We recommend importing your product stock levels from Shopify if you keep track of correct product stock levels in Shopify. This way, you can quickly get your stock levels from Shopify to Katana. You can then immediately see the Product Availability for all your Sales orders (SO) in Katana.

If switched ON, all inventory levels of products will be imported from Shopify to Katana. A Stock adjustment is created in Katana for recording those stock levels. Navigate to Stock screen > Stock adjustments in Katana to find the relevant Stock adjustment. Read more below about how the imported stock levels are calculated. You can edit the Stock adjustment at any time after it has been created.

During the initial connection, you need to determine the initial cost for the product stock for Katana. Read more here.

If switched OFF, stock levels for products will not be imported from Shopify to Katana.

Which stock levels are imported from Shopify?

Although one might assume that Shopify Inventory quantities are the same as the In stock quantities for products in Katana, this might not be the case for all your products. This is how the In stock quantity for products imported from Shopify is calculated in Katana:

In stock in Katana = Inventory quantity in Shopify + Inventory existing on open Sales orders

In Shopify, the Inventory quantity for a product displays the inventory available for sales. Therefore, Inventory in Shopify is decreased immediately when a SO is created, not when the SO is fulfilled.

In Katana, the In stock quantity for a product is not decreased when a SO is created and is still open, but only after the SO is Packed or Delivered. Commitments to open Sales orders are reflected in the Committed quantity for a product.

Therefore, the Inventory quantity in Shopify does not match with the In stock quantity in Katana. The difference comes from inventory that is committed to open sales orders.

When connecting Shopify to Katana, we import all open sales orders from Shopify to Katana. As a result, the Committed amount for related products increases in Katana. If you are looking to reconcile the stock levels imported from Shopify to Katana, then use the following calculation:

Inventory quantity in Shopify = In stock in Katana - Committed quantity in Katana

Example:

- The inventory quantity for "Product A" shows 7 pcs in Shopify.

- I have an "Unfulfilled" sales order in Shopify for 3 pcs of "Product A".

- When I connect Katana to Shopify and select to import initial stock to Katana, then the "In stock" quantity in Katana will show 10 pcs for "Product A". Katana will also import the open SO and display a Committed quantity for "Product A" of 3 pcs.

If you do not have any open Sales orders for a product, then the Inventory quantity in Shopify matches the In stock quantity in Katana.

When should I switch the initial stock import ON?

We recommend switching it ON during the initial connection of Shopify x Katana integration to get your stock levels easily into Katana. But import your product stock levels from Shopify only if you keep track of correct product stock levels in Shopify.

When you are reconnecting to Shopify or reconfiguring the integration settings, you are opt out from syncing stock levels by default. We suggest keeping it switched OFF to avoid importing double stock levels into Katana. Only switch it ON during reconnection or reconfiguration if you have cleared all your data in Katana and wish to start fresh, or if you have deleted the Stock adjustment that was created during the initial connection for recording stock levels in Katana.

If you have accidentally re-imported your stock levels in double, you can find and delete the related Stock adjustment that was created for recording the stock levels in Katana in Stock screen > Stock adjustments tab.

Note: If you are connecting multiple Shopify stores to your Katana account and have the same products across many stores, then be aware that importing initial stock levels for the same product from multiple Shopify stores will add stock levels to Katana more than once. If it has happened, it's relatively easy to fix it. Just find and delete the related Stock Adjustment that was created for recording the additional stock levels in Katana in Stock screen > Stock adjustments tab.

What if I have multiple Locations in Shopify?

Stock import from Shopify to Katana is Location-specific based on your Location mapping.

If you choose to import your Shopify stock quantities to Katana during the initial connection (read more) then the stock quantities from each mapped Shopify Location will be imported to the mapped Location in Katana.

If you have multiple Shopify POS Locations mapped to the same Katana Location, then the total sum of the inventory levels across all those Shopify POS Locations will be imported to the mapped Location in Katana.

All Shopify Locations that you have not selected will be mapped to the same Katana Location as your Shopify Online Store orders. Therefore, the total sum of stock from all those Shopify Locations will be imported to the Location in Katana that is mapped to your Shopify Online Store orders.

Did this answer your question?