Skip to main content

SKUSavvy integration setup

Map warehouses to locations, then set up two-way orders, SKU-matched products, inventory, and inbound stock transfers.

A
Written by Argo Ohvril

What syncs between Katana and SKUSavvy

Data flow between SKUSavvy and Katana

The table below shows how each type of data moves between Katana and SKUSavvy.

Data

Direction

Status

Orders

Two-way

Available

Products

SKUSavvy → Katana

Available

Inbound stock transfers

SKUSavvy → Katana

Available

Inventory sync

SKUSavvy → Katana

Available

Locations and mapping

After you connect SKUSavvy from Katana's Integrations page, the configuration screen opens on the Location tab. Each SKUSavvy warehouse maps to its own dedicated Katana location. Click Add to Katana to create that location automatically.

  • Not mapped: the warehouse hasn't been mapped yet. Click Add to Katana to create its location.

  • Unlink: pauses a mapped warehouse. Its status shows Unlinked.

  • Relink: resumes syncing for an unlinked warehouse.

Only mapped warehouses sync. Nothing syncs until you click Activate sync in the header.

the warehouse location mapping panel on the Location tab of the SKUSavvy configuration screen, listing SKUSavvy warehouses each paired with a dedicated Katana location, with an Add to Katana button on a warehouse marked Not mapped, Unlink and Relink actions, one warehouse showing the status Unlinked, and the Activate sync button in the header

Products sync

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

  • Direct 1:1: the SKUSavvy SKU and the Katana SKU are the same.

  • SKU aliases: the SKUSavvy SKU is linked to a different Katana SKU.

Products are imported by SKU:

  • A SKU that already exists in Katana is matched to that product.

  • An unknown SKU creates a new Katana product when it's needed.

Kits and bundles are imported as Katana products. Add a bill of materials (BOM) of components to them in Katana. A kit on an order still appears as a single sales order row.

the products mapping settings screen for SKUSavvy showing the SKU matching choice between direct 1:1 matching and matching via SKU aliases

SKU aliases

A SKU alias links a SKUSavvy SKU to a different Katana SKU. Use aliases when the same product is coded differently in the two systems. Upload your SKU alias mapping before you import products.

the products mapping screen with SKU alias mapping, showing SKUSavvy SKUs listed alongside the different Katana SKUs they are aliased to, and the option to upload a SKU alias mapping

Orders sync

From SKUSavvy to Katana

  • Orders import once they reach the import-from status you configure. The default is the Open state.

  • Imported orders keep updating automatically through every later status change.

  • Each SKUSavvy order becomes one Katana sales order, with one row per order line. The order source is SKUSavvy.

  • Each shipped package becomes a Katana fulfillment with its carrier and tracking number. A shipment with several packages creates one fulfillment per package. Together, these fulfillments never exceed the ordered quantities.

  • When an order is canceled in SKUSavvy, it's deleted in Katana only if the sales order is still open.

the order sync settings screen with the import and status options, showing the import-from status selector set to Open

From Katana to SKUSavvy

  • A Katana sales order is pushed to SKUSavvy as an outbound order when it reaches the Ready for fulfillment status.

  • After the push, its progress in SKUSavvy is tracked back in Katana.

  • Changes you make to the sales order in Katana after the push don't update the SKUSavvy order.

  • Canceling the Katana sales order doesn't cancel the SKUSavvy order.

the order push settings screen showing that Katana sales orders are sent to SKUSavvy as outbound orders when they reach the Ready for fulfillment status

Inventory sync

SKUSavvy stock levels appear in Katana as read-only External inventory at each warehouse's mapped location. The surfaced number is SKUSavvy's On hand quantity. You can't edit this inventory in Katana, and Katana never sends stock changes to SKUSavvy.

Reconciliation compares Katana's in-stock quantity with SKUSavvy's on-hand quantity. It runs on a schedule or on demand. Any differences are corrected with stock adjustments in Katana, so your stock figures reflect SKUSavvy's physical stock.

the inventory sync settings screen showing read-only External inventory on hand per mapped SKUSavvy warehouse location, with reconciliation schedule and run-on-demand options

Inbound shipments

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

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

  • Origin: the location you assign for each destination warehouse. This must be mapped.

  • The stock transfer tracks the inbound's status, and received quantities update the transfer.

  • Katana stock transfers move from in transit to received. Partial receipts show as updated expected and received quantities until the shipment is fully received.

  • Canceling an inbound in SKUSavvy deletes its stock transfer in Katana.

the inbound shipments screen showing a SKUSavvy inbound shipment as a Katana stock transfer with its PO number, origin and destination locations, status, and expected versus received quantities

What does not sync

  • Product changes from Katana aren't pushed to SKUSavvy.

  • Stock changes from Katana aren't pushed to SKUSavvy.

  • Changes to a Katana sales order after it has been pushed don't update the SKUSavvy order.

  • Canceling a Katana sales order doesn't cancel the pushed SKUSavvy order.

  • Returns and RMAs aren't synced.

  • Serial numbers aren't tracked. Lot and batch data appears read-only where SKUSavvy provides it.

Disconnecting

To disconnect, go to Katana's Integrations page and open the SKUSavvy integration. Once disconnected, syncing stops: no new orders, fulfillments, inbound shipments, or inventory updates are imported, and no sales orders are pushed to SKUSavvy. Records already imported into Katana stay in Katana, including sales orders, fulfillments, stock transfers, products, and stock adjustments.

Did this answer your question?