Skip to main content

Hive integration setup

Set up Hive warehouse mapping, SKU product import with aliases, stock reconciliation, and inbound stock transfers.

A
Written by Argo Ohvril

What syncs between Katana and Hive

Data flow between Hive and Katana

The table below summarizes each data flow between Katana and Hive.

Data

Direction

Status

Products

Hive → Katana

Available

Inbound stock transfers

Hive → Katana

Available

Inventory sync

Hive → Katana

Available

Locations and mapping

After you connect Hive, the configuration screen opens on the Location tab. Each Hive warehouse maps 1:1 to its own dedicated Katana location.

  • Not mapped: A warehouse that has never been mapped shows this status. Click Add to Katana to create its Katana location automatically.

  • Unlinked: Click Unlink to pause syncing for a mapped warehouse. The warehouse then shows as Unlinked.

  • Relink: Click Relink to resume syncing for an Unlinked warehouse.

Only mapped warehouses sync.

the warehouse location mapping panel on the Location tab of the Hive configuration screen in Katana, listing Hive warehouses with their statuses (mapped, Unlinked, Not mapped) and the Add to Katana, Unlink, and Relink buttons

Products sync

Product mapping creates a required link between each Hive product and a Katana item. You choose how SKUs are matched:

  • Direct 1:1: The Hive SKU matches the Katana SKU exactly.

  • Via SKU aliases: A Hive SKU is matched to a different Katana SKU.

Products are imported by SKU. A Hive SKU that matches an existing Katana product links to it. An unknown SKU creates a new Katana product just in time.

Kits and bundles from Hive become Katana products. You can add a BOM of components to them in Katana.

the products mapping settings screen in the Hive integration in Katana, showing the choice between direct 1:1 SKU matching and matching via SKU aliases

SKU aliasing

An SKU alias links a Hive SKU to a Katana SKU that is written differently. Use an alias when the same item has a different SKU in Hive than in Katana. Upload your SKU alias mapping before you import products, so mismatched SKUs link to the right Katana items instead of creating new products.

the products mapping screen in the Hive integration in Katana with SKU alias mapping, showing Hive SKUs paired with different Katana SKUs and the option to upload an alias mapping

Inventory sync

Hive's stock numbers appear in Katana as read-only External inventory at each warehouse's mapped location. The number shown is Hive's On hand quantity.

Reconciliation compares Katana's in-stock quantity with Hive's on-hand quantity. It runs on a schedule, or on demand. When the two numbers differ, Katana creates stock adjustments for the difference. This keeps your Katana stock aligned with Hive's physical count.

the inventory sync settings screen in the Hive integration in Katana, showing read-only External inventory on-hand quantities per mapped location and reconciliation options for scheduled or on-demand runs

Inbound shipments

Each Hive inbound shipment becomes one Katana stock transfer. The transfer number is the PO number when one is present. Otherwise, it is the inbound ID.

  • Destination: The Katana location mapped to the inbound's Hive warehouse.

  • Origin: The location assigned for that destination warehouse. This location must be mapped.

The stock transfer tracks the inbound's status, and received quantities update the transfer. Katana stock transfers have two states: in transit and received. If Hive receives an inbound partially, the transfer shows updated expected and received quantities until everything is received. If an inbound is canceled in Hive, its stock transfer is deleted.

the inbound shipments screen in Katana showing a stock transfer created from a Hive inbound shipment, with transfer number, origin and destination locations, status, and expected versus received quantities

What does not sync

  • Orders. Hive orders are not imported into Katana, and Katana sales orders are not sent to Hive.

  • Fulfillments, carrier details, and tracking numbers.

  • Products and stock changes pushed from Katana to Hive. Katana only reads from Hive.

  • Returns and RMAs.

  • Serial-number tracking. Lot and batch data is shown read-only where Hive provides it.

Disconnecting

To disconnect, go to Katana's Integrations page and open the Hive integration. After you disconnect, Katana stops syncing with Hive right away. No new inventory, product, or inbound shipment updates come in.

Records Katana already imported stay in Katana. This includes products, locations, and stock transfers.

Did this answer your question?